Sunday, May 21, 2017

Option Calculator: Excel Utility

To calculate the fair value of the premium of Calls and Puts becomes a tedious task if the options calculator is showing only a single strike price at a time.

To make things easier an option calculator which shows the calculated values for different strike prices viz., ITM strikes , ATM strike and OTM strikes for an underlying will greatly help.

This will allow you to device your strategy knowing the values of premium at different strike prices in a single go.

I am posting an Option Premium Calculator which will do this for you. Very easy to use and clear in its display will really be a handy tool for you.

Option Calculator - Download Link


  1. Download link is showing no files

    1. Hi Kishor,

      Thanks for mentioning this problem. I will try to retrieve the file as soon as possible and will upload here again. Really don't understand why the file link was deleted from the 4shared drive.

    2. The Options Calculator has been updated.


Required US Government Disclaimer & CTFC Rule 4.41

Futures trading contains substantial risk and is not suitable for every investor. An investor could potentially lose all or more than the initial investment. Risk capital is money that can be lost without jeopardizing ones financial security or lifestyle. Only consider risk capital that should be used for trading and only those with sufficient risk capital should consider trading. Past performance is not necessarily indicative of future results. CTFC RULE 4.41 – HYPOTHETICAL OR SIMULATED PERFORMANCE RESULTS HAVE CERTAIN LIMITATIONS. UNLIKE AN ACTUAL PERFORMANCE RECORD, SIMULATED RESULTS DO NOT REPRESENT ACTUAL TRADING. ALSO, SINCE THE TRADES HAVE NOT BEEN EXECUTED, THE RESULTS MAY HAVE UNDER-OR-OVER COMPENSATED FOR THE IMPACT, IF ANY, OF CERTAIN MARKET FACTORS SUCH AS LIQUIDITY. SIMULATED TRADING PROGRAMS IN GENERAL ARE ALSO SUBJECT TO THE FACT THAT THEY ARE DESIGNED WITH THE BENEFIT OF HINDSIGHT. NO REPRESENTATION IS BEING MADE THAT ANY ACCOUNT WILL OR IS LIKELY TO ACHIEVE PROFIT OR LOSSES SIMILAR TO THOSE SHOWN. All trades, patterns, charts, systems, etc., discussed in this website or advertisement are for illustrative purposes only and not construed as specific advisory recommendations. All ideas and materials presented herein are for information and educational purposes only. No system or trading methodology has ever been developed that can guarantee profits or prevent losses. The testimonials and examples used herein are exceptional results which do not apply to average people and are not intended to represent or guarantee that anyone will achieve the same or similar results. Trades placed on the reliance of Trend Methods systems are taken at your own risk for your own account. This is not an offer to buy or sell futures interests.