Built for currency traders. This free forex trading journal template tracks the unique aspects of FX trading—pips, lots, sessions, and leverage.
Why Forex Traders Need Specialized Tracking
For a head-to-head comparison of this template against competitors, see our scored ranking of trading journal templates.
Forex trading has unique characteristics:
- Pip-based measurement - P&L in pips, not points
- Lot sizing - Micro, mini, standard lots
- Leverage - 50:1, 100:1, 500:1 options
- 24-hour market - Session-based analysis matters
- Spread costs - Varies by broker and pair
This template captures what forex traders actually need.
What’s Included
Currency Pair Trade Log
Complete FX trade tracking:
- Date and time (with timezone)
- Currency pair (dropdown)
- Direction (buy/sell)
- Lot size (0.01 to 10+)
- Entry price (5 decimal)
- Exit price
- Stop loss (pips)
- Take profit (pips)
- Pip gain/loss
- P&L in account currency
- Spread paid
- Session tag
Session Performance Analysis
Track by trading session:
- Asian session (00:00-08:00 GMT)
- London session (08:00-16:00 GMT)
- New York session (13:00-21:00 GMT)
- Session overlaps
- P&L by session
- Win rate by session
- Best session for your strategy
Currency Pair Analysis
See which pairs work for you:
- P&L by pair
- Win rate by pair
- Average pips by pair
- Spread cost by pair
- Best performing pairs
Pip Value Calculator
Built-in calculations:
- Account currency conversion
- Pip value per lot size
- Total pip value for position
- Margin used
Leverage and Risk Monitor
Track your exposure:
- Effective leverage used
- Margin percentage
- Risk per trade (in pips and %)
- Maximum leverage warning
Spread Cost Tracker
Understand your true costs:
- Spread per trade
- Total spread costs
- Spread as % of profit
- Optimal low-spread times
How to Use This Template
Step 1: Download
Click the download button to get the Excel file.
Step 2: Configure Settings
Set your account currency, preferred pairs, and lot sizes.
Step 3: Log Each Trade
Enter trades with all forex-specific details.
Step 4: Analyze by Session
Review which trading sessions are most profitable for you.
Step 5: Optimize Pairs
Focus on pairs where you have an edge.
Forex-Specific Metrics
| Metric | What It Tells You |
|---|---|
| Pips per trade | Average pip gain/loss |
| Win rate by pair | Which pairs suit you |
| Session performance | Best times to trade |
| Spread ratio | Cost efficiency |
| Effective leverage | True risk exposure |
| Risk-reward in pips | Quality of setups |
Trading Session Guide
Asian Session (Tokyo)
- Lower volatility
- Yen pairs most active
- Good for range trading
- Typically 00:00-08:00 GMT
London Session
- Highest volatility
- All major pairs active
- Best for breakouts
- Typically 08:00-16:00 GMT
New York Session
- High volatility
- USD pairs most active
- News-driven moves
- Typically 13:00-21:00 GMT
Session Overlaps
- London/New York (13:00-16:00 GMT) - Highest volume
- Tokyo/London (08:00-09:00 GMT) - Good momentum
Currency Pair Categories
Majors
EUR/USD, GBP/USD, USD/JPY, USD/CHF, AUD/USD, USD/CAD, NZD/USD
Crosses
EUR/GBP, EUR/JPY, GBP/JPY, AUD/JPY, EUR/AUD
Exotics
USD/ZAR, USD/TRY, USD/MXN, EUR/PLN
Pip Value Calculations
Standard Lot (100,000 units)
- EUR/USD: ~$10 per pip
- USD/JPY: ~$9 per pip (varies)
- GBP/USD: ~$10 per pip
Mini Lot (10,000 units)
- Divide standard by 10
- ~$1 per pip for EUR/USD
Micro Lot (1,000 units)
- Divide standard by 100
- ~$0.10 per pip for EUR/USD
Risk Management for Forex
Position Sizing Formula
Lot Size = (Account × Risk%) / (Stop Loss Pips × Pip Value)
Example:
- $10,000 account
- 1% risk = $100
- 50 pip stop loss
- EUR/USD pip value = $10/standard lot
Lot Size = $100 / (50 × $10) = 0.2 lots (2 mini lots)
Leverage Considerations
High leverage amplifies both gains and losses. Track your effective leverage:
Effective Leverage = Position Value / Account Balance
Common Forex Insights from Journaling
Session Patterns
“I’m profitable in London session but lose money in Asian session. Time to focus my trading.”
Pair Selection
“EUR/USD and GBP/USD are my best pairs. Exotic pairs cost me money.”
Spread Impact
“Spreads eat 15% of my gross profit. I need to trade during low-spread hours.”
Timing
“My best trades come in the first hour of London open.”
Limitations of Spreadsheet Forex Journaling
Excel has constraints for forex:
- No real-time data - Can’t pull live prices
- Manual pip calculation - Must calculate yourself
- Timezone complexity - Session tracking is manual
- Multi-pair correlation - Hard to visualize
- No trade import - Every trade logged manually
When to Consider JournalPlus
For serious forex traders:
- Trade import via CSV - Works with any forex broker export
- Session auto-tagging - Trades tagged automatically
- Pair analysis - Deep insights by currency
- Correlation tracking - See related positions
- AI pattern detection - Find your forex edge
One-time payment. Lifetime access. Built for serious traders.
Download and Start Today
Get organized with professional forex tracking. Your edge is hidden in your currency pair and session data—find it.
