Next, we come to the Payoff schedule. This basically tells you how much profit you will make or how much you will lose at a specific Nifty index. Note that in case of options, you are not obliged to exercise them, and hence you are able to limit your loss to the amount of Premium paid. The formula used in this case is the IF function of excel. This is how the formula works:. You can check the formula used in the image above, in case you want to use it in your Spreadsheet.

This has been a guide to Options Trading Strategies. You can learn more about derivatives and trading from the following articles —. Free Investment Banking Course. Login details for this Free course will be emailed to you. 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.

Forgot Password? Buying calls can be an excellent way to capture the upside potential with limited downside risk. It is the most basic of all options trading strategies. It is comparatively an easy strategy to understand. When you buy, it means you are bullish on a stock or an index, and you expect to rise in the future.

Best time to Use: When you are very bullish on the stock or index. Risk: Risk is limited to the Premium. This is not a hypothetical situation but is actually seen today in Axis bank scrip. It gets updated by itself if you are connected to internet and Macros and enabled in your excel sheet. Thanks for the excel sheet. Its very good work. Do we have same sheet available for Nifty 50 Stocks?

If yes please share. Its very good wowrk form your side. Keep it up. Hello Sir, 1st thank you so much for sharing your precious knowledge to publicly …. Please guide me as to how can I trade with your excellent sheet in option market? I could not understand. Hi, Thanks for the spreadsheet! Is it possible to use the spreadsheet to retreive US Crude Oil data? How to use this for options on other companies. Can anyone describe the excel, what is it that you are using, that is fetching data.

I dont see any macro enabled.

Please tell me, so that I can update it for other stocks as well. It is fetching data using Web queries. To use for any other scrip, it would require modification in formulas. Thanks for the excel sheets and also i would please request you to make an excel sheet for stock option analysis by input of any name of the stock, so if we trade in stocks we can get some idea on stock analysis.

Thanks a lot. Your effort of simplifying the trading is amazing. A very good tool provided to trading community. The error is solved by just dragging down the formula in A and B columns for rest of the cells. You may want to check up on this and fix it in the source script. This is a great insight for all the people who are not able to see correct values in the sheet. Thanks a lot! Hello Sir, Great work… Can you also add functionality to provide stock options aswell.

Please provide xls with selection of stock to provide stock option data.

Hi, Can we upload this excel on google spreadsheet and get the live data? Actually I have tried after uploading excel on google sheet but not getting live data. Is there any way to do it than please help me out. After download it is opening in smartphone excel but showing last update 06 jun And today is 26 jan 19 Plse suggest.

There may be loss of functionalities in mobile version of Excel. Hence desktop version is recommended. The sheet is showing the data of current week expiry not the monthly expiry…thanks. Thank you very much Sir, for your great efforts and great kindness for sharing your work for free, I have just downloaded it, and will try to understand it first.

However , I will have to learn how to use it to get Buy or Sell signals out of it.

Admin I am software Eng and would like to customise the sheet to allow to query any INDEX or Stock script for a selection of expiry dates would it be possible to publish this here so people can test and give their opinion. Sir, Shall we get OI for commodity and I need to trace every seconds OI data for particular strike price its available. Hi Admin, I am getting the fllowing error even after following the instructions.

How to use the Sheet?

Data is not downloading. The excel sheet works only on MS office version and above.

Actually this error is visible in Mac office excel not in windows Excel…. Can you suggest how to get this corrected. Just suggestion would be enough. The issue seems is in privacy setting. Privacy level options did not appear in Mac office. Hi, I just downloaded new sheet and setup the cookie.

Please help to resolve. Please clarify. Please check it for the possible resolution of this error.