Crypto & Perps Trading Journal (Excel + Google Sheets)

See what your trading really earns after fees and funding.

Most free trade logs ignore the two costs that quietly decide crypto results: trading fees and perpetual funding. This journal puts both into every trade, then shows your win rate, profit factor, R-multiples, drawdown and monthly results on one dashboard, with no subscription and no linking of your exchange account.

WHAT'S NEW IN v1.3

- P&L calendar: a month heatmap of daily net results, with week totals and a month summary.

- Reporting currency, e.g. AUD: converts the Dashboard, Monthly and Calendar using monthly FX rates you enter, with automatic rates in Google Sheets and Excel for Windows (being verified). Rates are for a reporting view, not tax figures.

- Playbook and pre-trade checklist: rules per setup, a "Followed plan?" column, a plan-adherence score and the cost of trades where the plan was broken.

- MAE/MFE: enter the worst and best price reached to see exit efficiency and R left on the table.

- Emotion tags with a results breakdown.

- Exchange and account filter across the Dashboard, Breakdown, Monthly and Calendar.

- Screenshot links on each trade and a missed-trades log.

- Your v1.2 trades paste straight into v1.3 (step-by-step upgrade guide included).

Existing buyers: v1.3 is a free update. Download it again from the original Payhip receipt or library link.

Compatibility: Calculations tested in LibreOffice Calc. Built with formulas only (no macros), using functions that Excel 2019/365 and Google Sheets also support.

WHAT YOU GET

- A ready-to-use journal for Excel (2019/2021/365), Google Sheets and LibreOffice. Formulas only, no macros.

- Fee-aware P&L on every trade: gross, fees, funding, net.

- Funding tracking for perps, matched to the right trade by symbol and time.

- R-multiple stats: enter your planned stop to get 1R, R per trade, expectancy in R and fees measured in R.

- A dashboard of about 34 metrics, plus an equity curve, long-vs-short and spot-vs-perp splits.

- Breakdowns by setup, mistake, grade, symbol, exchange, weekday and entry hour.

- Monthly results, a weekly review page and a position-size calculator that includes fees and gives a liquidation-price estimate.

- An importer that converts exports from Coinbase Advanced, Binance (spot and USD-M futures), Bybit, Kraken, OKX and Hyperliquid into paste-ready rows. It runs in your browser (double-click, no install, works offline) or with Python. Your files never leave your device. Each format's verification status is documented, and two website CSV formats are marked unverified.

- Tax record-keeping for Australia, the US, the UK and Canada, plus a generic mode. Each taxable event is valued in your local currency with the FX rate and its source, using each authority's published matching rules (ATO FIFO parcels and the 12-month discount flag; IRS Form 8949 short/long-term; HMRC same-day, 30-day and Section 104 pooling; CRA adjusted cost base and superficial losses), with a year-end summary per tax year.

- A sample workbook filled with made-up trades, so you can explore before entering your own.

WHAT IT WON'T DO

- Give tax advice or file a return. The tax sheets are records for you and your registered tax agent. Perpetual futures and funding are flagged for professional review because tax authorities haven't settled how they're treated.

- Connect to your exchange or store API keys. You download your own export files.

- Predict anything, or show exact liquidation prices. Liquidation figures are labelled as estimates.

Tax calculations checked against official worked examples from the ATO, IRS, HMRC and CRA.

Personal licence: one user. Instant download.

Refunds: if it isn't right for you, email support@sourcedtrading.com within 14 days of purchase with your order number for a full refund, no questions asked. Refund policy: https://sourcedtrading.com/refund-policy/

Support: support@sourcedtrading.com · https://sourcedtrading.com

Sold by Daniel Collins, trading as Sourced Trader.

Not financial advice. This is a record-keeping and analysis tool, not financial, investment, trading or tax advice. Past results, including the made-up sample data, don't indicate future results. Trading crypto and leveraged derivatives carries a high risk of loss.