Main sheet
Last updated
Last updated
ID: (autofill) Number and the ID of each trade.
Enter: the Entry date for your trade.
Symbol: the trading pair. chose only from the list (if something is not on the list go back to Trading pairs sheet)
Position: are you long? or short?
Exit: this is the exit date of your trade. which needs to be filled after you exited the trade.
Day: (autofill) the day you entered the day.
Trading session: your Entry has been taken in which trading session? (Asia, London, LoNy(overlap), Newyork, others)
Entry: your entry price
Target: your initial target that you have on your mind for this setup
Stoploss: your initial stoploss that you have on your mind for this setup
Initial Risk to reward: (autofill) the R:R for your trade based on entry/target/stoploss
Risk(%) on capital: How much of your capital are you risking on this trade?
Exit: your exit price which needs to be filled after you exited the trade.
Comission: How much comission have you paid for this trade? (Open and close)
Profit or loss: this column needs to be filled after you closed the trade. Here you need to choose between Profit/Loss/Breakeven from the dropdown menu. the next two column which will have a color after you closed the trade will give you the hint. green is a profit. red is loss. orange is breakeven.
Return on capital (%): (autofill) This number is the return on your capital based on %. For example if you had a trade for 2.5R and you have risked 1% of your capital, the return would be 2.5%. if the risk you've took is something else then the number might be differenet.
Return on capital (R): (autofill) This number is the return on your capital based on R. if your stoploss and risk was -1R and the RR for your setup has been 2.5R when the price hit your target you have gained 2.5R.
Did it hit your target? Questions for after you closed the trade.
Did it hit your stoploss? Questions for after you closed the trade.
Did you trail your stoploss? Questions for after you closed the trade.
Pips/Points: How many pips or points have you gain from this trade.
P/L $ : this is your profit based on Dollar which you needs to write it in this cell. it will be necessary for the equity curve and all the analysis going forward.
Best R you could have get: This is something that you need to fill at the end of the week. when you are reviewing your trades can you see that you could have a better performance?
Name of the each column can/should be changed.
Double click on each of those cells then clear/delete the number and put the name of your setup in there.
Make sure to don't do anything else and don't mess with other stuff.
When you change those names, the names of the setups in another sheets like Setup Statistics will also get changed. so change the name of your setups only here.
For example you can replace
number 1 with macd+sfp
number 2 with Support and resistance
Number 3 with RSI above 50
... Whatever the name of your setup is.
Something Like this
Description or or any comment for Entry and taking this trade: if you have any comment or notes that you want to write in regard to the entry and taking this trade you should put it here.
Comments and thoughts when you're managing the trade: any thoughts that came to your mind when you was managing the trade?
Reason for getting out of this trade: What was your reasons for getting out of this trade?
Description or any comments for getting out of this trade: any note and comment about getting out of this trade?
Did I follow my plan? Did you follow your plans while you was managing the trade and for the exit? it will be useful in the analysis of your problems.
How do you feel today? do you feel good today? do you feel tired? have you sleep well today? you had a fight? you feel stressed? you feel like you're not ready for today's trading session?
Emotions before taking this trade: Do you feel like this will be a good trade? are you scared to take this trade? do you feel stressed? you feel nothing?
Emotions during this trade: you feel like you could have done better? you feel like this wasnt a good trade? you feel like it will reverse to your stoploss?
Emotions after closing this trade: now what do you think After the trade? it was a bad trade? it was just a normal trade? you feel nothing?
You can post the link of your screenshots here.
if you have saved the screenshots locally you need to upload them and then post the links here.
Screenshot Before: screenshot of the trade when you want to open the trade
Screenshot After: screenshot of the trade after it got closed
Screenshot End of the week: screenshot at the end of the week when you're reviewing your trades to compare and see what happened after the trade.
Answer these questions and then reach conclusions.
What did i do well?
What did i do poorly?
WHY i did it poorly? Important question
HOW to improve and get the highest return? Important question
When youre reviewing AT THE WEEKEND what do you think about the trade?
Problems: Collection of different problems that you can choose from.
which one of them you experienced in your trade?
Let's start with the explnation of these words and then we will have an example.
MAE stands for Maximum Adverse Excursion
MFE stands for Maximum Favorable Excursion.
MAE (maximum drawdown of a position during a trade)
For Long trades: the lowest price during the trade
For short trades: the highest price during the trade
MFE (maximum profit of a position during a trade)
For long trades: the highest price during the trade
For short trades: the lowest price during the trade
if there was something in your trade that you do need to revisit later or it was a trade that you want to favorite or mark it, here you can Change the color of the cell and it will be different that others.
