MSFT Options History — November 2009

In November 2009, MSFT traded between $27.53 and $30.11. ATM implied volatility averaged 23.1%, placing in the 4.1% IV rank vs the trailing year. The 30-day expected move averaged 6.7%. IV traded below realized volatility by 0.4% (HV 20d: 23.5%). Max pain ranged from $26.00 to $28.00. Net GEX was positive for 20 of 20 trading days. Term structure was in contango for 20 of 20 days. Put/call ratio averaged 0.60.

Notable Days

  • 2009-11-16: Highest Volume — 1,269,324 contracts
  • 2009-11-27: Largest IV spike — 16.5% change
  • 2009-11-03: Highest IV Rank — 8.9%
  • 2009-11-03: Largest Expected Move — 7.6%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$29.19$27.53$30.11$27.88$29.41
Max Pain$27.60$26.00$28.00$26.00$28.00
ATM IV23.1%19.6%26.5%25.5%23.4%
Expected Move6.7%5.6%7.6%7.3%6.7%
HV 20d23.5%15.9%27.2%26.4%16.2%
HV 60d21.6%20.6%22.3%22.0%21.0%
IV Rank4.1%0.0%8.9%7.4%8.4%
IV Percentile7.2%0.0%19.4%15.9%11.9%
Term Structure0.9%0.4%1.6%1.3%0.5%
VWIV23.8%19.9%27.3%26.1%23.5%
Skew 25d2.6%1.6%4.0%4.0%1.6%
Skew 10d5.3%3.2%7.6%7.0%3.2%
Call IV 25d22.5%19.3%26.0%24.4%23.0%
Put IV 25d25.2%21.0%28.9%28.4%24.6%
Bid-Ask Spread %3.032.623.683.143.32
Gamma HHI0.180.120.280.120.19
Net GEX66.9M52.2M87.0M59.5M53.1M
Net DEX-2.89B-4.02B-2.01B-2.68B-2.03B
Net VEX-13.8M-15.1M-13.0M-15.1M-13.2M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.600.051.730.460.75
Total Volume149,676.630,3611,269,324111,98574,652
Total OI3,787,685.73,384,8124,089,3983,946,1613,449,590

Daily Data (20 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2009-11-02$27.88$26.0025.5%7.3%26.4%7.4%26.1%4.0%1.3%59.5M-2.68B-15.1M0.463.14N/AN/A76,76935,2162,344,9921,601,169
2009-11-03$27.53$26.0026.5%7.6%26.8%8.9%27.3%3.0%0.7%55.0M-2.44B-15.1M0.592.73N/AN/A47,39527,8102,341,4911,610,581
2009-11-04$28.06$26.0025.4%7.3%27.2%7.1%25.6%3.2%1.0%60.9M-2.85B-14.7M0.413.00N/AN/A40,80716,5962,357,6241,619,457
2009-11-05$28.47$26.0024.0%6.9%26.7%4.9%24.2%3.1%1.5%65.2M-3.17B-14.2M0.472.90N/AN/A48,21922,5842,355,8271,622,338
2009-11-06$28.52$28.0023.4%7.1%26.4%4.0%26.5%3.5%1.1%66.9M-3.21B-14.4M0.322.80N/AN/A86,15227,4112,367,3671,626,738
2009-11-09$28.99$28.0023.2%6.8%26.7%3.6%24.0%3.2%0.7%72.9M-3.43B-14.6M0.223.27N/AN/A64,77413,9702,391,0321,633,449
2009-11-10$29.01$28.0022.4%6.8%26.8%2.3%24.3%3.2%0.8%72.2M-3.50B-13.7M0.683.04N/AN/A67,31545,5222,367,1451,635,804
2009-11-11$29.12$28.0023.4%6.8%26.8%3.9%24.4%3.0%0.5%70.3M-3.61B-13.9M0.453.12N/AN/A63,40128,8042,381,4561,659,171
2009-11-12$29.36$28.0024.1%6.9%25.4%5.1%24.5%3.1%0.5%72.8M-3.79B-14.0M0.693.68N/AN/A39,71027,5502,395,2491,666,397
2009-11-13$29.63$28.0022.9%6.6%25.0%3.1%23.6%2.4%1.3%74.8M-4.02B-13.6M0.332.94N/AN/A134,80844,7662,403,4461,673,793
2009-11-16$29.54$28.0022.8%6.5%24.9%3.0%23.8%2.6%0.9%82.2M-3.89B-13.2M0.052.78N/AN/A1,211,74957,5752,405,0291,684,369
2009-11-17$30.00$28.0023.1%6.6%25.1%3.4%23.7%2.7%0.4%87.0M-2.68B-13.0M0.443.13N/AN/A110,90848,4041,883,5011,712,682
2009-11-18$30.11$28.0023.0%6.6%25.1%3.3%23.2%2.3%0.5%86.5M-2.65B-13.9M0.572.91N/AN/A49,87228,2931,898,1911,729,799
2009-11-19$29.78$28.0023.5%6.7%25.7%4.1%23.7%2.0%0.4%82.8M-2.49B-13.7M0.633.03N/AN/A59,11037,3451,891,7371,745,001
2009-11-20$29.62$28.0022.3%6.4%19.2%2.2%22.5%2.1%0.8%55.2M-2.37B-13.4M0.612.62N/AN/A54,36633,0641,904,8311,753,533
2009-11-23$29.94$28.0021.0%6.0%17.9%0.1%21.4%2.3%1.5%54.9M-2.40B-13.2M0.653.33N/AN/A35,17222,9471,782,9821,601,830
2009-11-24$29.91$28.0019.6%5.6%17.8%0.0%20.2%2.0%1.6%56.3M-2.24B-13.5M1.353.35N/AN/A30,39541,0641,788,4051,612,240
2009-11-25$29.79$28.0019.8%5.7%15.9%0.4%19.9%1.6%1.6%56.7M-2.34B-13.0M1.732.87N/AN/A39,83168,8451,794,5331,618,308
2009-11-27$29.22$28.0023.1%6.6%17.7%7.5%23.2%1.9%0.8%52.2M-2.01B-13.4M0.622.69N/AN/A18,76411,5971,806,3901,636,237
2009-11-30$29.41$28.0023.4%6.7%16.2%8.4%23.5%1.6%0.5%53.1M-2.03B-13.2M0.753.32N/AN/A42,58132,0711,809,7581,639,832