Added “Total Account Invested” to monitor how much of my total account balance is invested.
Added “Total Account In Cash” to monitor how much of my total account balance is in cash.
Added “Risk/Reward Ratio”. This tells me the current ratio based on realized gains.
Added “Win/Loss Ratio”. This tells me the current ratio based on realized gains.
Added “Breakeven Win %”. This tells me the minimum percentage of wins I need to breakeven based on the current risk/reward ratio.
Added “Goal Setting” section.
“Risk/Reward Ratio” is what risk/reward ratio I’m trying to achieve. Also, on the “Open Positions” and “Closed Positions” tab, whenever the R factor reaches that goal, the cell will highlight green to indicate it’s been achieved.
“Breakeven Win %” shows what minimum percentage wins need to be maintained to breakeven if the risk/reward goal is achieved. This is important to know because it takes the stress of having to maintain a very high winning percentage to stay profitable. If I can achieve and maintain a 3:1 risk/reward ratio, I will only need a 25%-win rate to breakeven.
Back Stop is how much to raise my back stop each time 1R is achieved.
Strategies Tab
Changed “Expectancy” to “Expectancy Ratio”. They sound the same but are two different formulas. The expectancy ratio is a relationship between the risk/reward ratio and the win/loss ratio. Those 2 ratios are the focus of this trade book, so the expectancy ratio is a better formula to track. It means that for every loss you can expect to make the loss x expected ratio in gains. Any ratio greater than 0 is one that is profitable, but the more above zero the better.
Add “Risk/Reward Ratio” and “Win/Loss Ratio” to each strategy because of their importance is measuring good strategies and to get the expectancy ratio.
Added the “Breakeven Win %” to see what minimum winning percentage I need to maintain to breakeven on a strategy based on its current risk/reward ratio.
Added a new column for a 4th strategy in case I decide to test another one in the future.