[R-SIG-Finance] TSE ticker problems

[G See]

I don't have a good answer, but "dbname" is not an argument for either
getSymbols or getSymbols.yahoo.  It's pretty clear that you meant to
use src="yahoo" and src="google"

Note that the error that you got from
    getSymbols("TSE:COS", dbname="google")
shows that it couldn't find http://chart.yahoo.com/....

That's because it's using the default value of src="yahoo" which means
getSymbols.yahoo is being called.

Anyway, if you go into the source of getSymbols.yahoo, and change

    yahoo.URL <- "http://chart.yahoo.com/table.csv?
To
    yahoo.URL <- "http://ichart.finance.yahoo.com/table.csv?"

Then it will work.  But, I have no idea whether this will work for
other symbols.

> getSymbols("COS.TO", src='yahoo'
[1] "COS.TO"
> head(COS.TO)
           COS.TO.Open COS.TO.High COS.TO.Low COS.TO.Close COS.TO.Volume
2007-01-02       32.61       33.00      32.20        32.39        368500
2007-01-03       31.88       32.00      30.15        30.16       1654000
2007-01-04       29.75       29.75      28.50        28.87       1905400
2007-01-05       29.10       29.56      28.47        28.89       2521000
2007-01-08       29.38       29.49      28.50        28.60       1361300
2007-01-09       28.05       28.15      27.50        27.85       1703500
           COS.TO.Adjusted
2007-01-02           24.12
2007-01-03           22.46
2007-01-04           21.50
2007-01-05           21.52
2007-01-08           21.30
2007-01-09           20.74

HTH,
Garrett

On Wed, Jul 11, 2012 at 12:49 PM, Paul Gilbert <pgilbert902 at gmail.com> wrote:
> I have been having trouble retrieving some TSE series from yahoo:
>
>> require("quantmod")
>> getSymbols("BMO.TO", dbname="yahoo")
>
> works but
>
>> getSymbols("COS.TO", dbname="yahoo")
>
> appears to have worked but has actually failed:
>
>> str(COS.TO)
> An 'xts' object of zero-width
>
> It seems to be getting the header, but no data. I have also tried with
> Google Finance:
>
>> getSymbols("TSE:COS", dbname="google")
>  Error in download.file(paste(yahoo.URL, "s=", Symbols.name, "&a=", from.m,
> :
>   cannot open URL
> 'http://chart.yahoo.com/table.csv?s=TSE:COS&a=0&b=01&c=2007&d=6&e=11&f=2012&g=d&q=q&y=0&z=TSE:COS&x=.csv'
> In addition: Warning message:
> In download.file(paste(yahoo.URL, "s=", Symbols.name, "&a=", from.m,  :
>   cannot open: HTTP status was '404 Not Found'
>
> I'm not sure if I have the syntax correct for indicating an exchange on
> google. Does anyone have suggestions?
>
> Thanks,
> Paul
>
> _______________________________________________
> R-SIG-Finance at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only. If you want to post, subscribe first.
> -- Also note that this is not the r-help list where general R questions
> should go.