Designing and Developing a Simple Trading System – Part 5

                               
In this article, I’ll show you how to complete the rest of the fields of our basic trading and back-test system that I use as an example.  You can expand the columns and start adding in things that you wish to calculate later on.   

Click and select cell S2 then type in Open Position

Click and select cell S12 then type in =IF($N12<>"","L",IF($Q12<>"","S",S11)) click and drag the lower right corner of the cell and fill the rest of the rows.

Click and select cell T2 then type in Entry Price

Click and select cell T12 then type in =IF($N12<>"",N12,IF($Q12<>"",Q12,T11)) click and drag the lower right corner of the cell and fill the rest of the rows.

Now you will have a column showing your open position as well as the entry price of your open position.

To start calculating the profit and loss of each trade as well as the cumulative profit and loss, first click and select cell V2 then type in Profit / Loss

Click and select cell V13 then type in =IF(S12<>S13,IF(S12="L",T13-T12,T12-T13),"") click and drag the lower right corner of the cell and fill the rest of the rows.

Click and select cell W2 then type in Cumulative P/L

Click and select cell W11 then type in 0

Click and select cell W12 then type in =IF(V12<>"",V12+W11,W11) click and drag the lower right corner of the cell and fill the rest of the rows.

The last column is fairly easy; I’ll leave it as an exercise for you. If you can’t finish it, that means your interest and passion is still not enough, maybe trading is not suitable for you yet.

If you manage to finish it, you’ll realize something important which I’ll explain in my next post. Happy trading and good luck.

Oh, I’ve forgot, the screen should look something like this: