MeiHua's trading spreadsheet and what I look for

Beginner Questions
1

I have gotten several requests to get my trading spreadsheet, and how i track trades. Actually I just make this a couple of week ago and it is still evolving. And i am not even close to an excel master but i thought i would share anyway. But i think the most important thing here is to realize that everyone’s spreadsheet is going to be different depending on how they trade and what stats they need. For me its constantly evolving. This is broken up into 3 pages, Trades, performance analysis, and charts. IT also detects if you are trading a JPY pair and changes its calculations to accommodate.

here are some general things it calculates:
total wins losses and total trades taken
largest winner and loser in pips and USD
average winner and loser in pips and USD
average lot size of winners and losers and average over all
Max capital attained - min capital attained and differential
Allows for 2 types of strategies to be used and named ( you gotta edit the formulas for your entry names)
for each strat: win rate, expectancy, scale ins (refered to as compound entries), ratio of how often you use 1 type vs the other.

Some of the formulas have to be edited like the weekly ones, so you need to highlight the current week and it will do the calculations. So click the fx box then go and highlight the current weeks trades and it will calculate them properly.

Charts

  1. shows your account balance with an exponential trend line, a 5period MA, and 1 std deviation band.
  2. trades taken and % of account gained or lost.
  3. Pips vs R:R and Capital gained vs R:R (in the example you can see a divergence between earning a similar amount of pips but not gaining the same amount of capital)

*i basically put in random numbers for the example so if it doesn’t make sense well its not supposed to. Just to show the capabilities of the spreadsheet and not give away any of my personal info.

I hope it the rest is really self explanatory, if you have questions ask here and i will try my best to answer.

Linked here : MeiHuas spreadsheet babypips.zip (21.1 KB)

2

Hey Mei,

I’m glad to see that its not only me who actually uses Excel to record every single trading stat possible. One lesson i found out a few years back was that I recorded each and every demo trade and then when i changed a variable in my trading approach i did not have enough data to see how this would effect my past results. So yes, recording each trade in enough detail is a great I idea, i now have a huge database ready to be manipulated in anyway required in the future.

[I]One other thing, and this could be down to me not reading your database correct.
This is regarding your two losses on AUD/CAD at -$70 and -$141

It says on your database that your risking 1% of $5,000.00 which us equal to $50.00
So how have you managed to lose more than your initial 1% risk[/I]

3

No that’s right. I didn’t recalculate that box when I took the screenshot. I basically randomized everything so that it didn’t have any of my real stats or other personal info in. The sheet works just put your trades in and it will spit it out the correct info. Good eye though .

4

Very nice spreadsheet.
Can you tell me what Stack and Buster is under Trade Type?
That is if anyone is still monitoring this.
Thanks