Crypto trading journal: how to track spot, perpetual futures, and funding rates
intent: trade · Published
Trading cryptocurrency requires tracking variables unique to digital asset markets: high exchange taker fees, perpetual contract funding rates, liquidation price thresholds, and extreme volatility. A dedicated crypto trading journal separates your underlying execution performance from exchange financing costs.
Why crypto trading requires specialized recordkeeping
Cryptocurrency derivative markets operate 24 hours a day with structural mechanics distinct from traditional equities or spot currencies. Perpetual swap contracts carry 8-hour funding rate payments transferred between long and short market participants. During sustained directional trends, holding a swing position can accumulate substantial funding debits that erode net profitability, while high volatility tests emotional discipline (learn how to manage tilt in our trading psychology journal guide).
Furthermore, crypto exchanges feature tiered maker-taker fee schedules where aggressive market entries incur steep taker costs. Without recording execution fees, borrow costs, and liquidation thresholds in a structured journal, traders often confuse gross price movement with true net expectancy.
Essential crypto metrics to record for every position
To capture the complete financial picture of digital asset trading, log these four crypto-specific metrics alongside entry and exit prices:
- Maker versus taker fee tier: Record whether your order provided limit liquidity or crossed the spread as a market taker, noting the exact exchange fee percentage deducted.
- Accrued funding rate payments: Track the cumulative cash flow debited or credited across every 8-hour funding cycle during the holding duration.
- Effective leverage and liquidation buffer: The ratio of total position notional value to collateral equity, and the exact dollar distance between your invalidation stop loss and the liquidation engine threshold.
- Collateral asset volatility: Note whether your margin is held in stablecoins (such as USDT or USDC) or coin-margined (such as BTC or ETH), where collateral value fluctuates during adverse moves.
Hypothetical perpetual futures funding and fee reconciliation
Here is a hypothetical scenario of a leveraged long perpetual futures position on BTC/USDT held across three funding cycles over 24 hours:
| Trade parameter | Value | Calculation & fee mechanics |
|---|---|---|
| Contract | BTC/USDT Perpetual | Linear contract with USDT collateral |
| Position size & leverage | 2.0 BTC (10x leverage) | 13,000 USD margin backing 130,000 USD notional entry |
| Entry price (Taker order) | 65,000 USD | Market order entering long momentum breakout |
| Exit price (Maker order) | 67,200 USD | Limit take-profit order executed (+2,200 USD per BTC) |
| Gross realized price gain | +4,400.00 USD | 2.0 BTC multiplied by +2,200 USD price appreciation |
| Entry taker fee (0.05%) | -65.00 USD | 0.05% of 130,000 USD initial notional value |
| Exit maker fee (0.02%) | -26.88 USD | 0.02% of 134,400 USD closing notional value |
| Accrued funding fees (3 cycles) | -78.00 USD | 3 funding payments averaging +0.02% per 8h cycle on longs |
| Total transaction costs | -169.88 USD | Sum of taker entry, maker exit, and funding debits |
| Net realized monetary profit | +4,230.12 USD | Gross profit (+4,400.00 USD) minus total costs (-169.88 USD) |
Without accounting for the 169.88 USD in combined financing and exchange fees in your trading journal metrics, your historical performance metrics would overstate true capital growth.
Copyable crypto trade execution checklist
Copy this checklist into your trade notes before submitting orders on crypto spot or derivative exchanges:
Asset pair and market type (Spot, USDT-M, or Coin-M):
Order execution method (Maker limit vs Taker market):
Collateral currency and allocated margin (USD):
Effective leverage multiple (e.g. 2x, 5x, 10x):
Planned invalidation stop loss price:
Exchange liquidation price and safety margin distance:
Current 8-hour funding rate and settlement countdown:
Estimated net return after round-trip fees and slippage:
Product boundaries, plans and companion guides
Downloading the free CSV trading journal template requires no account or subscription. You can open it in Excel or Google Sheets and enter trades manually at no cost.
In intent: trade, creating, editing, importing and restoring trades requires an active Standard or Grand subscription. Creating an account does not start a free trial. Signed-in users without an active subscription can still read, export and delete existing trades.
Web plans are Standard at 14.99 USD per month and Grand at 29.99 USD per month, before tax. Annual web subscriptions are Standard at 143.90 USD per year or Grand at 287.90 USD per year, saving 20% compared with 12 months at the regular monthly price, before tax and excluding INTT25. Standard includes screenshot imports and up to 15 AI chart analyses per day. Grand includes up to 50 per day, custom pairs and a weekly AI digest when you log at least three trades in the last seven days.
Compare manual spreadsheets and app workflows in our free versus paid trading journal guide, review currency-specific fields in the forex trading journal guide, see our trading journal import guide, or inspect all trading journal features.
For recordkeeping and review. Not investment advice.