CRYPTO JOURNAL WORKFLOW
How to Build a Crypto Trading Journal in Excel
Create a clean record for spot and perpetual trades, separate trading fees from funding, and review performance by pair, setup and market condition.
START WITH THE MARKET
Why a crypto trading journal needs its own structure
A generic trading log usually records a symbol, entry, exit and result. Crypto trades can add another layer: the same asset may trade on several venues, against different quote currencies and through spot, margin or perpetual products. Costs can include execution fees, borrowing charges, funding payments and transfers.
Preserve both sides
Record the base and quote asset—such as ETH and USDT—in separate fields or with one consistently formatted pair.
Name the execution venue
The same pair can have different liquidity, fee schedules and price histories across exchanges.
Separate spot and derivatives
Do not compare an unleveraged spot purchase with a leveraged perpetual position as if their risk and costs were identical.
Choose one time standard
Crypto trades around the clock. Store a timezone field and consider UTC for consistent session and day analysis.
If you need the universal foundation first, begin with our step-by-step Excel trading journal guide. The workflow below adds the crypto-specific fields. Trading currencies as well? The companion forex trading journal guide covers pips, lots, swap and a risk-based lot-size formula.
KEEP RAW DATA AUDITABLE
Use four focused workbook tabs
Trade Log
One row per closed trade, or one row per lot when scale-ins and partial exits cannot be represented accurately in a single record.
Lists & Rules
Controlled values for venue, pair, product type, setup, direction, market condition and rule adherence.
Dashboard
Pivot tables or formulas that summarize net results, costs and process metrics without changing the source rows.
Weekly Review
A dated record of data issues, recurring execution mistakes and one clearly defined question to test next.
THE CRYPTO TRADE LOG
Essential columns for a crypto trading journal
Create an Excel table so new rows inherit formatting and formulas. Use dropdowns for repeated labels; free-text variations make later filtering unreliable.
| Group | Suggested columns | Review question |
|---|---|---|
| Identity | Trade ID, account, venue, base asset, quote asset | Where and what did you actually trade? |
| Product | Spot, margin or perpetual; contract name; settlement asset | Are unlike instruments being mixed together? |
| Timing | Entry UTC, exit UTC, holding time, weekday, session label | When did this setup occur? |
| Plan | Setup, direction, planned entry, stop, target, invalidation | What decision existed before the outcome? |
| Execution | Actual entry, exit, quantity, partial fills, slippage | Did execution differ from the plan? |
| Exposure | Position notional, collateral, leverage, liquidation reference | How much market exposure and leverage were used? |
| Costs | Entry fee, exit fee, funding net, borrow cost, transfer cost | How much of the gross result was consumed by costs? |
| Outcome | Gross P&L, net P&L, initial risk, R-multiple, MFE, MAE | What happened in consistent units? |
| Process | Rule followed, market condition, screenshot link, notes | Was the process repeatable? |
DO NOT MIX THE ECONOMICS
Spot and perpetual trades need different context
Track the asset that changed hands
- Base and quote quantity
- Average entry and exit
- Execution and withdrawal fees
- Wallet or exchange location after the trade
Ordinary spot buying does not create a short position by itself. If borrowing or margin is involved, identify it as a separate product and record financing costs.
Track exposure, collateral and funding
- Contract and settlement type
- Long or short direction
- Position notional and leverage
- Funding debits or credits
- Mark/liquidation references from the venue
Perpetual contracts do not have a traditional expiry. Funding payments help keep their prices aligned with spot, but timing and calculation rules differ by venue.
CALCULATE, THEN VERIFY
Excel formulas for a simple linear trade log
The examples below assume a linear, quote-currency-settled position where quantity is measured in units of the base asset. Inverse contracts, quanto products, multi-leg trades and venue-specific accounting require different formulas.
=IF([@Side]="Long",([@Exit]-[@Entry])*[@Quantity],([@Entry]-[@Exit])*[@Quantity])=[@[Gross P&L]]-[@TradingFees]+[@FundingNet]-[@OtherCosts]=IFERROR([@[Net P&L]]/[@InitialRisk],"")WORKED EXAMPLE
One linear ETH/USDT long
A trader records 2 ETH at an entry of 2,500 USDT and an exit of 2,600 USDT. Trading fees total 8 USDT, funding net is −3 USDT and there are no other recorded costs.
Compare several rows with official transaction history before copying formulas down the table. Confirm whether your export already includes fees in realized P&L, or the workbook may subtract them twice.
MEASURE DECISIONS, NOT JUST COINS
Build a dashboard that answers review questions
Net result by setup
Compare consistently defined setups after all recorded costs, not only the best-performing token.
Fees and funding share
Divide total recorded costs by gross profit before costs, with a clear rule for zero or negative denominators.
Rule-adherence rate
Measure the percentage of trades that followed every written entry, risk and exit rule.
Result by time block
Group timestamps in one timezone before comparing weekday or session patterns.
Use pair-level results as a prompt for investigation, not proof that a coin will behave the same way next month. For a deeper process review, see how to use a trading journal to identify your edge and our guide to tracking MFE and MAE.
A REPEATABLE ROUTINE
Review your crypto journal every week
Reconcile the raw records
Match entries, exits, quantities, fees and funding with the venue history. Flag missing transfers and duplicate imports.
Separate product types
Review spot, margin and perpetual trades independently before considering an aggregate result.
Segment comparable trades
Filter by setup, pair, direction, timeframe, venue and market condition. Avoid conclusions from a tiny selected sample.
Review process before outcome
Check rule adherence, sizing, leverage and execution quality before celebrating or condemning the P&L.
Write one testable question
Define one change, the sample it will apply to and the metric you will observe without rewriting historical trades.
READY-MADE WORKBOOK
Prefer a crypto journal that is already structured?
Use the DIY fields above or compare them with our editable workbook. The linked product page lists its current files, features and software requirements.
Crypto Trading Journal Template for Google Sheets & Excel
The current product page describes a trade log, strategy and ticker reports, partial exits, a calendar and a position calculator. Review the page for the latest compatibility and inclusions.
- Sample and blank files
- No VBA macros
- Editable spreadsheet format
Current requirements on the product page specify Microsoft 365 for Excel or a Google account for Google Sheets. Desktop or laptop use is recommended; mobile editing may be limited.
Compare all Trading Journal templatesFAQ
Crypto trading journal questions
What should I track in a crypto trading journal?
At minimum, record the venue, pair, product type, direction, entry and exit time, prices, quantity, planned risk, fees, funding, net result, setup and whether the written rules were followed.
Can I create a crypto trading journal in Excel?
Yes. Use an Excel table for the trade log, controlled lists for repeated categories and a separate dashboard for summaries. Verify calculations against venue records before relying on them.
Should spot and perpetual trades be kept together?
They can share one raw table if product type, costs and calculation method are explicit. Analyze them separately first because leverage, funding, settlement and risk differ.
How should funding payments appear in the journal?
Use a signed funding field with a documented convention—for example, positive when received and negative when paid. Record the actual amount from the venue rather than estimating it from a current rate.
Should I connect the workbook to an exchange API?
A manual workbook does not require API access. Do not store API secrets, private keys or seed phrases in a spreadsheet. If you later automate imports, use the minimum permissions needed and follow the venue's security guidance.
Can the journal show which crypto strategy will work next?
No. It can summarize the trades you recorded and help form questions for further testing. Historical patterns do not guarantee future results.
Sources and further reading
- CFTC: Understand the Risks of Virtual Currency Trading
- Coinbase Help: Funding rates for perpetual futures
- Microsoft Support: Create and format an Excel table
- Microsoft Support: Apply data validation to cells
- Microsoft Support: Create a PivotTable
Sources and product details checked September 2026. This article provides general educational information and is not investment, tax or legal advice.
