The Best Option Trading Journal Spreadsheet

Option strategy excel spreadsheet

Option strategy excel spreadsheet


A collar is an options strategy which is protective in nature, which is implemented after a long position in a stock has proved to be profitable. It is implemented by purchasing a put option, writing a call option, and being long on a stock.

Options Trading Strategies | Top 6 Options Strategies you

I’ve update to a new version as my old one was 8-9 years old. Some of you may have the old one, so you might want to download the new, completely free version below

Options Strategy Payoff Calculator Excel Sheet

I also like Option Net Explorer ( 65 GBP Trial for 85 days available ), which also has the added advantage of being able to do vigorous backtesting.

Excel Option Pricer - Option Trading Tips

Some of the strategies like covered call, protective put, bull call spread, etc. are the ways in which you can make money and limit risk. But in any exchange there are many options are available with different prices and different strike rates. If you want to analyse the payoff vs risk for each of them, it becomes cumbersome and tiring to calculate the max profit/max loss for each option/strategy.

Option Strategy Payoff Spreadsheet: Further Improvements

Once you have got the Current Nifty Index Price and the Premium data, you can proceed further to calculate your Input-output data as follows in an Excel Spreadsheet.

Options Trading Excel Calculator – Algoji

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy


How is it that I can see the actual formula behind the cells that you have used to obtain the data? Thank you in advance.

Hi Max,

Mmm, not really. You can change the volatility back and forth but the current implementation doesn t plot greeks vs volatility.

You can check out the online version


It has a simulation table at the end of the page that plots greeks vs both price and volatility.

Most option traders put a lot of time into planning and executing their trades. They come up with a trading plan, paper trade, tweak and practice. This is certainly an important step and one that should be not taken lightly.

Trade Date or Entry Date – Start with just the date, but if you feel you need to add in the time of day you made the trade, you can do that. Personally I just use the date.


Leave a comment