Elite-Plus Calculator
Calculates both individual and total portfolio positions
This calculator assists in setting up covered call writing and put-selling trades as well as showing total portfolio positions. There are 2 covered call writing exit strategy pages included, one for rolling options and the other for closing both legs of the trade. The product user guide is incorporated into the spreadsheet by moving the cursor over a column title to get an explanation and understanding of the significance of the cell data.
This calculator assists in setting up covered call writing and put-selling trades as well as showing total portfolio positions. There are 2 covered call writing exit strategy pages included, one for rolling options and the other for closing both legs of the trade. The product user guide is incorporated into the spreadsheet by moving the cursor over a column title to get an explanation and understanding of the significance of the cell data.
Comes with user-guide incorporated into the spreadsheet
“This calculator was designed to work with Microsoft Excel, Apple Numbers, and any of the Open-Source Office products (such as LibreOffice, OpenOffice, and WPS Office). Google Sheets have some formatting and protection incompatibilities with Excel. If you don’t have Excel, please get back to us and we will send you a link for one of the free Open-Source office products.”
Data input for both calls and puts
- Option Month, Year and Expiration
- Stock Symbol
- ER Date
- Ex-Dividend Date
- Stock Price $
- Option Premium $
- Option Strike Price $
- # Underlying Shares
- Expiration Date
Covered Call Writing Calculations
- Time-Value $
- Intrinsic-Value $
- Upside Potential $
- Breakeven $
- Time-Value Return on Option (ROO) %
- Upside Potential %
- Downside Protection %
- Total Time-Value Premium Collected $
- Upside Premium $
- Total $ Invested
- Exit Strategy Thresholds
- 20% Guideline
- 10% Guideline
- 7% Guideline
- Portfolio Calculations
- Total # Contracts
- Total ROO $
- Total Upside $
- Total Portfolio Potential Return
- Total Invested $
- Return w/o Upside %
- Return with Upside %
Put-Selling Calculations
- Time-Value $
- Premium Per Contract $
- Cash Required Per Contract $
- Breakeven
- Time-Value Return on Option (ROO) %
- ROO Premium $
- Purchase Discount, If Exercised %
- Stock Cost-Per-Share, If Exercised $
- Exit Strategy Thresholds
- 3% Guideline
- 20% Guideline
- 10% Guideline
- Portfolio Calculations
- Total # Contracts
- Total Return $
- Total Invested $
- Portfolio Total Return %
Covered Call Writing Exit Strategy Tabs
- “What Now” Tab
- Rolling Options on Or Near Expiration Friday
- “Unwind Now” Tab
- Time-Value Cost-To-Close Both Legs of Trade
Comes with user-guide incorporated into the spreadsheet