Portfolio tracking in Google Sheets™
— with the accounting your broker skips

Stocks, options and crypto in one ledger you own. Every sale matched to purchase lots — FIFO or LIFO — across all your brokerage accounts.

  • Your data never leaves your Google account
  • No signup for the 14-day trial, or the free tier after it
  • No credit card to start
  • The developer cannot see your spreadsheet
https://docs.google.com
tradeGIST Dashboard showing charts and asset allocations

Built for a specific kind of investor

tradeGIST does a narrow job very thoroughly.
If it is not your job, a simpler tool will serve you better.

Why keep your portfolio in a file you own

Built for you if

  • You trade actively across more than one brokerage account, and nobody hands you a consolidated view.
  • You hold assets priced in a currency that is not the one you pay taxes in.
  • You trade options — covered calls, spreads or the wheel — or crypto alongside stocks, and are tired of three separate trackers that disagree with each other.
  • Your broker or tax authority leaves the cost basis calculation to you.
  • You are comfortable in a spreadsheet and want to own the file your records live in.

Not for you if

  • You buy an index fund every month and hold it. Your broker's app already tells you everything you need. This tool would be overhead.
  • You want your broker connected by API. tradeGIST has no broker connections — you import your own transaction history. If you won't do that once, stop here.
  • You want software that files your taxes. tradeGIST prepares the numbers; it does not produce or submit tax forms.
  • You hold one asset class, in one account, in one currency. Most of what this add-on does, you would never use — a free template will serve you fine.
  • You don't want to work in a spreadsheet. Everything happens in Google Sheets™; there is no app.

Every View, Generated From One Google Sheets™ Ledger

Replace scattered tabs and manual calculations. Each sheet below is computed from your transaction history, not maintained by hand.

One Master Ledger for Every Transaction.

Stocks, crypto, options, dividends, and cash transactions live in a single ledger — the one source every other view is computed from.

The tradeGIST unified master ledger combining equity, crypto, and options

Your True Exposure, One Row per Ticker.

No more doing manual math to figure out your net position. tradeGIST rolls up every share, option contract, P&L, and tax liability into a single row per ticker.

Aggregated open positions and portfolio exposure summary

Slice and Dice Your Trading History.

No pivot tables to build or maintain. Filter your history by asset class, account, date range, or market sector to see where your P&L actually came from. Each row also carries Days held, its Short- or Long-term classification, what it has at risk and, when you set a stop, its R-multiple. The header rolls those up into one R-multiple for the whole selection.

Advanced trade analysis filtering by asset class, date range, and sector

Every Option Strategy on One Row, Legs, Rolls and All.

Tag the legs of a covered call, a spread or a whole wheel campaign with one Trade ID, and the Options Trades sheet reads them as a single line: capital at risk, max profit, breakevens, ROI and return on premium, with the open legs written out the way a trader reads them, -2 P220 / +2 C300. Rolls, assignments and expiries stay on the row they belong to, so an options tracker in Google Sheets™ finally shows the strategy, not four orphan contracts.

How the Options Trades sheet works
tradeGIST Options Trades sheet in Google Sheets listing one row per option strategy with its Trade ID, underlying, status, strategy name and shape

Visualize Your Dividend Income.

See your total dividends received, your projected forward annual income, and a calendar of upcoming payments — without tracking payout dates by hand.

Automated dividend tracking calendar with forward yield projections

The Cost Basis Accounting That Breaks Spreadsheet Formulas

Templates track prices. tradeGIST does the bookkeeping —
the part that determines what you actually owe and what you actually made.

You sold 40 shares in March. Which 40? Lot-level cost basis, FIFO or LIFO.

If you bought the same stock at three different prices, your taxable gain depends on which purchase each sale is matched against — that matching rule is all FIFO and LIFO mean: sell your oldest shares first, or your newest. tradeGIST does this matching at the individual lot level, across all your brokerage accounts, pooled together or kept strictly separate per account.

You took the loss. Then you bought back too soon. Automatic wash sale detection.

Sell at a loss and repurchase within the window, and that loss may be disallowed as a wash sale — easy to miss across accounts, painful to discover later. tradeGIST flags wash sales automatically as it processes your history. It helps you apply the rules; confirming your tax treatment remains between you and your tax adviser.

How wash sale detection works

Your US stock gained 8 percent. Your P&L says 3 percent. FX impact, separated out.

When you hold assets in a foreign currency, every position is two bets: the asset and the exchange rate. Most trackers silently blend them. tradeGIST reports them separately, so you can see whether a position made money because the asset moved or because your currency did.

How multi-currency tracking works

A spreadsheet formula only knows about today.

Live-price formulas recalculate and overwrite; your portfolio's past evaporates. tradeGIST records a snapshot of your portfolio every day at the close, building a permanent daily history of value, exposure and P&L that no API change or formula refresh can erase.

How daily snapshots work

You planned the trade before you placed it. Did the trade follow the plan? Stops, targets and R-multiples.

Record a stop loss and an exit target on the transaction that opens a position, and the Trades sheet measures every lot against them: how far the price has travelled toward your target, how many times your initial risk you made or lost, fees included, what an open position still gives back to the stop in your base currency, and the reward-to-risk you planned at entry. Partial exits each read their own R. A position sitting past its stop reads 0 open risk, a prompt to check it, not a comfort.

On the Pro tier, the tradeGIST panel moves the stops and targets in force as the trade develops: on one lot, or across part of a position as a ladder or a bracket. They sit on the same FIFO/LIFO lots as your cost basis, and once set they follow your sales, your stock splits and your corrections.

How risk management works

You shouldn't have to trust a stranger with your trading history.

tradeGIST runs as Google Apps Script inside your own Google account. Your transactions, balances and API keys stay in your spreadsheet and never reach tradeGIST's servers — I could not read your data even if you asked me to. Delete the file and everything is gone.

From Broker Export to Working Ledger

Three steps. The import is the real work — how long it takes depends on how much history you bring.

1

Install the Add-on

Install from the Google Workspace Marketplace. Your first run starts 14 days of full Pro — no signup, no email, no credit card. After that, continue on a paid plan, or stay on the free tier, capped at 30 transactions.

Read the setup guide
2

Import Your History

Export your transaction history from your broker and paste it in. Stocks and ETFs price automatically through GOOGLEFINANCE — nothing to configure.

Importing your transactions
3

Optional: Add API Keys

Only if you trade crypto or options. CoinMarketCap has a free tier; Massive.com requires a paid plan. The keys stay in your sheet.

Setting up price sources

What tradeGIST Doesn't Do

Three constraints, stated up front, so you can decide before you install.

It doesn't connect to your broker.

There is no API sync. You export your transaction history from your broker and import it — a real one-time cost when you start, and a few minutes per batch after that. The trade-off is deliberate: no connection also means no credentials shared and no third party sitting between you and your money.

Market data has three cost levels — one of them is paid.

Stocks and ETFs price through Google's native GOOGLEFINANCE: no API key, no cost. Crypto prices come from CoinMarketCap, which offers a free tier. Live options quotes come from Massive.com, which requires a paid plan — billed by Massive, separate from your tradeGIST license. Your keys stay in your spreadsheet, and you can substitute any data source of your own.

It is not tax software, and I am not an accountant.

tradeGIST computes cost basis, gains and wash sales so you have defensible numbers to work from. It does not generate tax forms, and nothing it produces is tax advice. Take the output to your accountant, not to your tax authority directly. The ledger itself is an ordinary Google Sheets™ file in your own Drive; it remains readable and usable regardless of what happens to tradeGIST or its developer.

What the Generated Sheets Look Like

Frequently Asked Questions

Is it safe to track my portfolio in Google Sheets?

tradeGIST runs as Google Apps Script inside your own Google account. Your transactions, API keys, and trade history stay in your spreadsheet and are never transmitted to the developer. No portfolio data is stored in any external database, and there is no account to create. I could not read your data even if you asked me to.

Can I track crypto, stocks, and options together?

Yes. tradeGIST records fractional crypto trades, stock shares, and option contracts in one ledger, then rolls them up into a single dashboard with multi-currency support throughout.

How is this different from a normal spreadsheet template?

The matching logic runs in Google Apps Script, not in cell formulas. That allows lot-level FIFO/LIFO cost basis matching across multiple brokerage accounts, pooled together or kept separate per account. It also flags wash sales as your history is processed and records a daily snapshot of your portfolio. Formulas alone recalculate in place and keep no history.

How are live prices updated?

For stocks and ETFs, the add-on uses native GOOGLEFINANCE formulas. For crypto and options, it connects to CoinMarketCap for crypto and Massive.com for options using your own API keys, which stay in your spreadsheet. You can also feed prices from any data source of your own, through a custom formula or Apps Script.

Can I track multi-leg option strategies like covered calls, spreads or the wheel?

Yes, on the Pro tier. Give every leg of a strategy, and any shares that go with it, the same Trade ID on the Transactions sheet, and the Options Trades sheet shows it as one row: capital at risk, max profit, breakevens, ROI and return on premium, with the open legs spelled out as a trader reads them. Rolls, assignments and expiries stay on that row. An option without a Trade ID still gets a row of its own.

Does tradeGIST track stop losses and R-multiples?

Yes. Enter a stop loss and an exit target on the transaction that opens a position; both are optional. The Trades sheet then shows Target progress, R-multiple (net P&L, fees included, per unit of initial risk), Open risk (what an open position gives back to the stop, in your base currency) and Planned R:R. On the Pro tier you move the stops and targets in force from the tradeGIST panel, on one lot or across part of a position, and they follow your sales and stock splits. tradeGIST does not place orders or send alerts: the stop is your plan, your broker executes it.

More questions? Read the full tradeGIST FAQ or contact support.

Start With Your Last Broker Export

Install the add-on, import your history, and see your cost basis, FX impact and P&L in one Google Sheets™ file you own. Installing starts 14 days of full Pro — no signup, no email, no credit card. After that, continue on a paid plan, or stay on the free tier, capped at 30 transactions. Whatever you imported stays in your sheet.

Get started free