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
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.
