Does STOCKHISTORY work for INDICES? Where can I find the symbols?

LoRic04122002 

Glad I could help & Thanks for the confirmation (can help others...)

Lorenzo 

Thank you very much for your effort and prompt reply, its works really well 😉 

LoRic04122002 

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"},
//

Lorenzo 

Can you please provide more choices of "period to download" like 3 years, 5 years

Best regards/Ricky

Andreas2345 

In reply to your Private Message:

I found your solution to the issue that Excel cannot load S&P 5000 Index data using the STOCKHISTORY function. Your solution helped me a lot but I cannot make the data load in as daily, only quarterly. Do you know how I can load in the daily data instead of quarterly?

Same as to vsoler, I'm afraid I don't unsterstand. If you select 3 months (= a quarter) in Period to download you get daily data for that period. Do you expect something else? If so clarify please