Try with a date format of YYYY/MM/DD

Mishell

"David" wrote in message
...
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 a
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