T20 TRADE TRACKER
T20 TRADE TRACKER.xlsx
Hi all, not quite finished batch 2. But you should get the idea of how it works.
You don't need to touch anything on the front page tab named 'year.' Everything generated in the batch tabs will auto populate into the front 'year' page. The year page is your summary.
In each batch, input manually anything in a grey box.
Monetary risk will auto generate the % risk.
Market is, whatever it is. US30, DAX, NAS etc.
Signal should be, empty 2, filled 2, 3, 4, dot, complex 1, complex 2 etc. MPB, whatever it is.
Pip risk, simple, Pip Growth. Simple, 2x pip risk for 1:2. 3x for 1:3. That generates the RR. Which generates the monetary growth or loss.
It self generates if it is a win or loss, false is BE. no way around that.
Manually enter the DS.
DS1 PROFIT OR LOSS. is worked out. DS0 PL is worked out.
DS1 WINRATE is generated, to test the strategy. Not our interpretation of it. The ones we know are DS1, it will work out the win rate for DS1 trades only for the batch.
Each of those above factors will be totalled up at the bottom of each batch tab.
When you get to the end of your 20, the ending balance will feed into the next batch starting tab. So you can start a fresh batch with your new account balance.
Each batch tab will then feed into the home page. So the 'year' tab is your running log overview, the batch tabs are your detailed entries.
Currently I have win rate and win and break even rate. Some may not want this, but that's what it is for now.
In the year page you will see DS count, this is how many DS1 trades from that batch. You will see DS win rate next to it. That is how many of those DS trades per batch were winners.(and break evens)
We also have DS% for the batch, and total DS over the 100 trades will calculate as data is input.
This all workouts out at the bottom to tell you over your 100 trades, how many DS1s you had and what the win rate is for those DS1s. (Different to the DS score)
The running monetary balance is self calculated, as is the running DS1 profit loss balance; and running DS0 profit loss balance. Obviously we don't want many figures in here, but, it may be useful to know.
It also shows calculated compounded growth from the opening account balance. From trade 1 batch 1 to current trade.
I would play around by entering some false numbers just to see how it works, but it is quite simple. Positive balances should auto colour in green boxes, yellow for break even balances and red for negative. So, if we see a sheet of green on the front page we are doing good
If you get an error in a tab, try making the tab wider, (for those with hugeeee accounts lol.)
Save a working copy, so you can have a blank one when you get on to your second third fourth fifth T20. To start the new one, simply enter the account balance what your previous t20 finished on. It will then continue as normal.
What I don't have yet, because I am way off that. Is year on year t20 records that feed into themselves. But for now this is ok.
ENJOY

You do not have the required permissions to view the files attached to this post.