Spreadsheet: 854714d1704480376-how-to-best-extract-data-from-a-range-of-text-cells-excel-forum
Sheet: Journal

# | Date Open | Date Close | Position | Currency Pair | Position Size | Order Type | Direction | Status | Session Entry | Hour Of Entry | Trend | Signal | Entry Price | Stop Loss | Take Profit | Exit Price | Commission | Swap | £ Risk | Risk / Reward | Win / Loss | Net £ Loss / Net £ Profit | Net % Profit / Loss | Withdrawl | Balance | Comments | Reason For loss | Closed Out R/R | £ Closed Out R/R | Day of the Week | RR Equity Saved £ | Case Study
1 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 |  | AUD/USD |  | Limit | Short | Valid | New York | 13:00:00 | Pro | Distribution Type 1 | 0.68758 | 0.68828 | 0.662 | 0.68828 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/xq1nv16ptn1x2p7txh9tgzmfrfcsqwta
2 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 |  | AUD/USD |  | Limit |  |  | New York | 14:00:00 | Pro | Distribution Type 1 | 0.68818 | 0.68862 | 0.662 | 0.68864
3 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 |  | SPX |  | Limit | Short | Invalid | New York | 16:00:00 | Pro | Distribution Type 1 | 3841.9 | 3845.3 | 3793 | 3845.6 |  |  |  |  | Loss |  |  |  |  |  | Trading sells out of distribution that has not done anything yet. |  |  |  |  | https://app.box.com/s/z25mpx5znj87kasbkmspgmupqkejt2qo
4 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 |  | SPX |  | Limit |  |  | New York | 16:00:00 | Pro | Distribution Type 1 | 3843.6 | 3845.3 | 3793 | 3845.6
5 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 |  | SPX |  | Limit | Short | Invalid | New York | 16:00:00 | Pro | Distribution Type 1 | 3852.4 | 3857.2 | 3793 | 3857.3 |  |  |  |  | Loss |  |  |  |  |  | Trading sells out of distribution that has not done anything yet. |  |  |  |  | https://app.box.com/s/z25mpx5znj87kasbkmspgmupqkejt2qo
6 | 2023-01-11 00:00:00 | 2023-01-11 00:00:00 |  | EUR/CAD |  | Limit | Short | Valid | New York | 14:00:00 | Pro | SC Entry | 1.44489 | 1.44582 | 1.423 | 1.44584 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/47u3n7l3n5rfwc9op3poels991q0xlej
7 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 |  | EUR/USD |  | Limit | Short | Invalid | L-Crossover | 10:00:00 | Pro | Distribution Type 1 | 1.0886 | 1.08898 | 1.08 | 1.08879 |  |  |  |  | Loss |  |  |  |  |  | Trading sells out of distribution with no weakness. |  |  |  |  | https://app.box.com/s/lunzx3ni9s0okdtybo3089cq1ai9zkby
8 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 |  | EUR/USD |  | Limit |  |  | L-Crossover | 10:00:00 | Pro | Distribution Type 1 | 1.08881 | 1.08898 | 1.08 | 1.08879
9 | 2023-02-14 00:00:00 | 2023-02-14 00:00:00 |  | SPX |  | Limit | Short | Valid | New York | 15:00:00 | Pro | Re-Distribution | 4147.9 | 4153.4 | 4100 | 4153.4 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/e8j2lhcs8zg8mllq3f593tvf8zq7l601
10 | 2023-02-14 00:00:00 | 2023-06-15 00:00:00 |  | US30 |  | Limit | Short | Valid | New York | 15:00:00 | Pro | Re-Distribution | 34316.6 | 34349.1 | 33980 | 32836.8 |  |  |  |  | Win |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/nf35j5mz9dokkizi87tnjovodc0p7lcs
11 | 2023-02-16 00:00:00 | 2023-02-16 00:00:00 |  | XAU/USD |  | Limit | Short | Valid | New York | 16:00:00 | Pro | Re-Distribution | 1842.55 | 1845 | 1827.5 | 1843.2 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/o29w452lkbgai3jr32d8tdx7frwvjrh9
12 | 2023-03-17 00:00:00 | 2023-03-17 00:00:00 |  | AUD/CAD |  | Limit | Short | Invalid | Asian | 01:00:00 | Pro | Distribution Type 1 | 0.91574 | 0.91621 | 0.9085 | 0.91621 |  |  |  |  | Loss |  |  |  |  |  | Trading sells aggressively with limit orders in a buyer-driven distribution. |  |  |  |  | https://app.box.com/s/tc2qq2g1yedmri03jwju34feynifgoze
13 | 2023-03-17 00:00:00 | 2023-03-17 00:00:00 |  | AUD/CAD |  | Limit |  |  | Asian | 01:00:00 | Pro | Distribution Type 1 | 0.91592 | 0.91646 | 0.9085 | 0.91652
14 | 2023-03-17 00:00:00 | 2023-03-17 00:00:00 |  | AUD/CAD |  | Limit |  |  | Asian | 01:00:00 | Pro | Distribution Type 1 | 0.91639 | 0.91672 | 0.9085 | 0.91678
15 | 2023-03-21 00:00:00 | 2023-03-22 00:00:00 |  | EUR/USD |  | Limit | Short | Valid | New York | 15:00:00 | Pro | Distribution Type 1 | 1.07803 | 1.0786 | 1.07115 | 1.07829 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/iold42xg3i4l0s0y5i6jh92l93h447nv
16 | 2023-03-22 00:00:00 | 2023-03-22 00:00:00 |  | NZD/CAD |  | Limit | Short | Invalid | New York | 14:00:00 | Pro | Distribution Type 1 | 0.85195 | 0.85251 | 0.8445 | 0.85241 |  |  |  |  | Loss |  |  |  |  |  | Trading sells on laggard when the leader is showing no weakness. |  |  |  |  | https://app.box.com/s/xr4ogzwty0fdgf25dqs9m5o8tfhv7stn
17 | 2023-03-23 00:00:00 | 2023-04-11 00:00:00 |  | NZD/CAD |  | Stop | Short | Valid | L-Crossover | 09:00:00 | Pro | Distribution Type 1 | 0.85848 | 0.8594 | 0.8445 | 0.83623 |  |  |  |  | Win |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/rm6qfntkme6xkugk808b08nbulce32n6
18 | 2023-03-23 00:00:00 | 2023-12-19 00:00:00 |  | NZD/CAD |  | Limit |  |  | L-Crossover | 10:00:00 | Pro | Distribution Type 1 | 0.8592 | 0.86002 | 0.8445 | 0.83623
19 | 2023-03-23 00:00:00 | 2023-03-23 00:00:00 |  | NZD/USD |  | Limit | Short | Valid | L-Crossover | 09:00:00 | Pro | Distribution Type 1 | 0.62769 | 0.62868 | 0.6165 | 0.62837 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/t5f91gm3nbj0tp3hczokjpcc5f5to1pn
20 | 2023-03-24 00:00:00 | 2023-03-24 00:00:00 |  | SPX |  | Limit | Short | Invalid | New York | 14:00:00 | Pro | Distribution Type 1 | 3930.1 | 3934.8 | 3884 | 3934.8 |  |  |  |  | Loss |  |  |  |  |  | Trading sells out of distribution that has not done anything yet. |  |  |  |  | https://app.box.com/s/u5xf5iylswoc7sazgb3kwgeux96us6b9
21 | 2023-03-24 00:00:00 | 2023-03-24 00:00:00 |  | SPX |  | Limit |  |  | New York | 14:00:00 | Pro | Distribution Type 1 | 3933.1 | 3934.8 | 3884 | 3934.8
22 | 2023-03-24 00:00:00 | 2023-03-24 00:00:00 |  | US30 |  | Limit | Short | Invalid | New York | 14:00:00 | Pro | Distribution Type 1 | 31941.4 | 31978.2 | 31560.5 | 31981.4 |  |  |  |  | Loss |  |  |  |  |  | Trading sells out of distribution that has not done anything yet. |  |  |  |  | https://app.box.com/s/71ibg6guo7ga8s3vxj3le8nd5e1mux6v
23 | 2023-03-30 00:00:00 | 2023-03-30 00:00:00 |  | AUD/CAD |  | Limit | Short | Valid | London | 09:00:00 | Pro | Distribution Type 1 | 0.909 | 0.90926 | 0.9045 | 0.90924 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/00qzc23cz15w1gooapqr3a5gbeyhbf58
24 | 2023-04-06 00:00:00 | 2023-04-06 00:00:00 |  | EUR/GBP |  | Limit | Short | Invalid | L-Crossover | 10:00:00 | Pro | Re-Distribution | 0.87536 | 0.87564 | 0.8715 | 0.8756 |  |  |  |  | Loss |  |  |  |  |  | Trading sells in active accumulation. |  |  |  |  | https://app.box.com/s/23u8768up2gd3f5anflo7lwotzvl3ix9
25 | 2023-04-13 00:00:00 | 2023-04-13 00:00:00 |  | US30 |  | Limit | Short | Invalid | Close | 17:00:00 | Pro | Distribution Type 1 | 33857.8 | 33890.23 | 33580 | 33890.3 |  |  |  |  | Loss |  |  |  |  |  | Trading sells aggressively using limit orders with no signs of sellers. |  |  |  |  | https://app.box.com/s/m5r3xsotvg2jp7yt69oy780tw0jrwlay
26 | 2023-04-13 00:00:00 | 2023-04-13 00:00:00 |  | US30 |  | Limit | Short |  | Close | 17:00:00 | Pro | Distribution Type 1 | 33882.8 | 33900.7 | 33580 | 33900.8
27 | 2023-06-07 00:00:00 | 2023-06-07 00:00:00
28 | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 |  | US30 |  | Limit | Short | Invalid | New York | 14:00:00 | Pro | Distribution Type 1 | 33986.5 | 34024.1 | 33810 | 34024.1 |  |  |  |  | Loss |  |  |  |  |  | Trading sells out of distribution which accumulates back into demand. |  |  |  |  | https://app.box.com/s/tvxif4e10ho6r4uc8zrdptvuub5uzjzv
29 | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 |  | US30 |  | Limit |  |  | New York | 14:00:00 | Pro | Distribution Type 1 | 34008.25 | 34024.1 | 33810 | 34024.1
30 | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 |  | SPX |  | Limit | Short | Invalid | New York | 15:00:00 | Pro | Distribution Type 1 | 4392.4 | 4397.1 | 4370 | 4395.4 |  |  |  |  | Loss |  |  |  |  |  | Trading sells out of distribution which accumulates back into demand. |  |  |  |  | https://app.box.com/s/mp2d3np9i262412xfko5kx7xrf8qhxgp
31 | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 |  | SPX |  | Limit |  |  | New York | 15:00:00 | Pro | Distribution Type 1 | 4395.03 | 4397.1 | 4370 | 4395.4
32 | 2023-07-04 00:00:00 | 2023-07-04 00:00:00 |  | NZD/USD |  | Stop | Short | Invalid | L-Crossover | 10:00:00 | Pro | Distribution Type 1 | 0.61797 | 0.61828 | 0.608 | 0.61841 |  |  |  |  | Loss |  |  |  |  |  | Misread structure. |  |  |  |  | https://app.box.com/s/oc8y1iimjlnr3ygpt1q7lmiyqmkmrfum
33 | 2023-07-04 00:00:00 | 2023-07-04 00:00:00 |  | NZD/USD |  | Limit |  |  | L-Crossover | 11:00:00 | Pro | Distribution Type 1 | 0.61821 | 0.61841 | 0.608 | 0.61841
34 | 2023-07-05 00:00:00 | 2023-07-05 00:00:00 |  | NZD/CHF |  | Limit | Short | Valid | L-Crossover | 12:00:00 | Pro | Distribution Type 1 | 0.55628 | 0.55692 | 0.5455 | 0.55647 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/j7t65aqlcjm1fspq35e3tvi553mdnxv6
35 | 2023-08-29 00:00:00 | 2023-08-29 00:00:00 |  | AUD/CHF |  | Limit | Short | Invalid | L-Crossover | 10:00:00 | Pro | Distribution Type 1 | 0.56975 | 0.57001 | 0.5605 | 0.57001 |  |  |  |  | Loss |  |  |  |  |  | Trading sells on laggard when the leader is showing no weakness. |  |  |  |  | https://app.box.com/s/zjauw4zgeftroh812yci2uctjeq1cq3q
36 | 2023-08-29 00:00:00 | 2023-08-29 00:00:00 |  | AUD/CHF |  | Limit |  |  | L-Crossover | 10:00:00 | Pro | Distribution Type 1 | 0.56993 | 0.57001 | 0.5605 | 0.57001
37 | 2023-09-20 00:00:00 | 2023-09-20 00:00:00 |  | AUD/USD |  | Limit | Short | Valid | L-Crossover | 13:00:00 | Pro | Distribution Type 1 | 0.64868 | 0.64887 | 0.6448 | 0.64881 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/8yrymvxe8t47r2oyvtu01gtt0o03vol9
38 | 2023-09-20 00:00:00 | 2023-09-20 00:00:00 |  | AUD/USD |  | Limit |  |  | L-Crossover | 13:00:00 | Pro | Distribution Type 1 | 0.64878 | 0.64887 | 0.6448 | 0.64881
39 | 2023-09-20 00:00:00 | 2023-09-20 00:00:00 |  | NZD/USD |  | Limit | Short | Valid | L-Crossover | 13:00:00 | Pro | Distribution Type 1 | 0.59654 | 0.59684 | 0.5932 | 0.59665 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/ebx2md2byncn2eezc0ggbbpbfwxzsgp3
40 | 2023-09-21 00:00:00 | 2023-09-21 00:00:00 |  | US100 |  | Limit | Short | Valid | New York | 15:00:00 | Pro | Re-Distribution | 14825 | 14840.4 | 14750 | 14835.7 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/u4lda6a5y2dnrvozzujkzhf2x9l8w1cv
41 | 2023-09-21 00:00:00 | 2023-09-21 00:00:00 |  | SPX |  | Limit | Short | Valid | New York | 15:00:00 | Pro | Re-Distribution | 4371.05 | 4374.6 | 4356 | 4355.3 |  |  |  |  | Win |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/doavbwbd5c6836dbu0ojsvkmvz2sacs6
42 | 2023-09-25 00:00:00 | 2023-09-25 00:00:00 |  | SPX |  | Limit | Short | Valid | Close | 17:00:00 | Pro | Re-Distribution | 4334.35 | 4339 | 4296 | 4337.2 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | [NAME]
43 | 2023-12-06 00:00:00 | 2023-12-06 00:00:00 |  | US100 |  | Limit | Long | Valid | New York | 14:00:00 | Pro | Re-Accumulation | 15909.04 | 15894.9 | 16020 | 15892.1 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/wg37jet09dkchl2gle8qmg3kocr9l0x7
44 | 2023-12-06 00:00:00 | 2023-12-06 00:00:00 |  | SPX |  | Limit | Long | Valid | New York | 15:00:00 | Pro | Re-Accumulation | 4575.65 | 4573.4 | 4592.5 | 4572.1 |  |  |  |  | Loss |  |  |  |  |  |  |  |  |  |  | https://app.box.com/s/dwaqh3nadrsdxuci4q3njta2b31jt0pk
45 | 2023-12-06 00:00:00 | 2023-12-06 00:00:00 |  | US30 |  | Limit | Long | Invalid | New York | 16:00:00 | Pro | Re-Accumulation | 36154.3 | 36136.5 | 36245 | 36129.4 |  |  |  |  | Loss |  |  |  |  |  | Trading buys aggressively using limit orders with no signs of buyers. |  |  |  |  | https://app.box.com/s/3fzv3ozx40t7eeqkdpdwa5hx4isira1b
46 | 2023-12-08 00:00:00 | 2023-12-08 00:00:00 |  | US30 |  | Limit | Short | Invalid | New York | 14:00:00 | Pro | Re-Distribution | 36126.9 | 36165.1 | 35955 | 36166.4 |  |  |  |  | Loss |  |  |  |  |  | Trading against fundamental bias. |  |  |  |  | https://app.box.com/s/bneezz8ygzkgazw52mma9cbjnap0xdr2
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
 | Totals