Google docs spreadsheet giving #N/A for all Canadian stocks???

[KaeJS]

This is normal.

Don't change your formula. Just leave it alone and it will fix itself.

[EmJay]

Is anyone having trouble with the =GoogleFinance function for anything listed on a canadian exchange? This function was working fine a few days ago, and hasn't worked since. I did some searching and couldn't find if Google changed the way it works or if they are having some problems on their end.

Here is the function that I am talking about:
http://support.google.com/docs/bin/a...&answer=155178

How I am currently using it:
=GoogleFinance("CDZ";"price")

Thanks!

[CanadianCapitalist]

Yes many members are seeing this. See this thread for workaround options though I would personally wait for it to sort itself out.

[EmJay]

Yes many members are seeing this. See this thread for workaround options though I would personally wait for it to sort itself out.

Will do, thank you. I guess I didn't look hard enough as I didn't see the thread that mine was merged with. Sorry about that.

[cash]

I'm using this to track my holdings. I've got everything set-up properly, except CLF: 1-5 yr Gov Bond Ladder. I tried typing in CLF.TO, TSE.CLF and CLF. Google Finance can't find it, I can only get it to pull up 'Cliffs Natural Resources'. All my other holdings are in there fine. What am I doing wrong?

[CanadianCapitalist]

What am I doing wrong?

I'm not sure. Try one of the other methods described in this merged thread. TSX website is usually very reliable.

[cash]

=index(importhtml("http://finance.yahoo.com/q?s=CLF.TO","table",2),1,2)

Gives me the current market price for CLF, but I still can't get 52 wk high, 52 wk low and the same day % price change.

[CanadianCapitalist]

I still can't get 52 wk high, 52 wk low and the same day % price change.

You need to find a website that provides you with this data. You can compute the % price change from the TSX data posted in this thread. Not sure about 52 week high/low data. TSX also has this data but you may have to dig around a bit to get the numbers you want.

[zepcom]

You need to find a website that provides you with this data. You can compute the % price change from the TSX data posted in this thread. Not sure about 52 week high/low data. TSX also has this data but you may have to dig around a bit to get the numbers you want.

I am trying to recreate what you have done with stocks for mutual funds, so I can get a quote for CIG891. Try though I might, I can't seem to get the Google Docs lookup function to work with this site: http://tmx.quotemedia.com/funds-ca-q..._symbol=cig891

Can you help? There has to be a way (Google Finance does not carry this fund, don't know why). Thanks

[Phab]

Or this:

=index(importhtml("http://tmx.quotemedia.com/quote.php?qm_symbol=xiu","table",4), 5, 2)

for current bid value from TSX website.

This is a wonderful function. Where can I learn the syntax? I'd like to use it for other data, say retrieving the dividend or perhaps other data.
thank you