I don’t share the base template of my spreadsheet because there are already many good, more automated ones available, particularly Google Sheets-based (mine is Excel and a little simplified some may find😅)
However, what I strongly recommend is building a spreadsheet tailored to your own trading history and statistics. If you're a low win-rate but high RRR trader like me, the focus should be on improving your losing trades—cutting them quickly and sequentially before hitting the intended stop loss.
I wrote often about a simple 33%/66% stop loss accompanied by 33% sizing out at each level I swear by because it's the only optimal solution I could find through the years to enhance R loss reduction but also not destroy profit potential from cutting sizes out too early.
By reducing your net R loss after costs to below 0.7-0.8, avoiding substantial slippage from exiting too many shares at a single price point in illiquid stocks, and controlling your losing R in this way, one well-executed trade with an ORH setup can easily turn into a 3-5R winner within a single day if you obey to execution at a threshold % below LoD of ATR of each stock implied volatility.
The only trade that met my criteria on Friday was $SPDR S&P Aerospace & Defense ETF(XAR)$ , which easily covered my full losses in $Futu Holdings Limited(FUTU)$ $Global X Lithium & Battery Tech ETF(LIT)$, and a few other stops from the week with a net unrealized profit. It's really about law of large number, and controlling the result from worse case scenario.
Comments