I'm using Excel Web Queries to download Prev Close stock prices into a spreadsheet. So, for example, I form a query such as this:
n0 returns Name, p0 returns Prev Close.
I parse the CSV that's returned into formatted columns. It works fine for Stocks (e.g. BARC.L as above).
However, I also want to get the Prev Close price for Tracker Funds.
I can see the data on the website (e.g. http://uk.finance.yahoo.com/q?s=GB0033138024.L&ql=1), but when I formulate the corresponding web query, all I get back are 'n/a' strings.
Similarly, if I use the "Download data (delayed)" link on the website, I also just get "n/a", as follows:
GB0033138024.L 0 N/A 4:52am N/A N/A N/A N/A N/A
So, my question is, is there a different Tag Code for the Prev Close price for a Fund, or is this information simply not available to download for anything other than Stocks?
in General Discussion at YDN