Forex Trading Journal Spreadsheet for Excel & Google Sheets
Pips, lots and account-currency P&L for every trade, with session and pair analytics
Price: ₹449 (one-time purchase)
Format: ZIP (XLSX + PDF)
Delivery: Instant download after payment is confirmed.
Category: Trading Journals
Description
Pips alone do not tell you what you earned, and P&L alone hides how far price moved. This journal shows both for every trade, converts quote-currency results into your account currency, and breaks results down by pair and trading session. A forex trading journal for Excel and Google Sheets. Log trades in lots, see pips and account-currency P&L after commission and swap, and find your best pairs and sessions. WHO IT'S FOR Forex and gold traders who trade majors, crosses or XAUUSD in lots and want clear pip and money results by pair and session. WHAT'S INSIDE • Forex Trading Journal workbook, blank — Excel XLSX, 8 tabs (263 KB) • Sample workbook with 72 fictional rows — Excel XLSX (280 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: pair, direction, entry, exit, lots, stop, target, commission and swap • Editable instrument table with pip size, units per lot and quote → account conversion rate • Automatic pips, gross and net P&L, risk, stop in pips, pip value and R for each trade • Dashboard with 20 metrics including total pips, plus breakdowns by pair, session, strategy, direction, weekday 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 Forex-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
- Forex Trading Journal workbook, blank — Excel XLSX, 8 tabs (263 KB)
- Sample workbook with 72 fictional rows — Excel XLSX (280 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
My account is not in USD. Does it still work?
Yes. Set the currency label on Settings and enter a quote → account rate for each pair so P&L converts into your account currency.
What is a lot in this journal?
Lots are multiplied by the units per lot on Settings (100,000 for standard forex lots by default). Edit it if your broker uses a different contract size.
Can I add more pairs or CFDs?
Yes. Add the symbol, pip size, units per lot and conversion rate to the Settings table.
Does it connect to MetaTrader or my broker?
No. It is a manual journal. You type or paste your trades.
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: forex trading journal, forex journal spreadsheet, pips tracker, fx trade log, trading journal excel, trading journal google sheets, gold trading journal, currency trading, trading performance, risk management, day trading journal