If you checked out the Forum this morning you saw several recommendations from Lee Schamp as to how one might enhance usage of the Kipling spreadsheet. Based on this information, I sent Lee a Kipling SS with the request to add his enhancements so I would be able to see how the addition of columns might fit in these blog posts. Below is a sample of the Schamp enhancements using the Bohr portfolio as the lab rat. Follow along as I attempt to make use of the changes.
Bohr BHS Momentum Recommendations: Below is the standard Tranche Momentum BHS recommendations. With the Maximum Number of Assets set to five (5) the recommendations are to invest in SCHO, BSV, EMLC, RYU, and PSG, a short ETF. This worksheet is the same as before.
Bohr Position Sizing Recommendations: Now we come to the Position Sizing worksheet. Instead of playing around with the Max Trade Position Risk so as to adjust the Maximum Portfolio Risk (MPR) to the desired percentage, one goes directly to the cell I’ve set to 5.00%. This saves time as I’m primarily interested in setting the risk to a specific percentage. In this high market, I tend to use 5.0% as my portfolio risk value.
Bohr Manual Risk Adjustments: Lee made several changes in this worksheet. By adding the column Recomm Shares from Auto, we no longer need to flip back and forth between that auto and manual position sizing worksheets. Again, I can easily set the Maximum Portfolio Risk to what percentage I choose without messing with the Max Trade Position Risk setting.
I used the Bohr as the test portfolio as it is up for review early next week.
Once more Comments are most welcome here or over on the Forum. Thank you in advance for participating.