View Single Post
Old 10-11-2017, 08:56 AM   #37
stjoe1
Member
 
Join Date: Dec 2005
Posts: 467
you meant you just go into the website and take a look manually right?
No use web scraping formula.. Importxml to get the data directly to googlesheet..

You can use this formula to get the last done price for FCL bond with stock code AXXZ. For other bonds/pref shares, just change AXXZ with their stock codes.

=ImportXML("http://www.shareinvestor.com/fundamental/factsheet.html?counter=AXXZ", "//td[@class='sic_lastdone']/strong")

Last edited by stjoe1; 10-11-2017 at 09:35 AM..
stjoe1 is offline   Reply With Quote