General Topics
Technical Topics
Brokerage Firms
Community Lounge
Site Support

# option expiration games

Discussion in 'Options' started by riskfreetrading, Dec 18, 2008.

Summarize your understanding of the option expiration games.

One of my rules/hypothesis: on Thursday and Friday of expiration week, the underlying ETF/index becomes a derivative of the options. Therefore, the underlying/derivative relationship between options and equities are reversed.

2. ### rc5781

my understanding of quad witching is that weird shit be happening, watch out anything can happen...

how do you make money with that?

4. ### rc5781

how do you make money by knowing the underlying/derivative relationship between options and equities are reversed?

Not sure how, but I price undelying using options rather that pricing options using undelying. It is more an insight rather than a recipe to make money. If underlying is a derivative of options then the market is manipulated. Maybe avoiding it is a way to make money (by avoiding losses).

6. ### timbo

Excessive amounts of cannabis usually makes one think backassward.

7. ### spindr0

Whoosh....whoosh.. whoosh...

No, I did not inhale. I'm just a heavy breather

On a more serious note, if there are any IB/DDE/TWS users proficient in Excel, I'd greatly appreciate your two cents regarding a problem I'm having. Math skills not optional

8. ### CET

I also believe I heard there will be S&P rebalancing tomorrow, and this causes some strange trading with big volume near the close.

9. ### Kevin Schmit

If the problem is really a zero appearing between dde cell updates you can solve your problem by setting iterations to some finite number, say 10, in your Calculations menu, and then using a circular reference.

If the dde data of interest is in A1, then the following formula in B1 should do it:

=IF(A1=0,B1,IF(A1>0.30,beep(),0))

assuming your have created a function named beep

10. ### dmo

I wonder if the problem is DDE, which is ancient and horrible. Hoadley has a much-improved way of bringing data into Excel - and it works with IB. It is certainly more user-friendly than DDE, as it doesn't use DDE-style hard coding. That is particularly true for option traders, who end up having to do a lot of manual hard-coding with DDE, or use clumsy work-arounds.

So the Hoadley method would be much easier to use, but I don't know if it would solve your beeping problem. It would only cost about \$100 to try it though.

#10     Dec 19, 2008
ET IS FREE BECAUSE OF THE FINANCIAL SUPPORT FROM THESE COMPANIES: