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
Silver Contributor
Added 3 years, 4 years & 5 years
If you (or anybody else) need something more specific options please refer to How to Load Historical Stock Prices from Yahoo Finance then, in the attached workbook, update the following section (last 2 lines) in query NewHistoryDownload:
// Yahoo section
YahooBaseUrl = "https://query1.finance.yahoo.com/v7/finance/chart/",
YahooUrlEnd = "?range=[Yahoo_Period]&interval=1d&indicators=quote&includeTimestamps=true", // [Yahoo_Period] isn't valid, replaced later
YahooPeriods = {"1d", "5d", "1mo", "3mo", "6mo", "1y", "2y", "3y", "4y", "5y", "ytd", "max"},
UserPeriods = {"1 day", "5 days", "1 month", "3 months", "6 months", "1 year", "2 years", "3 years", "4 years", "5 years", "YTD", "max"},
//
LoRic04122002
Apr 13, 2023Copper Contributor
- LorenzoApr 14, 2023Silver Contributor
Glad I could help & Thanks for the confirmation (can help others...)