How to get Alibaba share close price from yahoo finance to sheet cell B1

Hi All ,

This is my first post here.  
Now I manually data entry all the 50 stock I follow into sheet which take up a lot of my time.  I try to google around ,

I ask AI for the script , I paste below script to my iOS sheet app cell B1 :-

=IMPORTXML("https://finance.yahoo.com/quote/", "//span[@data-reactid='50']")

I get error massage #REF!

Where go wrong ?

hope some one can share with me a sheet file , I can copy the example file to my google drive , when I open , I can see Alibaba share price appear on Cell B1.

Thank You

0 0 73
0 REPLIES 0
Top Labels in this Space