Jul 12 2022 01:12 AM
Hi all experts,
Try to download history of DOW, NASDAQ, S&P and HKSE.
Thanks,
Eric
Jul 12 2022 06:10 AM
Jul 12 2022 10:12 AM
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
Jul 12 2022 05:09 PM
Jul 12 2022 05:10 PM
Jul 12 2022 10:48 PM
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...
Jul 13 2022 02:01 AM
@L z. 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
Jul 13 2022 02:28 AM
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
Jul 13 2022 05:07 AM
Jul 13 2022 05:45 AM
This means you didn't use the workbook I shared where Privacy Levels are disabled (something I'd like to address but pretty hard in this scenario...)
Within Excel:
- Go to Data (tab) > Get Data > Query Options
- Under CURRENT WORKBOOK > Privacy
- Select option Ignore the Privacy Levels and potentually improve performances > OK
Jul 13 2022 06:44 AM - edited Jul 13 2022 09:18 AM
SolutionFound a decent way not ignoring Privacy Levels. How To section updated accordingly
File attached
Jul 14 2022 01:21 AM
@L z. awesome, worked wonderfully and thanks for doing all the heavy lifting for me. Thanks.
Jul 14 2022 11:56 PM
Glad I could help @Eric9919 & Thanks for providing feedback
Sep 10 2022 01:38 AM
Sep 16 2022 12:38 AM
I'm afraid I don't understand what you want/expect as the query already provides daily prices for the Period you select when invoking function NewHistoryDownload