Forum Discussion

Lorenzo's avatar
Lorenzo
Silver Contributor

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

 

LoRic04122002's avatar
LoRic04122002
Copper Contributor
Apr 12, 2023

Lorenzo 

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

 

Best regards/Ricky

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Apr 14, 2023

    LoRic04122002 

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

  • LoRic04122002's avatar
    LoRic04122002
    Copper Contributor
    Apr 13, 2023

    Lorenzo 

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

     

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Apr 13, 2023

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

     

Resources