Free Crypto Trading Journal

How this crypto worksheet calculates results

Gross P&L is (exit − entry) × quantity for a long, with the sign reversed for a short. Net P&L subtracts entered trading and network fees and adds signed funding cash flow. Positive funding means money received; negative means money paid. Read actual settlement records rather than deriving the sign from long or short alone.

The funding input is a cumulative amount for the trade, not a rate or funding schedule. Contract intervals can vary, as shown in Binance’s funding-rate information. No exchange data is fetched by this worksheet.

A funding cash-flow example

For a fictional long closed from 100 to 110 USDT with quantity 2, gross P&L is 20 USDT. Entering trading fees of 1, network fees of 0.5 and funding cash flow of −2 produces 16.5 USDT net. Changing funding to +2 produces 20.5 USDT net. A leverage note of 5 does not change either result. With a stop at 95, gross R is 2R; it excludes fees and funding.

Use compatible records

1. Add a trade, or load the fictional sample to inspect the output. Clear the sample before entering your own data. Use one row per fully closed trade with a realized close date, positive prices and actual asset quantity.
2. Use the same quote currency throughout. This tool does not convert BTC, USDT, USD or other assets; do not add results from incompatible units.
3. Enter trading and network fees as nonnegative amounts, and funding as signed cash flow. Blank optional amounts are treated as zero, so leaving a known cost blank understates it.
4. Use exchange and strategy labels to group records. They do not connect brokerage accounts or establish that one exchange provides better execution.
5. Export CSV before reloading. There is no autosave, cloud synchronization or file-import control on this page.

Read the statistics with their definitions

• Win rate is winning trades divided by all valid closed rows, including breakeven rows, in every summary. Invalid or incomplete rows do not enter the calculation.
• Gross price return excludes fees and leverage. Gross R compares price movement with the initial stop distance; it is unavailable when the stop is missing or is not on the risk side of entry.
• Profit factor uses summed positive and negative net trade results. With no losses, profit factor is unavailable because the denominator is zero. Average and largest win or loss are unavailable when that group has no records.
• Daily realized P&L drawdown first nets all trades with the same close date, then follows dates in ascending order. It starts from zero cumulative realized P&L and does not measure account equity, open-position drawdown or intraday price paths.
• Leverage is recorded for context only. The worksheet does not model margin, liquidation, inverse contracts, contract multipliers, partial-close matching or tax treatment.

Missing group statistics or numbers outside the supported numeric range display as unavailable. Reconcile outputs with your exchange statement. Descriptive statistics from supplied records do not establish a repeatable trading advantage.

Frequently asked questions