Skip to content

    Crypto trading journal for spot and perpetual records

    Quick answer

    Build a crypto trading journal with fields for spot, perpetuals and swaps, multi-exchange records, review questions and Indian tax record-keeping.

    4 July 2026
    11 min read
    2,057 words

    A crypto trading journal records the asset, venue, product, size, entry, exit and decision behind a trade. For perpetual contracts (derivatives without an expiry), add funding (payments between traders) and margin (collateral for the position) shown by the venue. Keep spot (asset purchases) and derivatives separate, and preserve the currency of every fee. Otherwise a simple “profit” column can combine unlike amounts and hide the cost of holding the position.

    Record the product before calculating the result

    Write the complete market name and quote currency. An asset name alone does not say whether you bought the asset, traded a derivative, or used borrowed funds. For derivatives, keep the contract identifier, settlement currency and quantity convention beside the trade. Do not apply a cash-asset formula to a contract until its specification supports it.

    Suggested record structure. Coinbase funding and margin documentation and OneTradeJournal information checked 15 October 2026; these are worksheet suggestions.
    FieldWhat to preserve
    Trade identityVenue, account, pair or contract, and spot or derivative label.
    ExecutionFilled prices, quantities and timestamps with a stated time zone.
    PlanOriginal reason, intended stop, target and planned cash risk.
    Trading costsEach fee amount, currency and whether the result already includes it.
    Perpetual fundingActual payments and receipts, with their timestamps and currency.
    Margin recordMargin mode and venue-reported risk information at the time of the decision.
    BehaviourEmotion, plan deviation, mistake and a short review note.

    If you keep several records, give linked fills and payments a common reference. A funding debit without a contract or timestamp can be hard to connect later. Use the journal-field guide to decide which details belong in the main row and which need supporting notes.

    Funding: record the cash movements, not an assumed schedule

    Coinbase’s global-derivatives help describes continuous funding. Its international-exchange rules describe payments at the end of an interval. The pages give different timing descriptions as checked on 15 October 2026. Use the actual ledger and documentation for your specific product rather than assuming a universal schedule.

    Both sources describe positive funding as a payment from longs to shorts and negative funding as the reverse. In your own record, store “paid” or “received” next to the amount. A rate displayed at entry cannot stand in for the actual funding total across the holding period. These sources explain their products; citing them does not establish availability in India.

    Worked example: fees and funding change the net result

    Assume a fictional linear BTC contract quoted and settled in USDC. This is a made-up contract example, not a real venue specification. Take a long exposure of 0.02 BTC, entry at 60,000 USDC per BTC and exit at 61,000. Assume total trading fees of 3 USDC, funding paid of 2 USDC and funding received of 1 USDC, all separate from gross profit.

    • Gross profit: (61,000 − 60,000) × 0.02 = 20 USDC.
    • Net funding cost: 2 − 1 = 1 USDC.
    • Net result: 20 − 3 − 2 + 1 = 16 USDC.

    The funding receipt increases this example’s result; the payment reduces it. For a simple unborrowed spot purchase, do not copy perpetual-funding fields into the calculation as though they occurred. Record only the cash flows that actually belong to the product. Keep USDC labelled as USDC; a rupee or dollar total needs a separately documented conversion.

    Keep margin and liquidation notes factual

    Coinbase International Exchange’s margin rules describe maintenance margin as a threshold used in liquidation and refer to portfolio-level requirements. That illustrates why a leverage setting alone cannot establish a precise liquidation price for every account. Keep the venue’s reported risk information and margin mode instead of inventing a distance from a leverage shortcut.

    Do not label a margin deposit as a trading loss, or a transfer between your own accounts as profit. In a worksheet, keep account movements beside the trade history and reconcile both. The futures journal guide covers contract records, while the format comparison helps you choose where to keep supporting detail.

    Review by product, asset and decision

    Before comparing coins or setups, confirm that every result includes the same categories of costs. Then read the trades behind a pattern: was size changed, was the original exit plan altered, or was the position held longer than intended? An emotion tag describes what you recorded; it does not prove the emotion caused the outcome.

    OneTradeJournal offers a crypto workspace with manual entries and notes for emotions, mistakes and plan deviations. Its reports use the trades you log. The free allowance is one trade per day per market, free forever, as checked on 15 October 2026. Check the free-plan limits against your activity and retain a complete external record where needed.

    Crypto journal fields checklist

    Use this as a template for a spreadsheet or a journal app. Not every field applies to every product, so mark the ones you do not need as not applicable.

    Suggested template, checked against exchange documentation cited on this page, 28 Oct 2026.
    GroupFields
    IdentityDate and time (with time zone), exchange or wallet, pair, spot / perpetual / swap label
    Size and priceQuantity in coins, average entry, average exit, quote currency
    CostsTrading fee amount and fee currency, network (gas) fee, funding paid or received
    RiskPlanned stop, planned risk in money, leverage and margin mode for derivatives
    ReasonSetup name and why you took it, written before the order
    BehaviourEmotion, mistakes, plan followed or not, a one-line lesson
    ResultGross result, net result, and the rupee value on the day if you report in rupees
    ReferenceExchange order ID or transaction hash

    A crypto journal differs from a stock journal in three ways: the market never closes, fees can be paid in a different coin from the one you trade, and a trade can move between wallets and exchanges. Those three points explain most of the extra fields.

    Journaling trades from several exchanges

    Many traders use more than one exchange and a wallet or two. Keep a single journal and add a column for the venue, rather than one sheet per exchange. Then your totals, win rate and drawdown describe your trading as a whole.

    • Copy the fills by hand from each exchange's order or trade history, using the same columns every time.
    • Give every venue the same naming style, for example Binance spot or Binance futures, so filters work.
    • Log a transfer between your own venues as a transfer, not as a trade. A transfer has a fee but no profit or loss.
    • Reconcile once a week: compare your closing balance on each venue with what the journal expects.

    OneTradeJournal has no import, upload or exchange link. You enter each trade yourself, and that includes trades taken on Binance or any other venue. It exports your data to CSV, JSON or TXT when you need a copy.

    Recording swaps and DeFi trades

    Swapping one coin for another on a decentralised exchange is two things at once: you sell one asset and buy another. Record it that way. The sold asset gets an exit price and a result; the bought asset gets a new entry at the value you paid on that day.

    Illustrative example: you swap 1 ETH, worth $2,000 at the time, for 2,000 USDC and pay a network fee of $5. You record the ETH exit at $2,000, the USDC entry at the same value, and the $5 as a cost. The result for the ETH leg compares $2,000 with whatever you originally paid. These numbers are made up.

    Note the chain, the contract or pool, slippage you accepted and the transaction hash. A failed transaction can still cost a network fee, so log it as a cost with no trade.

    Reviewing by token, time of day and product

    Because the market is open all day and all week, tag each trade with the hour (in one fixed time zone) and the day. After a month you can ask:

    • Do my results differ by token, or only by setup?
    • Are late-night trades worse than daytime ones, and was I tired?
    • Do perpetual trades do worse than spot after funding and fees?
    • Which weekday has my largest losses?

    Treat a pattern as a question to test, not a conclusion, until you have enough trades. Ten trades prove very little. The how to review your trades guide covers the method, and the crypto position size calculator helps with risk per trade. Tired decisions are common in a market that never closes, so log how long you had been screen-watching.

    Records Indian crypto traders need for tax

    This is record-keeping advice, not tax advice. Sources describing the Indian virtual digital asset (VDA) rules say the 30% rate on transfer income allows only the cost of acquisition as a deduction, that a 1% TDS applies to payments for VDA transfers above a threshold, and that losses on one VDA cannot be set against gains on another. Section numbers changed with the Income-tax Act 2025 from 1 April 2026, so check current rules with a chartered accountant.

    Whatever the final rule, a clean record helps. For each disposal keep: the date, the asset, the quantity, the sale value in rupees, the cost of acquisition and its date, fees, and any TDS shown by the exchange. Keep the TDS statements from the exchange, since you will want to match them with your own log. Our crypto tax calculator for India is a starting point for estimates.

    Common crypto journaling mistakes

    • Leaving out fees, especially those paid in another coin.
    • Mixing wallets and exchanges in one balance.
    • Skipping small trades because they feel unimportant. They add up in the fees column.
    • Recording the rupee value only when you remember to.
    • Writing the reason after the trade closes.
    • Copying one exchange's profit figure without checking whether it includes fees and funding.

    Sources

    Related Topics

    crypto trading journalcrypto trading journal freecrypto trade journalcrypto futures journal

    Related Articles

    OneTradeJournal

    The trading journal for Nifty, Bank Nifty and Indian F&O. Track your trades, spot patterns, build discipline.

    • Log one trade a day by hand, on purpose
    • AI mentor finds your repeat mistakes
    • Behavioural analytics catch tilt early
    • Trading calendar with P&L heatmap
    • Pre-trade checklist flags risks
    Start journaling free

    Yearly ₹3,999 · No broker credentials

    Trading journal India