Jurnal Trading Excel Guide

A well-structured does not just record trades; it identifies why you are losing money.

=COUNTIF(L2:L1000, ">0") / COUNT(L2:L1000) Rata-rata Keuntungan: =AVERAGEIF(L2:L1000, ">0") Rata-rata Kerugian: =AVERAGEIF(L2:L1000, "

Your trading journal is the ultimate accountability partner. It does not care about your excuses or market theories; it only shows you the cold, hard facts of your decisions and their outcomes. Every trade gets an entry, and it gets entered as quickly as possible after each trade.

Jumlah trade profit dibagi total seluruh trade dikali 100. jurnal trading excel

=ABS(SUMIF(Raw_Trades!Net_PnL_Range, ">0")) / ABS(SUMIF(Raw_Trades!Net_PnL_Range, "<0")) (Any number above 1.5 is professional-level) .

Hasil bersih setelah dikurangi komisi atau biaya broker ( fee ).

: Rasio perbandingan risiko dan target profit. A well-structured does not just record trades; it

A: Immediately after closing a trade. Do not wait until the end of the day; you will forget the emotional state that led to the entry.

Agar jurnal Anda lebih mudah dibaca secara visual, gunakan fitur Conditional Formatting : Blok kolom .

Create a secondary sheet or a dedicated column to log rule violations. If you notice that 40% of your losses are categorized under "Chased Price (FOMO)," you immediately know that your primary bottleneck is discipline, not your technical indicator settings. Best Practices for Maintaining Your Journal Every trade gets an entry, and it gets

Anda bisa melihat visualisasi strategi mana (misalnya: Breakout vs Retracement ) yang menghasilkan profit paling tebal.

Seberapa besar risiko modal yang Anda gunakan.

Anda tidak perlu menghitung manual setiap kali menutup posisi. Gunakan rumus-rumus Excel berikut untuk mengotomatiskan jurnal trading Anda. 1. Menghitung Profit/Loss Otomatis (Aset Saham/Kripto)

Untuk posisi : = (Harga Exit - Harga Entry) * Ukuran Posisi - Fee