Setelah mengumpulkan data minimal 30 hingga 50 trade, Anda akan memiliki data yang cukup valid untuk dianalisis. Buatlah satu tab khusus bernama untuk menampilkan metrik berikut:
Unlike subscription-based journaling software, Excel is a one-time setup that keeps your financial data securely on your local hard drive. Core Components of a Jurnal Trading Excel jurnal trading excel
Jujur pada Diri Sendiri: Jika Anda melakukan "revenge trading" atau entry karena FOMO, tuliskan di kolom catatan. Jurnal ini adalah guru terbaik Anda. Setelah mengumpulkan data minimal 30 hingga 50 trade,
| Column | Header Name | Description | Data Type & Example | |--------|-------------|-------------|---------------------| | A | | Trade date | 01/04/2026 | | B | Ticket/ID | Unique trade ID | BTC-001 | | C | Instrument | Asset traded | BTC/USD , EUR/IDR | | D | Direction | Buy or Sell | Long / Short | | E | Entry Price | Opening price | 650,000,000 | | F | Exit Price | Closing price | 655,000,000 | | G | Lot/Volume | Trade size | 0.01 | | H | P/L (IDR) | Profit/Loss in Rupiah | Formula: =(F-E)*G (adjust for direction) | | I | P/L (%) | Percentage return | =(F-E)/E*100 | | J | Risk (IDR) | Initial risk amount | 2,000,000 | | K | R:R Ratio | Risk:Reward | Formula: =ABS(H/J) | | L | Commission | Fee paid | 15,000 | | M | Net P/L | After fees | Formula: =H - L | | N | Strategy | Trading system used | Breakout , Scalping , Swing | | O | Setup | Chart pattern/trigger | Double Bottom , EMA Cross | | P | Pair/Stock | Specific symbol | GOLD , TLKM.JK | | Q | Market | Type of market | Forex , Crypto , Saham | | R | Session | Trading session | Asia , London , New York | | S | Notes | Mental/technical notes | Saya ragu entry, FOMO | | T | Mistake? | Yes/No | Yes / No | | U | Emotion | Feeling during trade | Greed , Fear , Discipline | Jurnal ini adalah guru terbaik Anda
Agar Anda tidak perlu menghitung manual setiap kali transaksi selesai, gunakan rumus berikut pada baris kedua (Baris 2) lalu tarik ke bawah: