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

vsoler 

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

Glad I could help Eric9919 & Thanks for providing feedback

Lorenzo awesome, worked wonderfully and thanks for doing all the heavy lifting for me. Thanks.