# Options trading strategies graphs and charts

This is part 5 of the Option Payoff Excel Tutorialwhich will demonstrate how to draw an option options trading strategies graphs and charts payoff diagram in Excel. One decision we need to make is the range of underlying prices that our diagram will cover. We will make the underlying price range easy to change by setting up two cells for user input — chart start in cell I5 and chart increment in cell I6, as the screenshot below shows.

The formula in cell B13 is:. This will enable us to copy the formula from cell B13 to the cells below it. Each subsequent row will show underlying price higher than the previous one, with the increment set in cell I6. Copy cell B13 to 48 following rows — cells B14 to B Then test your formulas by changing the chart settings in cells I5-I6 and make sure column B is showing the underlying prices that you expect.

For example, this is chart start set to 10 and increment set to 2. Now we have X-axis ready and can calculate the payoff at each point. Of course, the formulas in all rows will be the same — we will create them in the first row row 12 and then copy them to the other rows.

We can use the formulas which we already have in rows 8 and 9, but will have to make a few adjustments. Now we can copy the formula that we have created in cell C12 to all other cells in the CF61 range. Now we can just create a standard line chart with values range GG61 and labels range BB It will show the payoff diagram for our strategy.

We can control the underlying price range effectively zoom in or out by changing the chart settings in cells I5-I6. We can also display payoff diagrams for individual legs **options trading strategies graphs and charts** in such case the chart series value range will be CC61, DD61 etc.

There is of course plenty of room for improvement in terms of layout and visual design — you can change the colors or locations of different parts to adjust the spreadsheet to your options trading strategies graphs and charts, you can make the chart bigger and more prominent etc.

In next two parts of the tutorial, we will look at the calculation of maximum profit, maximum loss and risk-reward ratio. Go to next part: If you don't agree with any part of this Agreement, please leave the website now. All information is for educational purposes only and may be inaccurate, incomplete, outdated or plain wrong.

Macroption is not liable for any damages options trading strategies graphs and charts from using the content. No financial, investment or trading advice is given at any time.

Home Calculators Tutorials About Contact. Tutorial 1 Tutorial 2 Tutorial 3 Tutorial 4. Drawing Option Payoff Diagrams in Excel.

Underlying Price Range One decision we need to make is the range of underlying prices that our diagram will cover. The formula in cell B13 is: Notice the dollar sign absolute reference before the B, but no dollar sign relative reference before the When we copy the formula to other cells, this will make the formulas in the other columns C, D, E still point to column B, but each row will use its options trading strategies graphs and charts underlying price input.

For similar reasons, we must adjust the references to cells C3, C4, C5 and place dollar signs this time options trading strategies graphs and charts the row number, but not before the column letter. It is just like the end of the formula in cell C9, but this time without the ABS, because we also need the direction.

Make sure you get the dollar signs right. Next Steps There is of course plenty of room for improvement in terms of layout and visual design — you can change the colors or locations of different parts to adjust the spreadsheet to your preferences, you can make the chart bigger and more prominent etc.

Options trading strategies graphs and charts graph indicates profit and loss at expiration, respective to the stock value when you sold the call and bought the put.

Buying the put gives you the right to sell the stock at strike price A. You can think of a collar as simultaneously running a protective put and a covered call. Some investors think this is a sexy trade because the covered call helps to pay for the protective put. The call you sell caps the upside.

If the stock has exceeded strike B by expiration, it will most likely be called away. So you must be willing to sell it at that price. Some investors will try to sell the call with enough premium to pay for the put entirely.

Some investors will establish this strategy in a single trade. This limits your downside risk instantly, but of course, it also limits your upside. **Options trading strategies graphs and charts** the point the collar is established, potential profit is limited to strike B minus current stock price minus the net debit paid, or plus net credit received. From the point the collar is established, risk is limited to the current stock price minus strike A plus the net debit paid, or minus the net credit received.

For this strategy, the net effect of time decay is somewhat neutral. It will erode the value of the option you bought bad but it will also erode the value of the option you sold good. After the strategy is established, the net effect of an increase in implied volatility is options trading strategies graphs and charts neutral.

The option you sold will increase in value badbut it will also increase the value of the option you bought good. Options involve risk and are not suitable for all investors. For more information, please review the Characteristics and Risks of Standardized Options brochure before you begin trading options.

Options investors may lose the entire amount of their investment in a relatively short period of time. Multiple leg options strategies involve additional risksand may result in complex tax treatments. Please consult a tax professional prior to implementing these strategies. Implied volatility represents the consensus of the marketplace as to the future level of stock price volatility or the probability of reaching a specific price point.

The Greeks represent the consensus of the marketplace as to how the option will react to changes in certain variables associated with the pricing of an option contract. There is no guarantee that the forecasts of implied volatility or the Greeks will be correct. Ally Invest provides self-directed options trading strategies graphs and charts with discount brokerage services, and does not make recommendations or offer investment, financial, legal or tax advice.

System response and access times may vary due to market conditions, system performance, and other factors. Content, research, tools, and stock or option symbols are for educational and illustrative purposes only and do not imply a recommendation or solicitation to buy or sell a particular security or to engage in any particular investment strategy.

The projections or other information regarding the likelihood of various investment outcomes are hypothetical in nature, are not guaranteed for accuracy or completeness, do not reflect actual investment results and are not guarantees of future results.

All investments involve risk, losses may exceed the principal invested, and the past performance of a security, industry, sector, market, or financial product does not guarantee future results or returns.

The Options Playbook Featuring 40 options strategies for bulls, bears, rookies, all-stars and everyone in between. The Strategy Buying the put gives you the right to sell the stock at strike price A. Both options have the same expiration month. Break-even at Expiration From the point the collar is established, there are two break-even points: If established for a net credit, the break-even is current stock price minus options trading strategies graphs and charts credit received.

If established for a net debit, the break-even is current stock price plus the net debit paid. The Sweet Spot You want the stock price to be above strike B at expiration and have the options trading strategies graphs and charts called away.

Maximum Potential Profit From the point the collar is established, potential profit is limited to strike B minus current stock price minus the net debit paid, or plus net credit received.

Maximum Potential Loss From the point the collar is established, risk is limited to the current stock price minus strike A plus the net debit paid, or minus the net credit received. As Time Goes By For this strategy, the net effect of time decay is somewhat neutral. Implied Volatility After the strategy is established, the net effect of an increase in implied volatility is somewhat neutral.

Topics include descriptive statistics, probability models, estimation, hypothesis testing, and regression analysis. Emphasis on modeling, interpreting results for managerial applications of linear and integer programming models, network problems, simulation models, and decision analysis.

The course bridges quantitative, behavioral, and strategic concepts for designing organizations to be dynamic, integrated systems whose outputs are monitored for quality and continuously improved.

Topics covered include design of products, processes and facilities, planning, scheduling, and controlling options trading strategies graphs and charts and quality.