D
David
Hi Group,
myurl = "http://finance.google.com/finance/historical?histperiod=daily&q=" _
& sym & "&startdate=" & StartMo & "+" & StartDay & "%2C+" & StartYr &
"&enddate=" _
& StopMo & "+" & StopDay & "%2C+" & StopYr & "&output=csv"
With qt
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
The above query is not bringing in the dates that I expected.
The dates should be between 1/12/2009 and 6/8/2009.
The variables used above are:
StartMo = 1
StartDay = 12
StartYr = 2009
StopMo = 6
StopDay = 8
StopYr = 2009
It brings in 6/18/2009 back to 6/20/2008, about a year.
Not sure how to change url to get this to happen.
Thanks,
David
myurl = "http://finance.google.com/finance/historical?histperiod=daily&q=" _
& sym & "&startdate=" & StartMo & "+" & StartDay & "%2C+" & StartYr &
"&enddate=" _
& StopMo & "+" & StopDay & "%2C+" & StopYr & "&output=csv"
With qt
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
The above query is not bringing in the dates that I expected.
The dates should be between 1/12/2009 and 6/8/2009.
The variables used above are:
StartMo = 1
StartDay = 12
StartYr = 2009
StopMo = 6
StopDay = 8
StopYr = 2009
It brings in 6/18/2009 back to 6/20/2008, about a year.
Not sure how to change url to get this to happen.
Thanks,
David