[stinsont]

has anyone been able to get the google finance function to work on Canadian stock tickers with a '.' in the symbol?

IE; RCI.B

 

[stinsont]

I am using the google finance function to pull in the current price. With all canadian stocks without a dot (".") in them it works fine.

IE;
Riocan -- =googlefinance("REI.UN.TO"; "PRICE") results in #N/A
Telus -- =googlefinance("T.TO"; "PRICE") results in current price

Anyone know of a workaround?

 

[stinsont]

Retired at 31 - doesn't work. Guess I'll just have to type it in the old fashioned way.

 

[stinsont]

awesome! Thanks; works perfect.