This is normal.
Don't change your formula. Just leave it alone and it will fix itself.
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:
How I am currently using it:
Yes many members are seeing this. See this thread for workaround options though I would personally wait for it to sort itself out.
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?
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.
Can you help? There has to be a way (Google Finance does not carry this fund, don't know why). Thanks