Blog

Crypto & stocks in Google Sheets, explained

Straight answers to the real problems people hit — fixing GOOGLEFINANCE crypto errors, building trackers, cost basis for taxes. No fluff.

Tutorial · 5 min read

Build a DCA calculator in Google Sheets

Track every recurring buy, auto-pull the price per date, and see your average cost and live profit/loss.

Troubleshooting · 6 min read

Why GOOGLEFINANCE returns #N/A for crypto (and how to fix it)

The three reasons your crypto formula breaks — and the one-line fix that pulls reliable prices for 10,000+ coins.

Tutorial · 5 min read

Build a net-worth tracker with stocks and crypto in Google Sheets

One dashboard for your entire portfolio — shares, ETFs, gold and coins, totalled automatically.

Coming soon

Your GOOGLEFINANCE crypto is delayed — how to get real-time prices

Why built-in quotes lag up to 20 minutes, and how to get near-live data instead.

Coming soon

Track your crypto cost basis for taxes in a spreadsheet

Pull the price of any coin on any past date and build a clean cost-basis sheet.

Try it while you read

Free plan, 50 lookups a day. No API key, no card.

Install CryptoTrackPro free