…

Hedger vs Google Sheets

Same goal — an accurate multi-broker portfolio with every number traceable. Sheets does it by hand; Hedger automates the boring parts and keeps the audit trail.

Written with AI assistance

Hedger's founder tracked his portfolio in Google Sheets for years before building Hedger, and still keeps a high-level Sheets view as his personal source of truth. Sheets works well for an overview but gets painful for in-depth daily and weekly tracking across multiple brokers. This page is honest about what Sheets is great at and where it stops scaling.

Where Sheets is great

  • Free, forever. No subscription. If zero cost is a hard requirement, Sheets wins before the conversation starts.
  • Total flexibility. Custom columns, formulas, logic. No app matches a blank spreadsheet on pure expressiveness.
  • Your file, your data. Export to Excel, CSV, archive, print. No lock-in — the file stays readable even if Sheets shut down tomorrow.
  • Transparent by construction. Every formula is visible. You wrote it, you can audit it. No black boxes.
  • GOOGLEFINANCE for prices. Built-in for most listed tickers — delayed and limited, but good enough for a daily glance.

Where Sheets gets painful at scale

The pain points that led the founder to build Hedger after a few years of keeping his own spreadsheet for IBKR, Degiro and Fio:

  • A different CSV shape for every broker — IBKR Flex XML, Degiro's account statement, T212's activity CSV, Fio's PDF-to-CSV, XTB's reports. Each has its own columns, date format, event types.
  • Manual FX for every row. Czech tax uses CNB daily rates, not GOOGLEFINANCE. You end up importing the CNB XML, writing VLOOKUP per trade date, and handling weekend/holiday fallbacks.
  • FIFO across brokers is fragile. Move a position between brokers, do a partial close, get assigned on an option — formulas break in subtle ways and tax numbers drift.
  • Corporate actions rewrite history. Splits, ISIN changes, mergers, delistings — each one means adjusting past rows. Forget one and your 5-year return chart has a cliff.
  • Dividend WHT routing. Gross / WHT / net per payment, per tax year, per broker — a nontrivial spreadsheet.
  • Options barely fit. Premium, assignment, expiry, rolled positions need their own event model. Most Sheets templates skip them.
  • Tax report is a separate chore. Even with numbers right, the Czech §8/§10 summary is hand-built.
  • Performance past a few thousand rows. Open/edit becomes slow, especially with volatile formulas like GOOGLEFINANCE.

What Hedger automates from that list

  • Broker CSV/XLSX import — IBKR (Activity + Flex), Degiro, T212, Fio, XTB normalized into one ledger
  • CNB daily FX rates, loaded automatically per trade date
  • FIFO lot matching with full audit trail; per-broker or cross-broker
  • Corporate actions — splits, ISIN changes applied to historical quantities and cost basis
  • Dividend routing — gross / WHT / net per payment, per tax year
  • Per-position return attribution — Price / FX / Income / Fees / Deposits / Taxes
  • Czech tax report — FIFO, 3-year time test, daily/yearly FX choice, mojedane.cz XML export
  • Drill-down — every number on every screen links back to the CSV row it came from

What Sheets still wins at

  • Custom logic. Want to model a scenario Hedger doesn't support — a hedging overlay, a niche asset class, a what-if rebalance? Sheets lets you build it the same day. Hedger only exposes the calculations its authors have written.
  • File-level portability. A .xlsx in your Drive is a file you back up, email, open in Excel or LibreOffice. Hedger has CSV/XLSX export per table, but the "file" is a view of the database, not the database.
  • Zero ongoing cost. Hedger is free during the open beta — won't last forever. Sheets stays free regardless.
  • You are the engine. In Sheets, you wrote every formula, so you understand every number by construction. Hedger aims for the same clarity via drill-down — verify-by-reading-the-trail instead of verify-by-writing-the-formula.

In short

Stick with Sheets if you enjoy building your own models, have a simple setup (one broker, few trades), or want to avoid any third-party tool between you and your data. Power users with years invested in a good sheet should keep it.

Try Hedger if you're tired of maintaining per-broker parsers, hand-matching FIFO lots, and filling in CNB rates — and you want every figure traceable back to a specific CSV row.

Use both: the founder still keeps a high-level Sheets view (total value, quarterly changes, FX) and uses Hedger for detailed tracking, attribution and tax. Hedger isn't trying to replace the spreadsheet you already trust; it's trying to feed it numbers that match your broker.

Try Hedger

Hedger is in open beta. The fastest way to see if it fits is to load the demo portfolio — no signup needed.