Option Spreadsheet Request

Would anyone be willing and able to share some option spreadsheets that they have developed for the following tactics:

Backspreads (Ratio)
Bull Spreads
Bear Spreads
Back Spreads
Butterfly
Straddle
Strangles
Condors

thank you in advance, and much appreciated.

I use open office.
 
Quote from atticus:

http://www.optionstar.com/arb.htm is a nice add-in which works well with IBTWS.

checked it out. Talks about arbitrage between option chains. You ever used it to trade?? Because its surprising to think that in today's automated world, obvious arbitrages will exist, when all the banks have their auto spreaders and auto-arbitragers working in market.

If software points out something, does it mean your vol/skew assumptions are off-the mark and instead of arbing you are getting arbed, means your greeks won't be hedged if you do that trade?
 
Quote from gmst:

checked it out. Talks about arbitrage between option chains. You ever used it to trade?? Because its surprising to think that in today's automated world, obvious arbitrages will exist, when all the banks have their auto spreaders and auto-arbitragers working in market.

If software points out something, does it mean your vol/skew assumptions are off-the mark and instead of arbing you are getting arbed, means your greeks won't be hedged if you do that trade?

I don't use excel (unix sheets).

No, if you're arbing a calendar, fly or vert, for example, the skew is immaterial if you're long from a credit. These are all going to be minimum-strike spreads and sourced from microstructure. It's simply a decent add-in with pre-built templates and uses IB data.
 
Back
Top