This a digital download of an Apple Numbers and Google Sheets Spreadsheet that I created. Check out the video demo here:
To spreadsheet tracks open options positions on individual spreadsheets.
The spreadsheet has 3 sheets:
Summary - shows the current open options and details including the profit loss target ranges
Options spreadsheet for options traded in base account currency
Options spreadsheet for options traded in foreign account currency
*** Enter Values into cells that have a WHITE background colour only***
This chart is ideal for options traders who want to quickly compare the returns of premium selling strategies for a specific price.
By calculating time that the trade will be held the option calculator calculates the predicted including fees and compares the margin amount to expected theoretical return:
Projected Return on Investment in $ and %
Annual Projected Simple ROI %
Annual Projected Compounded ROI %
It also generates a profit loss option price target based on:
50% of maximum Profit (to increase gains)
2x Max Loss (to limit losses)
Finally it summarizes the trade to determine the desired outcome of Hold, Close for Profit or Close for Loss based on the targets.
There are three downloads this purchase. The pdf has links to google drive where the USD and CAD spreadsheets can be copied. The Numbers files are for Apple users only and there is both a USD and CAD version of the same file by default.