Thread: Macro Question
View Single Post
 
Old 01-07-2017, 01:48 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
The URL link for pulling the info is located in this portion of the Routine Module:

Code:
 qurl = "http://ichart.finance.yahoo.com/table.csv?s=" & Symbol
        qurl = qurl & "&a=" & Month(StartDate) - 1 & "&b=" & Day(StartDate) & _
            "&c=" & Year(StartDate) & "&d=" & Month(EndDate) - 1 & "&e=" & _
            Day(EndDate) & "&f=" & Year(EndDate) & "&g=m" & Sheets("Data").Range("a1") & "&q=q&y=0&z=" & _
            Symbol & "&x=.csv"
                   
        qurlw = "http://ichart.finance.yahoo.com/table.csv?s=" & Symbol
        qurlw = qurlw & "&a=" & Month(FifteenYear) - 1 & "&b=" & Day(FifteenYear) & _
            "&c=" & Year(FifteenYear) & "&d=" & Month(LastYear) - 1 & "&e=" & _
            Day(LastYear) & "&f=" & Year(LastYear) & "&g=w" & Sheets("Data2").Range("a1") & "&q=q&y=0&z=" & _
            Symbol & "&x=.csv"
The beginning of the URL has been highlighted in RED.

If you change this portion of the code, the project will be redirected to the new URL.

Why does YAHOO FINANCE only provide data up to Dec 2015 ? Shouldn't there be data for 2016 as well ?
Reply With Quote