Anyone using the hoadley XL add-in?

[IV_Trader]

Quote from gbos:

For simple tasks it is easier to make your own custom excel spreadsheet than learning to use an add-in. The add-in will be useful if you need for example garch etc. as it is difficult to implement the optimization algorithm in VBA etc.

For a simple calendar you can use something like this...

gbos : nice ! I had in mind something very similar. BTW , what is "time offset " ?

 

[gbos]

Quote from IV_Trader:

gbos : nice ! I had in mind something very similar. BTW , what is "time offset " ?

It shows how your P/L diagram will look like in 1, 2, .... trading days in the future, up until the first expiry.

 

[IV_Trader]

Quote from gbos:

It shows how your P/L diagram will look like in 1, 2, .... days in the future, up until the first expiry.

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 ?

 

[nonprophet]

Quote from IV_Trader:

does Hoadly has position's analyzer ? Can one use diff vols for diff month for what ifs ?

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”.

 

[mysticman]

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.