MSFT Options History — April 2010

In April 2010, MSFT traded between $29.16 and $31.39. ATM implied volatility averaged 20.6%, placing in the 16.3% IV rank vs the trailing year. The 30-day expected move averaged 6.6%. IV traded above realized volatility by 7.2% (HV 20d: 13.4%). Max pain ranged from $28.00 to $30.00. Net GEX was positive for 21 of 21 trading days. Term structure was in contango for 7 of 21 days. Put/call ratio averaged 0.55.

Notable Days

  • 2010-04-22: Highest Volume — 419,340 contracts
  • 2010-04-15: Largest IV spike — 73.1% change
  • 2010-04-22: Highest IV Rank — 37.4%
  • 2010-04-22: Largest Expected Move — 7.9%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$30.52$29.16$31.39$29.16$30.54
Max Pain$29.43$28.00$30.00$28.00$30.00
ATM IV20.6%14.0%27.7%19.1%19.1%
Expected Move6.6%5.1%7.9%5.5%5.5%
HV 20d13.4%11.2%14.8%11.3%13.9%
HV 60d17.1%14.2%18.9%18.6%14.6%
IV Rank16.3%0.0%37.4%4.4%21.2%
IV Percentile21.2%0.0%69.4%7.5%10.3%
Term Structure-1.1%-3.4%6.6%6.6%1.9%
VWIV23.1%17.9%27.7%19.5%19.7%
Skew 25d2.2%1.3%2.8%1.3%1.9%
Skew 10d4.4%2.6%5.9%2.9%4.3%
Call IV 25d22.0%16.8%26.2%19.3%18.6%
Put IV 25d24.2%19.1%28.5%20.6%20.5%
Bid-Ask Spread %3.242.304.512.303.27
Gamma HHI0.190.100.290.230.11
Net GEX80.2M52.3M120.2M82.0M52.3M
Net DEX-1.96B-2.71B-1.32B-1.32B-1.52B
Net VEX-15.6M-16.8M-14.6M-14.8M-16.7M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.550.210.940.510.48
Total Volume153,435.85758,429419,340242,93896,957
Total OI2,937,302.7142,538,7173,223,8962,867,6113,013,626

Daily Data (21 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2010-04-01$29.16$28.0019.1%5.5%11.3%4.4%19.5%1.3%6.6%82.0M-1.32B-14.8M0.512.30N/AN/A161,24181,6971,692,1691,175,442
2010-04-05$29.27$29.0020.1%7.4%11.3%7.7%25.6%2.5%-2.4%82.7M-1.39B-14.8M0.694.27N/AN/A34,56523,8641,717,9691,204,247
2010-04-06$29.32$29.0019.8%7.4%11.3%6.7%25.7%2.4%-2.5%85.1M-1.44B-14.8M0.343.40N/AN/A65,17822,0511,719,6791,210,339
2010-04-07$29.35$29.0019.9%7.4%11.2%7.1%25.8%2.3%-2.6%83.2M-1.44B-14.9M0.653.79N/AN/A71,15846,4091,716,1031,214,488
2010-04-08$29.92$29.0020.0%7.3%12.8%7.3%25.7%2.5%-2.2%97.7M-1.88B-14.6M0.523.69N/AN/A81,26442,4691,716,1031,214,488
2010-04-09$30.34$29.0018.2%7.2%13.4%1.9%25.3%2.8%-2.3%104.4M-2.21B-15.0M0.463.26N/AN/A107,62549,6541,741,6061,241,700
2010-04-12$30.32$29.0020.7%7.3%13.5%9.4%25.4%2.6%-2.5%106.6M-2.23B-14.9M0.622.53N/AN/A56,67835,3661,769,4601,260,571
2010-04-13$30.45$29.0019.8%7.0%13.5%6.6%24.3%2.7%-2.4%109.5M-2.33B-15.2M0.943.47N/AN/A58,34354,7091,779,5751,305,542
2010-04-14$30.82$29.0014.0%6.6%14.0%0.0%23.8%2.7%-2.3%115.2M-2.60B-15.2M0.212.60N/AN/A282,08259,1911,784,5461,335,811
2010-04-15$30.87$29.0024.3%7.0%13.7%28.0%24.8%2.5%-3.1%120.2M-2.71B-15.8M0.452.96N/AN/A84,50238,1621,839,4581,347,221
2010-04-16$30.67$29.0024.1%6.9%14.1%27.5%25.2%2.7%-2.8%89.3M-2.55B-15.8M0.592.88N/AN/A84,84249,7371,863,3571,360,539
2010-04-19$31.04$30.0024.0%6.9%14.5%27.1%24.0%2.4%-2.3%54.2M-1.88B-15.6M0.392.69N/AN/A143,07756,4521,430,4741,108,243
2010-04-20$31.36$30.0023.4%6.7%14.7%25.6%23.4%1.3%-2.1%62.7M-2.11B-15.6M0.612.89N/AN/A80,54249,4841,503,5001,140,686
2010-04-21$31.33$30.0023.7%6.8%14.6%26.4%23.7%1.3%-2.6%62.7M-2.11B-15.8M0.452.63N/AN/A82,16537,0671,526,5541,169,030
2010-04-22$31.39$30.0027.7%7.9%14.1%37.4%27.7%2.2%-3.4%61.2M-2.15B-16.2M0.643.68N/AN/A255,033164,3071,575,2111,189,067
2010-04-23$30.96$30.0019.2%5.5%14.8%14.1%19.4%1.6%0.7%64.5M-1.91B-16.0M0.633.32N/AN/A171,249108,1011,649,4871,267,818
2010-04-26$31.11$30.0019.5%5.6%14.0%22.8%19.8%1.8%0.3%68.2M-1.95B-16.5M0.583.04N/AN/A55,63932,3911,672,9591,279,696
2010-04-27$30.84$30.0020.4%5.9%14.4%26.7%20.9%1.9%0.4%59.3M-1.75B-16.8M0.814.51N/AN/A63,35551,2841,668,1241,293,300
2010-04-28$30.91$30.0018.3%5.3%14.4%17.9%18.5%2.3%1.5%58.8M-1.75B-16.7M0.253.45N/AN/A78,87719,7821,673,8681,316,396
2010-04-29$31.00$30.0017.8%5.1%12.7%15.8%17.9%2.3%1.6%65.4M-1.89B-16.0M0.723.50N/AN/A49,65535,9491,676,2801,318,625
2010-04-30$30.54$30.0019.1%5.5%13.9%21.2%19.7%1.9%1.9%52.3M-1.52B-16.7M0.483.27N/AN/A65,73131,2261,682,7201,330,906