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
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |