google finance function returning #N/A

[merlin777]

I use the googlefinance function in google sheets to import financial data from into an excel sheet. Since last night london share tickers were returning #N/A.

I've change my tickers from the form "ABC.L" where the L is for london to "LON:ABC" and all has come good. Hope that helps someone else!

 

[FormR]

Hope that helps someone else!

I hadn't checked my workbook today until I saw this, but I had the same problem and your fix worked well for me

 

[merlin777]

I hadn't checked my workbook today until I saw this, but I had the same problem and your fix worked well for me

Since I posted, a few of them have started playing up. I'm not getting #N/A but I am getting 'loading' and 'value' on just a few tickers. I think the 'loading' has appeared because that's what it says on the google sheet and the 'value' is a consequence of that in excel.

Now, I just checked before posing and that problem had gone away. I guess it's just having a bit of a flaky day.