Forum Discussion
Does STOCKHISTORY work for INDICES? Where can I find the symbols?
Hi all experts,
Try to download history of DOW, NASDAQ, S&P and HKSE.
Thanks,
Eric
Hi Eric9919
If this can help & assuming you run a Windows version of Excel. Attached is a Power Query based "solution" that downloads history from Yahoo Finance. Put this together a year a ago for this thread (the OP was smart enough not to provide any feedback...) and enhanced it in the meantime
Just checked ==> still work 🙂
- Thanks. It is working for Stock Tickers, but I am actually looking for market indices.
Re. It is working for Stock Tickers, but I am actually looking for market indices
Not sure I understand but this might be due to my ignorance in investment terms
Below is what STOCKHISTORY's function downloads for the NASDAQ Composite Index + on the right what the query downloads from Yahoo finance for symbol ^IXIC. (symbol from page World Indices). With the exception of the [Volume]* not sure I see where the difference is:
* Checked a couple other websites but they don't provide volume information
==> No idea which of the above ones is right
Attached file contains a few index/indices, inc. HKSE (Hang Seng Index) but this might not be what you expect...
- Thanks. I was able to find below 3 indices using Stock Data Type search, but only NASDAQ. worked. And I can't find Hong Kong Stock Exchange (Hang Seng Index). Any idea?
S&P 500 INDEX
NASDAQ Composite Index
DOW JONES INDU AVERAGE NDX
Thanks,
