View Single Post
Old 08-11-2017, 03:26 PM   #29
mrwirus
Senior Member
 
Join Date: Jun 2006
Posts: 1,676
Maybe You can post a screenshot of your spreadsheet and error? It is working on my spreadsheet.

In the code, you need to key in the ticker into a cell, and then replace the F3 with the coordinate of the cell where you keyed in the ticker.
ohhh.. I got it working.. Maybe I very manual.. haha.. every cell I will key in the ticker manually..

=IMPORTXML("http://quotes.wsj.com/SG/AJBU","//span[@class='cr_num cr_curr_price']/span[@id='quote_val']")

This will get Keppel DC Reit pricing.. Now I know..

Thanks alot for all your help!
mrwirus is offline   Reply With Quote