ABCDEFGHIJKLM
1
2
3
“Trading without a diary is like shaving without a mirror.” Dr. Alexander Elder
4
5
6
Here is a quick overview of the features my trading journal supports:https://twitter.com/Cryptogrande
7
8
Sheet 'The List of Trades'Sheet "Trading Journal Overview"
9
Here you can track all your trades but, firstly, you need to fill out, obviously,
columns A to C and E to H.
Also, there is a supporting helper-checker to find out
whether you have withdrawn some profit or not (U column).

Columns V to AI is a 'Risk/reward calculator'.
Just fill in columns V (your SL) and W (your desired take profit),
and you will see whether it is a good trade or not.
Try not to underestimate this part of my journal as it is the game-changing feature
that helps to plan and track trades in the proper way.

Additionally, you can see part 'Notes' (AJ to AM columns) - it is a place where
you can store all your thoughts and ideas about the particular trade - in that way
you have a chance to track strong and weak sides of your mindset and skills
as it is an essential part of the developing of your trading system and improving
your trading stats.

15 September 2020 update:
"Date (close)" and "BTC price (close)" (columns D and I) are updating in
auto-mode for the open trades. When trade is closed you still have to post
the actual date and BTC price manually

18 September 2020 update:
A minor calculation improvement of the "Total days in the trade" (column O)
has been made

29 September 2020 update:
The major update
The column "Order close price" (column G) is updating in auto-mode for the open
trades. Update interval - 15 minutes approximately.
So, you do not need to update the actual price of your coin
for the open trades anymore.

For the trades in BTC just post the valid ticker name in column A (LTC, ETH,
LINK etc.)
For the trades in USD you have to post ticker with underlying currency (BTCUSDT,
BTCBUSD etc.)

*in DEMO version available:
Binance exchange, all ***BTC, ***USDT and ***BUSD pairs 		Here you can find a total stats for the given period, month in my case.
I have divided info into logical blocks.

B3:C7 - it is about the number of trades - total, closed, still open, etc.

B9:C9 - it is a Win-Loss ratio, 'per every loss I have X Trades in profit' X - W/L ratio.

B10:C10 - per cent of trades, closed in profit.

B12:D17 - this block is all about money.

B19:D22 - here you can find an overview of still open trades.

F3:I9 - in this block, the average stats of trades are covered, such as the average
position size, the average profit, and the average duration of the trading. I
t is quite a necessary block to catch the hidden personal behavioural patterns.

K3:O7 - here you can find an average stats of your Risk/reward journal,
give it a closer look for sure.

K19:M20 - this block shows profit to withdraw and already withdrawn profit,
based on your settings from the sheet 'The List of Trades'.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Sheet "Average Price"
28

It is a remarkably useful tool in a situation when you are accumulating or
distributing any position by parts.

Just fill the cells A7:B54 and/or D7:E54 with a quantity and price,
and you will get the average buy/sell price (A2:B4) for the whole position.
29
30
31
32
33
Sheet "Live Trades"
34
21 October 2020:
Here I'll be posting my live trades for free
35
36
37
https://twitter.com/Cryptogrande/status/1318907024458027008
38
39
40
41
42
Soon, I will add some more calculators (including margin trading).
Feel free to DM me on Twitter with the questions, suggestions,
or if you are interested in this trading journal for the private use.
43
44
45
The first 30 trades in ₿ and one trade in $ are locked since it is a demo,
so you can try out to fill in the rest of rows (red font and empty cells below are editable).
46
47
This is a DEMO version, the spreadsheet for the private use might look different - it's up to you.
For example, my trading journal has a list of trades and the journal overview on the same sheet,
but it's harder to understand for a new user
48
49
50
If you need some specific stats in your trading journal - feel free to ask
51
The trading journal is not a guarantee for success but it is a crucial part on the road to success
52
53
bit.ly/crypto_journal
54
55
https://twitter.com/Cryptogrande
56
57
A LIFETIME FULL ACCESS - 0.005 BITCOIN ONLY!
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