Options profit calculator

Options profit spreadsheet

Options profit spreadsheet


A protective put involves going long on a stock, and purchasing a put option for the same stock. A protective put is implemented when you are bullish on a stock, but want to protect yourself from losses in case the stock price decreases.

Option Profit Calculator Excel (Template - Download with

Now we have created simple payoff calculators for call and put options. However, there are still some things we can improve or add to make our spreadsheet more useful.

Excel Spreadsheets – My Trader's Journal

From that point I have formulas for Max % Return, Annualized Return, as well as Actual % Return and Annualized (Actual) % Return. Does that help?

How to Keep Track of Your Day Trading Gains and - dummies

Plug the pertinent information into the yellow boxes and the spreadsheet constantly updates its information as the product moves in real time (see the note above). Dr. Data, with help from Tom and Tony, take you through the use of this program and the benefits. Download the appropriate spreadsheet and enjoy.

For several years I, and many others used an Excel spreadsheet developed by Mr. John Pajak who was and always will be a Master of all thing Excel. As the years went by I lost track with John and, when Yahoo closed down it 8767 s API I was at a loss of where to turn as I typically trade / invest in several hundred options a year.

I also tend to create a detailed trading log for each major trade and track this via a Google doc, whereas the excel trading journal is more of an overall summary. I’ve included an example later in the article.

I am definitely open to creating additional versions. I was going to work on iron condors next. I 8767 ll look into married puts and collars as well. Thanks for your comment. And, I 8767 m glad the put/covered call tracker is working well for you.

Quiet Foundation, Inc. (“Quiet Foundation”) is a wholly-owned subsidiary of tastytrade The information on is intended for . residents only. All investing involves the risk of loss. Past performance is not a guarantee of future results. Quiet Foundation does not make suitability determinations, nor does it make investment recommendations. You alone are responsible for making your investment and trading decisions and for evaluating the merits and risks associated with the use of Quiet Foundation’s systems, services or products.

8. Tracking Open Positions – With the journal I’ll share with you below, you can filter your spreadsheet for open positions and even by expiry. I was tempted to add in a column that would show some of the key greeks but decided to leave it out. You could always add these in yourself if you wanted the extra scrutiny of your open trades.

7. Trading History – It’s amazing what information can be gleaned from a few years’ worth of trading records. Patterns start to emerge. You will be able to look back over your performance history and analyze which trading strategies have performed the best.


Leave a comment