FDS Options History — April 2007

In April 2007, FDS traded between $60.69 and $62.94. ATM implied volatility averaged 24.8%. The 30-day expected move averaged 7.1%. IV traded above realized volatility by 4.2% (HV 20d: 20.6%). Max pain ranged from $65.00 to $65.00. Net GEX was positive for 7 of 20 trading days. Term structure was in contango for 16 of 20 days. Put/call ratio averaged 0.20.

Notable Days

  • 2007-04-11: Highest Volume — 447 contracts
  • 2007-04-30: Largest IV spike — 22.4% change
  • 2007-04-09: Largest Expected Move — 8.4%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$61.89$60.69$62.94$62.13$61.51
Max Pain$65.00$65.00$65.00$65.00$65.00
ATM IV24.8%20.0%30.3%28.1%24.5%
Expected Move7.1%5.7%8.4%8.1%7.0%
HV 20d20.6%14.2%28.1%28.1%15.3%
HV 60d21.8%21.4%22.5%22.4%21.5%
Term Structure1.0%-3.0%4.1%0.2%0.9%
VWIV23.9%19.8%27.8%27.8%25.1%
Skew 25d1.9%0.0%3.0%2.5%0.0%
Skew 10d3.3%0.0%5.6%4.8%0.0%
Call IV 25d24.2%22.6%25.9%25.9%24.4%
Put IV 25d26.1%24.0%28.4%28.3%24.4%
Bid-Ask Spread %36.3113.7053.1724.3648.00
Gamma HHI0.290.270.330.270.27
Net GEX185-54.7K95.1K33.3K-11.7K
Net DEX371.4K-1.8M2.8M-254.9K371.1K
Net VEX-37.3K-45.3K-32.3K-44.2K-33.7K
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.200.001.000.310.10
Total Volume1793944730699
Total OI4,855.84,0645,4185,2034,297

Daily Data (20 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call VolPut VolCall OIPut OI
2007-04-02$62.13$65.0028.1%8.1%28.1%0.0%27.8%2.5%0.2%33.3K-254.9K-44.2K0.3124.36233732,6492,554
2007-04-03$62.94$65.0024.0%6.9%27.0%0.0%26.5%2.7%3.3%90.7K-1.8M-45.3K0.5230.54132692,7812,527
2007-04-04$62.67$65.0023.7%6.8%27.0%0.0%24.1%2.8%3.7%75.8K-1.2M-44.7K0.3630.50126452,8102,546
2007-04-05$62.49$65.0026.0%7.5%26.2%0.0%24.7%2.1%2.7%95.1K-878.0K-44.3K0.0521.63187102,8812,537
2007-04-09$62.45$65.0030.3%8.4%26.2%0.0%27.7%2.2%-2.1%70.6K-558.0K-42.1K0.2124.01243502,8062,537
2007-04-10$61.81$65.0029.1%7.8%21.3%0.0%26.2%1.9%-0.8%43.0K603.9K-41.1K0.1926.27295552,7742,574
2007-04-11$61.01$65.0025.4%7.3%21.4%0.0%24.1%1.9%0.2%17.5K2.0M-38.1K0.1144.46404432,7592,546
2007-04-12$61.07$65.0024.2%6.9%21.3%0.0%23.5%1.3%0.3%-41.2K2.3M-36.8K0.3423.58174602,5362,506
2007-04-13$60.69$65.0024.4%7.0%19.7%0.0%23.0%1.9%1.2%-53.3K2.8M-35.4K0.0845.173632,4752,466
2007-04-16$61.70$65.0027.6%7.9%21.1%0.0%27.7%3.0%-3.0%-47.2K1.4M-34.9K0.4546.8396432,4732,466
2007-04-17$62.10$65.0025.2%7.2%19.2%0.0%0.0%2.1%0.1%-26.4K487.3K-35.1K0.0853.176352,4922,462
2007-04-18$61.90$65.0024.9%7.1%19.1%0.0%23.7%1.3%-0.2%-21.4K73.3K-34.3K0.0151.8214812,5102,371
2007-04-19$61.04$65.0023.2%6.6%18.1%0.0%22.2%2.1%1.2%-35.8K899.9K-33.4K0.1948.7799192,5762,371
2007-04-20$61.35$65.0022.4%6.4%18.2%0.0%21.3%1.4%1.4%-50.2K812.1K-32.3K1.0041.8987872,5492,383
2007-04-23$62.03$65.0024.3%7.0%18.9%0.0%23.0%1.8%1.4%-54.7K811.2K-33.3K0.0745.03171121,8962,168
2007-04-24$61.58$65.0023.6%6.8%17.5%0.0%22.6%1.4%1.5%-29.9K843.2K-33.0K0.0142.3214321,9882,160
2007-04-25$62.30$65.0024.3%7.0%16.9%0.0%21.3%2.3%0.2%-22.0K-149.4K-34.3K0.0140.289412,0502,158
2007-04-26$62.52$65.0020.6%5.9%15.5%0.0%20.4%1.2%3.0%-12.2K-545.7K-34.1K0.0013.705702,0682,159
2007-04-27$62.56$65.0020.0%5.7%14.2%0.0%19.8%1.7%4.1%-16.0K-518.0K-34.8K0.0023.9611502,0962,159
2007-04-30$61.51$65.0024.5%7.0%15.3%0.0%25.1%0.0%0.9%-11.7K371.1K-33.7K0.1048.009092,1382,159