Crypto Trading Journal Spreadsheet for Excel & Google Sheets
Spot and perpetual trades with maker/taker fees, funding and leverage tracked
Price: ₹449 (one-time purchase)
Format: ZIP (XLSX + PDF)
Delivery: Instant download after payment is confirmed.
Category: Trading Journals
Description
On crypto exchanges, fees and funding add up quietly across hundreds of trades. This journal works out maker and taker fees for every trade, adds funding, tracks margin and leverage, and shows which pairs and days really pay. A crypto trading journal for Excel and Google Sheets. Log spot and perpetual trades, and see net P&L after maker and taker fees and funding, with results by pair, market and weekday. WHO IT'S FOR Crypto traders on spot and perpetual futures markets who want an honest record of fees, funding and results across pairs. WHAT'S INSIDE • Crypto Trading Journal workbook, blank — Excel XLSX, 8 tabs (249 KB) • Sample workbook with 75 fictional rows — Excel XLSX (270 KB) • Quick Start Guide — PDF, A4, 6 pages (1.2 MB) • README with contents, license and support — TXT HOW IT HELPS • Trade Log with 500 rows for spot and perpetual trades, long or short • Maker and taker fee rates on Settings, chosen per entry and exit order • Funding payments, leverage, margin used and return on margin • Automatic gross P&L, fees, net P&L, risk and R • Dashboard with 20 metrics and breakdowns by pair, market, strategy, direction, all 7 weekdays and emotion • Mistake Cost table, monthly results, equity curve and drawdown • Daily and weekly review sheets HOW TO USE 1. Download and unzip the file. 2. Open Crypto-Trading-Journal-Blank.xlsx in Excel, or upload it to Google Drive and choose File > Save as Google Sheets. 3. Fill in the Settings sheet (account, rules and lists). 4. Add one row per entry in the Trade Log. Type only in the soft-gold cells. 5. Review the Dashboard, Monthly and Charts tabs, and use the review sheets. COMPATIBILITY Microsoft Excel 2019 or newer (including Microsoft 365), Google Sheets and LibreOffice Calc. No macros or add-ins. GOOD TO KNOW This is a manual tool: it does not connect to any broker or data feed. Educational record-keeping tool only, not financial advice; it does not predict or guarantee any result. Sample data is fictional. LICENSE Personal use. You may edit the files for your own records but not resell, share or redistribute them.
What's included
- Crypto Trading Journal workbook, blank — Excel XLSX, 8 tabs (249 KB)
- Sample workbook with 75 fictional rows — Excel XLSX (270 KB)
- Quick Start Guide — PDF, A4, 6 pages (1.2 MB)
- README with contents, license and support — TXT
- Single ZIP download (1.2 MB)
Frequently asked questions
Which exchanges does it work with?
Any. It is a manual journal: set your exchange's maker and taker fee rates on Settings and log trades yourself.
How does leverage affect the numbers?
P&L is price change × quantity. Leverage only changes the margin used and the return on margin.
How do I enter funding?
Enter funding you received as a plus number and funding you paid as a minus number.
Does it calculate liquidation prices?
No. Use your exchange's liquidation price. The journal records results after the trade.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and save it as a Google Sheets file.
Can I share it?
No. The license is for personal use only.
Tags: crypto trading journal, crypto journal spreadsheet, bitcoin trading log, perpetual futures tracker, crypto trade tracker, trading journal excel, trading journal google sheets, crypto fees tracker, funding rate tracker, trading performance, risk management