Google Workspace Marketplace
Portfolio tracker for Google Sheets™: stocks, crypto and options in one ledger. FIFO/LIFO cost basis, wash sales, option strategies, stops and targets, dividends, daily snapshots and FX impact.
Oleh:
Listingan diperbarui:18 November 2026
Berfungsi dengan:
36
Ringkasan
tradeGIST — Portfolio Tracker for Google Sheets™: Cost Basis, Option Strategies, Stops & Targets

Stocks, crypto and options in one ledger. Most trackers tell you whether you are up or down. This one works out how you got there: which lots you sold, what they cost, and how much of your P&L was the position rather than the currency. It runs inside your own Google Sheets™ file — you import your broker's transaction history, and the add-on generates the reporting sheets.

It also keeps the trade as you planned it. An option strategy reads as one row, whatever its legs and rolls: what it puts at risk, what it can make and where it breaks even. A position carries its stop and its target, and one figure tells you what your portfolio gives back if every stop is hit.

BUILT FOR YOU IF

You trade across more than one brokerage account and nobody gives you a consolidated view
You hold assets priced in a currency you do not pay taxes in
You trade options or crypto alongside stocks and maintain three trackers that disagree
You trade covered calls, spreads, iron condors or the wheel and want each strategy as one trade, not a list of legs
You set a stop and a target on your trades and want your open risk in front of you
Your broker or tax authority leaves the cost basis calculation to you

Not for you if you buy an index fund monthly and hold it, you want your broker connected by API, or you would rather not work in a spreadsheet.

WHAT IT DOES

Lot-level cost basis. FIFO or LIFO matching pairs each sale to specific purchase lots across accounts, pooled or kept separate per account.

Wash sale detection. Flags disallowed losses and adjusts the basis of the replacement lot.

FX impact, separated. Set a base currency and see how much of a gain came from the asset and how much from the exchange rate.

One multi-asset ledger. Stock trades, option assignments and expiries, fractional crypto, dividends and cash in a single transaction history.

Option strategies, one row each. Tag the legs of a strategy with the same Trade ID and the Options Trades sheet builds one row for it: capital at risk, coverage, max profit, breakevens, ROI, return on premium and rolls, with a shape you can read at a glance, like -2 P220 / +2 C300. A covered call is recognized against the shares you already hold. Name each strategy from your own list.

A stop and a target on every trade. Enter a stop loss and an exit target on the transaction that opens a position, and the Trades sheet measures each lot against them: target progress, R-multiple, open risk, planned R:R and days held.

Stops and targets, in force. Move them from the tradeGIST panel as the trade develops, on one lot or over part of a position, as a ladder or as a bracket. Each Generate Trades keeps them in step with your trades: an order ends as filled when your sales cross its level, closes when its position does, and every version is kept. Read the coverage, the open risk, what every stop locks in and what is left unprotected, per lot and per asset. They are your plan, not broker orders: tradeGIST places nothing with your broker and sends no alerts.

Portfolio at risk. One figure on the Dashboard: what your open positions give back if every stop in force is hit now, plus the value no stop covers, as a percentage of your portfolio. The Analysis sheet gives the R-multiple of any group of trades, and what each position has at risk.

Strategy categories. Match specific buys to specific sells to see how a strategy performed, separately from the FIFO/LIFO matching required for tax.

The tradeGIST panel. A side panel that follows the asset of the row you select: P&L, lots, options, accounts and the stops and targets in force in one place.

Dividends, splits and daily snapshots. Projected income and ex-dividend dates, automatic split adjustments, and a permanent record of value and P&L.

Closed trades (every sale matched to the lots it closed), wash sales, options and the Options Trades sheet, per-account tax isolation and managing stops and targets from the tradeGIST panel require Pro or the 14-day trial.

PRIVACY

Your transactions, balances and API keys stay in your spreadsheet. Portfolio data is never transmitted to tradeGIST or stored in any external database. You never create an account or type an email address to use the trial or the free tier. Outbound requests never carry quantities or values. Price, FX rate and dividend lookups send tickers, currency codes and dates to the data providers. The trial check sends a one-way hash of your Google account email (HMAC-SHA256), never the address itself. A paid license check sends your license key, and may send your Google account email to link the license to this account. Feedback is sent only when you submit it (and your email only if you consent to be contacted). The ledger is an ordinary Google Sheets™ file in your Drive, readable whatever happens to tradeGIST.

GETTING STARTED

Install the add-on in a blank spreadsheet and copy the template when prompted, set your base currency and accounting method, then paste in your broker's export. Work in the input sheets: generated reports are rebuilt each run, so manual edits are overwritten.

Stocks and ETFs price through native GOOGLEFINANCE, nothing to configure. Crypto needs a free CoinMarketCap API key. Live quotes for open option positions need a paid Massive.com plan, billed separately — options cost basis, lot matching, wash sales and realised P&L come from your imported history and need no key.

PRICING

Every install starts with 14 days of full Pro — every feature, no transaction cap, from your first run. No signup, no email, no card.

After 14 days you can continue on a Starter or Pro annual license. If you don't, it reverts automatically to the free tier: the same features, capped at 30 transactions, nothing charged and no card on file. Everything you imported stays in your sheet, readable and exportable.

Starter is the portfolio tracker: unlimited transactions, a dashboard, daily snapshots, and every open position broken into its remaining lots — buy 10, sell 3, buy 4, and you see 7 shares and 4 shares, not one blended average. Each open lot shows the stop and target you entered with its open risk, and the Dashboard shows your Portfolio at risk. It does not output closed trades, so no realised gains, wash sale detection, options, Options Trades sheet or tax reporting.

Pro adds the closed-trade accounting: every sale matched to the lots it closed. That matched history is where realised gains, wash sales, options accounting, per-account tax isolation and categories come from. Pro also tracks every option strategy on the Options Trades sheet, and manages your stops and targets in force from the tradeGIST panel: lot and position orders, ladders, brackets and their history.

This 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 file tax forms and nothing it produces is tax advice.

Docs, FAQs and support: https://thetradegist.com/docs
Informasi tambahan
HargaTanpa biaya dengan fitur berbayar
Developer
Non-pedagang
Dukungan
Kebijakan privasi
Persyaratan layanan
tradeGIST akan meminta agar izin ditampilkan di bawah ini. Pelajari lebih lanjut
tradeGIST akan memerlukan akses ke Akun Google Anda
Hal ini akan mengizinkan tradeGIST untuk:
Melihat dan mengelola spreadsheet tempat aplikasi ini dipasang
Menghubungkan ke layanan eksternal
Menampilkan dan menjalankan konten web pihak ketiga pada perintah dan sidebar di dalam aplikasi Google
Mengizinkan aplikasi ini berjalan saat Anda sedang tidak ada
Melihat alamat email Akun Google primer Anda
Melihat info pribadi Anda, termasuk info pribadi Anda yang tersedia untuk publik
Ulasan
Bahasa:
Urutkan menurut:
Google tidak memverifikasi ulasan atau rating. Pelajari ulasan lebih lanjut
Tidak ada komentar
Telusuri
Hapus penelusuran
Tutup penelusuran
Aplikasi Google
Menu utama