HERE ARE THE FORMULAS IN CASE YOU WANT TO CONSTRUCT YOUR OWN.
column A
row 1: Equities Paper Trading
row 2: Ticker symbol
column B
row 2: Long or short
column C
row 2: Entry price
column D
row 2: Exit price
column E
row 2: N of shares
column F
row 2: Profit or loss
=IF(B3=“L”;D3*E3-C3*E3;C3*E3-D3*E3)
column G
row 2: Net P/L
=F3-25
(this is a $25 round-trip commission, you can double-click to change the amount)
column H
row 2: Profit=1
=IF(F3>0;1;0)
column I
row 2: Losses=1
=IF(F3<0;1;0)
column J
row 2: Total cost
=C3*E3
column K
row 2: % win or loss
=F3/J3*100
column L (here the title is in column L but the formula is in column M so I’ll just add the title to the column M description)
column M
row 2: Total profit or loss
=SUM(F3:F10)
row 3: Including commissions
=SUM(G3:G10)
(in reality, the calculations for % of gain on winners etc is all done with the results excluding the cost of commissions)
row 4: % of winners
=M9/M11*100
row 5: % of losers
=M10/M11*100
row 6: Avg P/L per trade
=M2/M11
row 7: Avg % loss on losers
=M15/M10
row 8: Avg % profit on winners
=M14/M9
row 9: Number of winners
=SUM(H3:H10)
row 10: Number of losers
=SUM(I3:I10)
row 11: Number of trades
=SUM(M9:M10)
row 12: Total profits
=SUMIF(H3:H10;”>0”;F3:F10)
row 13: Total losses
=SUMIF(I3:I10;”>0”;F3:F10)
row 14: Total % gains
=SUMIF(H3:H10;”>0”;K3:K10)
row 15: Total % losses
=SUMIF(I3:I10;”>0”;K3:K10)
row 16: Risk/reward ratio
=M8/M7*-1 |