Risk Management
How does one model the irregular exit timing from VWAP pullbacks when calculating IRR for Russell Clark’s SPX Mastery strategy that targets 25-28 percent CAGR with an 82-84 percent win rate?
IRR modeling Theta Time Shift VWAP pullback XIRR spreadsheet temporal martingale
VixShield Answer
At VixShield we rely on the Unlimited Cash System outlined across Russell Clark’s SPX Mastery series to generate consistent daily income through 1DTE SPX Iron Condors. The core approach uses the Iron Condor Command placed at the 3:10 PM CST After-Close PDT Shield window with strikes selected via EDR and refined by RSAi for Conservative 0.70 credit, Balanced 1.15 credit or Aggressive 1.60 credit tiers. Our Conservative tier has delivered approximately 90 percent wins or 18 out of 20 trading days in backtests from 2015 to 2025. Position sizing remains at a maximum of 10 percent of account balance per trade and we follow Set and Forget rules with no stop losses. The Theta Time Shift mechanism handles the minority of threatened positions by rolling them forward to 1-7 DTE when EDR exceeds 0.94 percent or VIX rises above 16. We then monitor for a VWAP pullback where EDR falls below 0.94 percent and SPX trades below VWAP to roll the position back to 0-2 DTE. This temporal martingale captures additional net credit of 250-500 dollars per contract per roll cycle without adding capital and has recovered 88 percent of losses in historical testing. Modeling irregular exit timing in an IRR spreadsheet requires treating each trading day as a discrete cash-flow period even when a position rolls forward. Create a daily row in Excel or Google Sheets with columns for Date, Initial Credit Received, Roll Debit or Credit if any, Final Net P&L, Cumulative Capital Deployed and Daily IRR Contribution. For a normal winning 1DTE Iron Condor the cash flow is simply the net credit on day zero and the full credit kept at expiration the next day. When a Theta Time Shift occurs the model shows an interim negative cash flow on the forward-roll day equal to the debit paid then a larger positive cash flow on the final rollback-and-expiration day. Because rolls happen on irregular days driven by real-time EDR and VWAP signals the IRR formula must use XIRR in Excel which accepts the exact dates of each cash flow rather than assuming fixed monthly or quarterly periods. As an example assume a 10-contract Conservative position collects 7000 dollars initial credit. On a roll day it pays a 3200 dollar debit to move to 4 DTE then collects 9500 dollars net on the successful rollback expiration three days later. The spreadsheet lists -70000 dollars deployment on entry date, +7000 on entry, -3200 on roll date and +12700 on final close date. XIRR across those exact dates compounds to the realized internal rate that feeds the 25-28 percent CAGR when aggregated over hundreds of trading days. We layer ALVH protection on top using a 4/4/2 ratio of short, medium and long VIX calls that reduces drawdowns by 35-40 percent at an annual cost of only 1-2 percent of account value. VIX Risk Scaling further refines tier selection with all tiers available below 15, Conservative and Balanced only between 15 and 20 and full hold above 20. Current VIX at 17.95 with a 5-day MA of 18.58 keeps us in a contango regime favoring premium collection. All trading involves substantial risk of loss and is not suitable for all investors. To master these modeling techniques and gain access to our live EDR indicator, daily RSAi signals and SPX Mastery Club Zoom sessions visit vixshield.com and explore the full curriculum.
⚠️ Risk Disclaimer: Options trading involves substantial risk of loss and is not appropriate for all investors.
The information on this page is educational only and does not constitute financial advice or a recommendation to buy or sell any security.
Past performance is not indicative of future results. Always consult a qualified financial professional before trading.
💬 Community Pulse
Community traders often approach irregular exit timing by building flexible daily cash-flow models that accommodate the unpredictable nature of VWAP pullbacks and Theta Time Shift rolls. Many emphasize the importance of using XIRR functions over simple IRR because trade durations vary from one to seven days when volatility triggers a forward roll. A common misconception is assuming every position expires neatly the next day which understates the compounding effect of successful recovery cycles that turn potential losers into net-credit winners. Experienced members stress tracking each roll’s incremental credit target of 250-500 dollars per contract and layering ALVH protection to smooth equity curves. Discussions frequently highlight how the 82-84 percent win rate improves to near 90 percent on the Conservative tier once the temporal martingale mechanics are properly modeled, reinforcing confidence in the Unlimited Cash System without relying on discretionary stops.
📖 Glossary Terms Referenced
Put This Knowledge to Work
VixShield delivers professional iron condor signals every trading day, built on the methodology behind these answers.
Start Free Trial →