Downloading Stock and Fund data into Excel

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?

0 Replies

Recent Posts

in General Discussion at YDN