$$Excel-Macros$$ Re: Risk Graphs

2009-04-13 Thread mother
This is perfect. Thank you so much. On Apr 12, 6:07 pm, Tom Jeffries wrote: > If you want the y-axis (vertical)  to change dynamically check the "Auto" > box on the y-axis scale tab. The x-axis (horizontal) will change > automatically based on stock values. > The attached spreadsheet creates a s

$$Excel-Macros$$ Re: Risk Graphs

2009-04-12 Thread Tom Jeffries
If you want the y-axis (vertical) to change dynamically check the "Auto" box on the y-axis scale tab. The x-axis (horizontal) will change automatically based on stock values. The attached spreadsheet creates a simple risk graph for put and call options. If you have any questions let me know. Tom

$$Excel-Macros$$ Re: Risk Graphs

2009-04-10 Thread mother
Yes, this is what I am looking for. I guess the X-axis is fixed and cannot dynamically adjust. Now I have to figure out how to do this with an Option (put or call). http://www.optiontradingpedia.com/option_trading_risk_graphs.htm I'm not interested in the option combos, but just one option (put o

$$Excel-Macros$$ Re: Risk Graphs

2009-04-10 Thread Tom Jeffries
Take a look at the attached spreadsheet. I think it does what you want. If you have any questions let me know. Tom Jeffries On Fri, Apr 10, 2009 at 8:44 AM, mother wrote: > > > I'm trying to figure out how to create a Simple Risk Graph (profit/ > lost diagram) like the one described at Investo