ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
📘 How to Use This USD Trading Journal Tab:
3
- Enter your STARTING BALANCE in cell B1.
4
- RECOMMENDED LOT SIZE (cell B2) will adjust automatically based on your balance.
5
- Use the dropdown in the 'Order Type' column to select Buy or Sell.
6
- Enter your actual trade Lot Size manually. 'Expected Profit' will calculate automatically.
7
- Enter 'Actual Profit/Loss' after each trade. Cumulative Balance will update accordingly.
8
- Final Balance will auto-populate at the bottom of the sheet.
9
- Use the 'Notes' column to record your thoughts, reasons, or trade context.
10
11
- 50 points on XAUUSD = $0.50 when using 0.01 lot.
12
- The Lot Size for each day pulls from the recommended value in B2 (editable).
13
- Expected Profit is calculated automatically as: Lot Size × 50.
14
- Cumulative Balance updates daily based on your Actual Profit/Loss.
15
- Your Starting Balance (B1) will also update dynamically based on the most recent Cumulative Balance.
16
- Only enter numbers in the 'Actual Profit/Loss' column (Column F).
17
- Notes column can be used to log why you entered/exited trades, emotions, or events.
18
- Do not modify formulas unless you are customizing your strategy tracking.
19
20
21
22
23
DateCurrency PairOrder Type
Account Balance ($)
Lot Size
Expected Profit ($)
Actual Profit/Loss ($)
Cumulative Balance ($)
Notes
24
2025-07-01XAUUSDBuy
Cumulative Balance ($)
0.010.52.50
TP hit – quick scalp
25
2025-07-01XAUUSDBuy00.010.52.532.5
TP hit – quick scalp
26
27
28
STARTING BALANCE ($):
29
RECOMMENDED LOT SIZE:
0
30
Note: On XAUUSD, 50 points = $0.50 when using 0.01 lot size.
31
32
33
DateCurrency PairOrder Type
Account Balance ($)
Lot Size
Expected Profit ($)
Actual Profit/Loss ($)
#VALUE!Notes
34
2025-07-01 00:00:00XAUUSD#VALUE!00#VALUE!
35
2025-07-02 00:00:00XAUUSD#VALUE!00#VALUE!
36
2025-07-03 00:00:00XAUUSD#VALUE!00#VALUE!
37
2025-07-04 00:00:00XAUUSD#VALUE!00#VALUE!
38
2025-07-07 00:00:00XAUUSD#VALUE!00#VALUE!
39
2025-07-08 00:00:00XAUUSD#VALUE!00#VALUE!
40
2025-07-09 00:00:00XAUUSD#VALUE!00#VALUE!
41
2025-07-10 00:00:00XAUUSD#VALUE!00#VALUE!
42
2025-07-11 00:00:00XAUUSD#VALUE!00#VALUE!
43
2025-07-14 00:00:00XAUUSD#VALUE!00#VALUE!
44
2025-07-15 00:00:00XAUUSD#VALUE!00#VALUE!
45
2025-07-16 00:00:00XAUUSD#VALUE!00#VALUE!
46
2025-07-17 00:00:00XAUUSD#VALUE!00#VALUE!
47
2025-07-18 00:00:00XAUUSD#VALUE!00#VALUE!
48
2025-07-21 00:00:00XAUUSD#VALUE!00#VALUE!
49
2025-07-22 00:00:00XAUUSD#VALUE!00#VALUE!
50
2025-07-23 00:00:00XAUUSD#VALUE!00#VALUE!
51
2025-07-24 00:00:00XAUUSD#VALUE!00#VALUE!
52
2025-07-25 00:00:00XAUUSD#VALUE!00#VALUE!
53
2025-07-28 00:00:00XAUUSD#VALUE!00#VALUE!
54
2025-07-29 00:00:00XAUUSD#VALUE!00#VALUE!
55
2025-07-30 00:00:00XAUUSD#VALUE!00#VALUE!
56
2025-07-31 00:00:00XAUUSD#VALUE!00#VALUE!
57
2025-08-01 00:00:00XAUUSD#VALUE!00#VALUE!
58
2025-08-04 00:00:00XAUUSD#VALUE!00#VALUE!
59
2025-08-05 00:00:00XAUUSD#VALUE!00#VALUE!
60
2025-08-06 00:00:00XAUUSD#VALUE!00#VALUE!
61
2025-08-07 00:00:00XAUUSD#VALUE!00#VALUE!
62
2025-08-08 00:00:00XAUUSD#VALUE!00#VALUE!
63
2025-08-11 00:00:00XAUUSD#VALUE!00#VALUE!
64
2025-08-12 00:00:00XAUUSD#VALUE!00#VALUE!
65
2025-08-13 00:00:00XAUUSD#VALUE!00#VALUE!
66
2025-08-14 00:00:00XAUUSD#VALUE!00#VALUE!
67
2025-08-15 00:00:00XAUUSD#VALUE!00#VALUE!
68
2025-08-18 00:00:00XAUUSD#VALUE!00#VALUE!
69
2025-08-19 00:00:00XAUUSD#VALUE!00#VALUE!
70
2025-08-20 00:00:00XAUUSD#VALUE!00#VALUE!
71
2025-08-21 00:00:00XAUUSD#VALUE!00#VALUE!
72
2025-08-22 00:00:00XAUUSD#VALUE!00#VALUE!
73
2025-08-25 00:00:00XAUUSD#VALUE!00#VALUE!
74
2025-08-26 00:00:00XAUUSD#VALUE!00#VALUE!
75
2025-08-27 00:00:00XAUUSD#VALUE!00#VALUE!
76
2025-08-28 00:00:00XAUUSD#VALUE!00#VALUE!
77
2025-08-29 00:00:00XAUUSD#VALUE!00#VALUE!
78
2025-09-01 00:00:00XAUUSD#VALUE!00#VALUE!
79
2025-09-02 00:00:00XAUUSD#VALUE!00#VALUE!
80
2025-09-03 00:00:00XAUUSD#VALUE!00#VALUE!
81
2025-09-04 00:00:00XAUUSD#VALUE!00#VALUE!
82
2025-09-05 00:00:00XAUUSD#VALUE!00#VALUE!
83
2025-09-08 00:00:00XAUUSD#VALUE!00#VALUE!
84
2025-09-09 00:00:00XAUUSD#VALUE!00#VALUE!
85
2025-09-10 00:00:00XAUUSD#VALUE!00#VALUE!
86
2025-09-11 00:00:00XAUUSD#VALUE!00#VALUE!
87
2025-09-12 00:00:00XAUUSD#VALUE!00#VALUE!
88
2025-09-15 00:00:00XAUUSD#VALUE!00#VALUE!
89
2025-09-16 00:00:00XAUUSD#VALUE!00#VALUE!
90
2025-09-17 00:00:00XAUUSD#VALUE!00#VALUE!
91
2025-09-18 00:00:00XAUUSD#VALUE!0#VALUE!0
92
2025-09-19 00:00:00XAUUSD00#VALUE!0
93
2025-09-22 00:00:00XAUUSD00#VALUE!0
94
2025-09-23 00:00:00XAUUSD00#VALUE!0
95
2025-09-24 00:00:00XAUUSD00#VALUE!0
96
2025-09-25 00:00:00XAUUSD00#VALUE!0
97
2025-09-26 00:00:00XAUUSD00#VALUE!0
98
2025-09-29 00:00:00XAUUSD00#VALUE!0
99
2025-09-30 00:00:00XAUUSD00#VALUE!0
100
Total Expected Profit ($)