option expiration games

R

riskfreetrading

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.
 
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).
 
Quote from riskfreetrading:

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.
More...
Excessive amounts of cannabis usually makes one think backassward.
 
I also believe I heard there will be S&P rebalancing tomorrow, and this causes some strange trading with big volume near the close.
 
Quote from spindr0:
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 :)
[/B]
More...
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
 
Quote from spindr0:



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 :)

http://www.elitetrader.com/vb/showthread.php?s=&postid=2228437#post2228437
More...

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.
 
You must log in or register to reply here.
Back
Top