=(Number of Winning Trades) / (Total Trades)
Purpose: Visual overview of your trading performance.
| Cell/Area | Content | Formula (Example) |
|-----------|---------|-------------------|
| A1 | TOTAL NET PROFIT (IDR) | =SUM(Log[P/L IDR]) |
| A3 | WIN RATE (%) | =COUNTIF(Log[P/L IDR],">0")/COUNTA(Log[P/L IDR]) |
| A5 | PROFIT FACTOR | =ABS(SUMIF(Log[P/L IDR],">0"))/ABS(SUMIF(Log[P/L IDR],"<0")) |
| A7 | LARGEST WIN (IDR) | =MAX(Log[P/L IDR]) |
| A9 | LARGEST LOSS (IDR) | =MIN(Log[P/L IDR]) |
| A11 | AVERAGE R:R | =AVERAGE(Log[R:R]) |
| A13 | TOTAL TRADES | =COUNTA(Log[Date]) |
Charts to include:
This is where the real learning happens.
Gunakan tabel dan grafik:
KPI utama (angka besar):
Gunakan formula Excel: CUMULATIVE SUM, MAX, MIN, AVERAGEIFS, SUMIFS.
Contoh formula singkat:
You might be wondering, "Why not just use a paid app?" While automated apps are convenient, they often lack customization. Here is why a "Jurnal Trading Excel" remains the gold standard: jurnal trading excel
Ini adalah pembeda antara trader amatir dan profesional.
Create a second sheet named Dashboard. This is where you analyze your data. Do not type numbers here manually; use formulas.
Key Metrics to Automate: