Hi Group,

I am doing a query:

myurl = "http://finance.google.com/finance/historical?histperiod=daily&q=" _
& sym & "&startdate=" & StartMo & "+" & StartDay & "%2C+" & StartYr &
"&enddate=" _
& StopMo & "+" & StopDay & "%2C+" & StopYr & "&output=csv"

Set qt = ActiveSheet.QueryTables.Add( _
Connection:="URL;" & myurl, _
Destination:=Range("G3"))
With qt
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
End With

This works, except when I am trying to get one of the Indexes, like the SP
500 or DJI. Anyone know what it is that I need to do to get them?

Thanks,
David

DJI
http://www.google.com/finance/histor...Jun+20%2C+2009
Obtained from
http://www.google.com/finance/histor...=INDEXDJX:.DJI

Mishell

"David" wrote in message
...
Hi Group,

I am doing a query:

myurl = "http://finance.google.com/finance/historical?histperiod=daily&q="
_
& sym & "&startdate=" & StartMo & "+" & StartDay & "%2C+" & StartYr &
"&enddate=" _
& StopMo & "+" & StopDay & "%2C+" & StopYr & "&output=csv"

Set qt = ActiveSheet.QueryTables.Add( _
Connection:="URL;" & myurl, _
Destination:=Range("G3"))
With qt
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
End With

This works, except when I am trying to get one of the Indexes, like the SP
500 or DJI. Anyone know what it is that I need to do to get them?

Thanks,
David