Trading Journal Spreadsheet, Excel and Google Sheets Trade Tracker, Net P&L After Fees, Prop Firm Challenge, Forex Crypto Stocks Trading Log

Your REAL trading results, fees included — and the analytics of a $30/month app, with no subscription.

TrueLedger is a trading journal for Excel and Google Sheets. One row per closed trade (or import your MetaTrader history): the file calculates your net P&L, explains your numbers, measures your discipline and tells you what to fix.

━━━━━━━━━━━━━━━━━━
⭐ WHAT MAKES TRUELEDGER DIFFERENT
━━━━━━━━━━━━━━━━━━
• Everything is calculated AFTER fees and slippage: you see what you really keep.
• It talks to you: an automatic written analysis tells you what works, what costs you and what to fix.
• Pro analytics: your true edge (results had you followed your plan), the cost of each mistake, exit management (MAE / MFE), risk of ruin, Sharpe and Sortino.
• Discipline: your personal rules (max daily loss, max trades, monthly target) and what each breach costs you.
• It answers your questions: built-in assistant with 57 answers (type a keyword).
• No macros, no subscription, no connection to your account: your data stays with you.

━━━━━━━━━━━━━━━━━━
📊 WHAT YOU GET
━━━━━━━━━━━━━━━━━━
• Dashboard: TrueScore out of 100, hidden cost tax, P&L calendar, winning hours, R distribution, setups and emotions
• Analytics: Long / Short, sessions (Asia, London, New York), markets, holding time, A/B/C grade, progress curves
• Simulator: Kelly and half-Kelly, projected capital, likely worst drawdown, losing-streak probabilities
• Position size calculator (crypto, forex, futures)
• Weekly and monthly review, setup Playbook
• Multi-account and multi-currency (instruments quoted in USD, JPY… converted), futures with expiries (point value, fees per contract), deposits and withdrawals
• MetaTrader 4 / 5 import in 2 copy-pastes: commissions, swaps and taxes included, duplicates skipped, up to 1,000 trades per pass
• Prop firm challenge tracking (profit target, max loss, daily loss, minimum days)
• 5 colour themes, key-concepts guide, help on every column

For: crypto, forex, stocks, indices, futures, commodities.

━━━━━━━━━━━━━━━━━━
📦 IN THE DOWNLOAD
━━━━━━━━━━━━━━━━━━
• DEMO file (42 sample trades to explore everything in 2 minutes)
• BLANK file (your journal, 2,000 trades)
• PDF Quick Start Guide (Excel / Google Sheets setup in 5 minutes)
• Free corrective updates on request via Etsy Messages

━━━━━━━━━━━━━━━━━━
💻 COMPATIBILITY
━━━━━━━━━━━━━━━━━━
• Tested on Microsoft 365 (Windows) and Google Sheets (free, with a Google account)
• Built for Excel 2013 and later, Windows and Mac (no functions limited to recent versions)
• Not compatible with Apple Numbers

━━━━━━━━━━━━━━━━━━
⚡ HOW IT WORKS
━━━━━━━━━━━━━━━━━━
1. Download the ZIP after purchase (Account › Purchases and reviews)
2. Open the DEMO file to explore, then the BLANK file
3. Enter your capital and fees in Settings
4. Log your closed trades (or import them): the rest is calculated

━━━━━━━━━━━━━━━━━━
ℹ GOOD TO KNOW
━━━━━━━━━━━━━━━━━━
• Digital product: nothing will be shipped.
• First opening in Excel: up to 1–2 minutes (full workbook calculation), then much faster once saved.
• What it does and doesn't do is detailed in the "Scope" tab and on the last photo.
• This is a digital download: digital downloads generally cannot be returned or cancelled on Etsy. File not delivered, damaged or not as described? Contact us through Etsy Messages so we can review the issue; Etsy's Purchase Protection and your statutory rights remain unaffected.
• Personal license: use by the buyer only, reselling and sharing prohibited.
• Educational tool to analyse YOUR trades: no investment advice, no signals. Trading involves a risk of losing capital.
• Designed by TrueLedger with the help of artificial intelligence tools, then tested on 150+ calculated scenarios (Excel, LibreOffice and Google Sheets).
• Prefer French? A French version is available in the shop.
• Taking a prop firm challenge? See also our Prop Firm Challenge Tracker.
• Go further: the complete bundle brings all 4 TrueLedger tools together (position size, backtesting, journal, prop firm) for €59 instead of €82 for the tools bought separately.