I daytrade the ES and use a spreadsheet to visualize my results.
The red figures in the sheet you have to add and you will get a better sight at where you are and what will happen if you are stopped out in your last position.
A1 is the euro/dollar rate as i live in the euro zone.
A2 is the margin per contract in $
A3 is the maximum position you think you can take as daytrader
A4 is the stoploss in points
A5 is the starting capital in $
A6 is the $-value of 1 point
A7 is the commission and slippage in $
In the table you will see the following:
column 1 calculates automatically how many contracts you can take according to the parameters you gave in A1-A7
column 2 is always the price at which you bought
column 3 is always the price at which you sold
column 4 is the net profit for this trade in $
column 5 is the net profit for this trade in euros
column 6 is the net equity of the account in euros
column 7 is the net equity of the account in euros if your are stopped out in this trade
column 8 is the net profit for this trade in $ if you keep trading with the initial amount of contracts, so without reinvesting the profit in new contracts
column 9 is the net profit for this trade in euros if you keep trading with the initial amount of contracts, so without reinvesting the profit in new contracts
So when i take a trade, i know exactly how many contracts i can take within my riskmanagement system and i know exactly what i will loose if i'm stopped out.
You can also use this sheet to simulate and test how many time and trades it takes to double your account. Just fill in all the parameters and watch the result.
The red figures in the sheet you have to add and you will get a better sight at where you are and what will happen if you are stopped out in your last position.
A1 is the euro/dollar rate as i live in the euro zone.
A2 is the margin per contract in $
A3 is the maximum position you think you can take as daytrader
A4 is the stoploss in points
A5 is the starting capital in $
A6 is the $-value of 1 point
A7 is the commission and slippage in $
In the table you will see the following:
column 1 calculates automatically how many contracts you can take according to the parameters you gave in A1-A7
column 2 is always the price at which you bought
column 3 is always the price at which you sold
column 4 is the net profit for this trade in $
column 5 is the net profit for this trade in euros
column 6 is the net equity of the account in euros
column 7 is the net equity of the account in euros if your are stopped out in this trade
column 8 is the net profit for this trade in $ if you keep trading with the initial amount of contracts, so without reinvesting the profit in new contracts
column 9 is the net profit for this trade in euros if you keep trading with the initial amount of contracts, so without reinvesting the profit in new contracts
So when i take a trade, i know exactly how many contracts i can take within my riskmanagement system and i know exactly what i will loose if i'm stopped out.
You can also use this sheet to simulate and test how many time and trades it takes to double your account. Just fill in all the parameters and watch the result.
