Crypto trading journal for spot and perpetual records
Build a crypto trading journal with fields for spot, perpetuals and swaps, multi-exchange records, review questions and Indian tax record-keeping.
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.
| Field | What to preserve |
|---|---|
| Trade identity | Venue, account, pair or contract, and spot or derivative label. |
| Execution | Filled prices, quantities and timestamps with a stated time zone. |
| Plan | Original reason, intended stop, target and planned cash risk. |
| Trading costs | Each fee amount, currency and whether the result already includes it. |
| Perpetual funding | Actual payments and receipts, with their timestamps and currency. |
| Margin record | Margin mode and venue-reported risk information at the time of the decision. |
| Behaviour | Emotion, 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.
| Group | Fields |
|---|---|
| Identity | Date and time (with time zone), exchange or wallet, pair, spot / perpetual / swap label |
| Size and price | Quantity in coins, average entry, average exit, quote currency |
| Costs | Trading fee amount and fee currency, network (gas) fee, funding paid or received |
| Risk | Planned stop, planned risk in money, leverage and margin mode for derivatives |
| Reason | Setup name and why you took it, written before the order |
| Behaviour | Emotion, mistakes, plan followed or not, a one-line lesson |
| Result | Gross result, net result, and the rupee value on the day if you report in rupees |
| Reference | Exchange 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
- Coinbase: global-derivatives funding specifications. Checked 15 October 2026.
- Coinbase International Exchange: funding, margin and liquidation rules. Checked 15 October 2026.
- OneTradeJournal: manual entry and free plan. Checked 15 October 2026.
Related Topics
Related Articles
Paper Trading App in India: What Each App Offers and What SEBI Says
Paper trading apps in India compared from their own pages: cost, virtual money and price delay. Plus SEBI's 2024 advisory and how to judge your practice trades.
Share Market Kaise Sikhe: A Step by Step Plan for Beginners in India
Share market kaise sikhe: a 12-week beginner plan, free NISM and NSE resources, real costs of a first trade, SEBI loss data and a journal habit. No promises.
TradingView Paper Trading in India: Steps, Limits and Nifty Rules
TradingView paper trading is free, but its help page lists Indian exchange symbols as non-tradable. Setup steps, NSE data delay, limits and a journal method.
Zerodha Console P&L: How to Read Your Report and What It Misses
Read your Zerodha Console P&L step by step: realised and unrealised P&L, charges, heat map, Tax P&L, Verified P&L, why numbers differ and what it can't show.
TradeZella Price in India: Plans in Dollars and Rupees (2026)
TradeZella price: Essential $35, Pro $59, Ultra $99 a month or $315 to $891 a year. Rupee cost, the July 2026 rise, trial facts and checks for Indian traders.
Trade Book Meaning: What Your Tradebook Shows and How to Use It
A trade book lists only your filled trades. See how it differs from the order book and where Zerodha, Groww, Angel One, Dhan and Upstox keep it.
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
Yearly ₹3,999 · No broker credentials