Anyone using the hoadley XL add-in?

Discussion in 'Options' started by nonprophet, Dec 8, 2006.

  1. gbos : nice ! I had in mind something very similar. BTW , what is "time offset " ?
     
    #31     Dec 11, 2006
  2. gbos

    gbos

    It shows how your P/L diagram will look like in 1, 2, .... trading days in the future, up until the first expiry.
     
    #32     Dec 11, 2006
  3. got it . I want to go one extra step and graph an overlay of current PnL vs MAX at exp ( based on change in vols) on the same screen. I want to use it for possible early exits if current PnL is close to MAX. How diff would be develop this , in your opinion ?
     
    #33     Dec 11, 2006
  4. Seems he can’t do it.

    You can start any combo by setting your overall volatility, calculate theoretical prices, view your P/L graph and then adjust vol to see the graph change.

    OR:
    you can start with real prices, calculate their respective IV’s, and here it comes: then examine future P/L/ graphs based on adjusting ONE overall volatility. (Compare: you can adjust each leg’s strike separately, but not its vol.)

    As I wrote earlier: I just don’t see how this is done. So one leg today has IV 120, another has 80, and then we examine future P/L based on vol 90. How would the program handle this? Do all IV’s suddenly agree on 90 as from tomorrow? Lineary approach 90 toward expiration?

    Does anyone know? How can you sensibly analyze especially a calendar if you can’t set different IV’s?

    basis perhaps? You’re a 12-year pro, I’m a 3-year amateur. No tease, I’m seriously interested and perhaps missing the obvious.

    Note:
    I still didn’t buy it, IV_Trader’s remark held me back. :(

    My conclusion is based on online demo

    http://www.hoadley.net/options/demos.aspx

    under “sensitivity analysis”.
     
    #34     Dec 12, 2006
  5. You're foolish to let what iv trader says hold you back.

    It is staring you in the face. Look at the sheet in the demo and see the column called "Implied Volatility". You can change the IV for each option in that column.

    You can also download the free strategy evaluation tool and see it firsthand.
     
    #35     Dec 16, 2006