[R-SIG-Finance] TSE ticker problems

G See gsee000 at gmail.com
Wed Jul 11 21:03:32 CEST 2012

I don't think google provides that data in a nice format (i.e. CSV)

If you go to http://www.google.com/finance/historical?q=NYSEARCA:SPY
you can see that on the right side of the page there is a section
called "Export" with a link called "Download to spreadsheet"

However, if you go the analogous page for COS, there is no such link.

On Wed, Jul 11, 2012 at 1:57 PM, Paul Gilbert <pgilbert902 at gmail.com> wrote:
> My bad. Indeed the examples should have been:
>> getSymbols("BMO.TO", src="yahoo")
>> getSymbols("COS.TO", src="yahoo")
>> getSymbols("TSE:COS", src="google")
> They lost something in translation from my code. The problem is not resolved
> by this correction, however the yahoo retrieval is fixed by the
> getSymbols.yahoo URL change suggested.
> The google retrieval still causes problems:
>> getSymbols("TSE:COS", src="google")
> Error in download.file(paste(google.URL, "q=", Symbols.name, "&startdate=",
> :
>   cannot open URL
> 'http://finance.google.com/finance/historical?q=TSE:COS&startdate=Jan+01,+2007&enddate=Jul+11,+2012&output=csv'
> In addition: Warning message:
> In download.file(paste(google.URL, "q=", Symbols.name, "&startdate=",  :
>   cannot open: HTTP status was '404 Not Found'
> Any further suggestions appreciated.
> Thanks,
> Paul

More information about the R-SIG-Finance mailing list