Hey everyone, I’m having trouble with my investment tracking spreadsheet in Google Sheets. For some reason, the CASH.TO price function isn’t working anymore. It’s been giving me an error all week and it’s messing up my whole sheet.
I’ve been using this formula:
=GOOGLEFINANCE("TSE:CASH", "price")
But now it’s not working at all. I’ve tried different versions of it, thinking maybe they changed how TSX listings work, but no luck. Is anyone else dealing with this? Do you know how to fix it?
I sent a report to Google about it. If you’re having the same problem, you might want to let them know too. The more people who report it, the faster they might fix it.
Anyone have any ideas on how to get the CASH.TO price working again? It’s driving me crazy!
I’ve been dealing with the same issue, Alice45. It’s frustrating when these functions stop working out of the blue. After some digging, I found a workaround that’s been reliable for me.
Instead of using GOOGLEFINANCE, try using the IMPORTXML function with Yahoo Finance. Here’s the formula I’m using now:
It’s a bit more complex, but it’s been pulling the CASH.TO price accurately for me. The downside is that it updates less frequently than GOOGLEFINANCE did, but it’s better than no data at all.
Hope this helps you get your spreadsheet back on track. Let me know if you run into any issues implementing it.
I’ve encountered similar issues with GOOGLEFINANCE for TSX listings recently. While the IMPORTXML solution is viable, I’ve found a simpler alternative that’s been working consistently for me.
Try using this formula instead:
=INDEX(GOOGLEFINANCE(“CASH:TSE”, “price”), 2, 2)
This slight modification in the ticker symbol format (CASH:TSE instead of TSE:CASH) seems to bypass the current glitch. It’s been reliably pulling CASH.TO prices for me without any extra complexity.
If this doesn’t work, you might consider using a different data source altogether, like Alpha Vantage or Quandl, which offer Google Sheets add-ons. They’re more stable long-term, though they might require an API key setup.
yo alice45, i feel ur pain! had the same prob w/ CASH.TO. treid something new - =IMPORTHTML(“https://www.google.com/finance/quote/CASH:TSE","table”,1) then use cell references to grab the price. bit clunky but works for now. google finance been buggy lately, huh? lemme kno if u need more help!