Forum Discussion
Eric9919
Jul 12, 2022Copper Contributor
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
- Jul 13, 2022
Found a decent way not ignoring Privacy Levels. How To section updated accordingly
File attached
Lorenzo
Jul 12, 2022Silver Contributor
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 🙂
Eric9919
Jul 13, 2022Copper Contributor
Thanks. It is working for Stock Tickers, but I am actually looking for market indices.
- LorenzoJul 13, 2022Silver Contributor
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...
- Eric9919Jul 13, 2022Copper Contributor
Lorenzo Thanks and you understood correctly.
I was able to use STOCKHISTORY to download only NASDAQ history, but not the others.
And thanks for your sample XLSX and I will try it for sure.
Cheers,
Eric
- LorenzoJul 13, 2022Silver Contributor
I searched a bit the Net and it seems that the unability to download (via STOCKHISTORY) the S&P 500 and Dow Jones Industry indexes/indices is a well known issue right now. I tried a bunch of approaches with the 4-character ISO market identifier code (MIC) to no avail. ==> #VALUE!
Re. the Power Query query to Yahoo finance
If you want to remove i.e. the [Volume] column and/or change the order of the columns, let me know, this is a one minute change
If the "tool" does what you expect and is an acceptable workaround from your point of you, it would be nice you mark as solution one of the replies with the attached .xlsx ==> Can help those who search - Thanks in advance