WMT Options History — October 2007

In October 2007, WMT traded between $14.62 and $15.69. ATM implied volatility averaged 23.2%, placing in the 47.7% IV rank vs the trailing year. The 30-day expected move averaged 6.8%. IV traded above realized volatility by 5.1% (HV 20d: 18.1%). Max pain ranged from $14.17 to $15.00. Net GEX was positive for 23 of 23 trading days. Term structure was in contango for 5 of 23 days. Put/call ratio averaged 0.64.

Notable Days

  • 2007-10-11: Highest Volume — 407,610 contracts
  • 2007-10-16: Largest IV spike — 10.2% change
  • 2007-10-25: Highest IV Rank — 69.3%
  • 2007-10-25: Largest Expected Move — 7.9%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$15.09$14.62$15.69$14.82$15.07
Max Pain$14.86$14.17$15.00$14.17$15.00
ATM IV23.2%18.1%27.6%19.0%26.6%
Expected Move6.8%5.2%7.9%5.5%7.6%
HV 20d18.1%15.2%21.1%18.3%20.2%
HV 60d23.9%23.1%24.5%24.2%23.1%
IV Rank47.7%22.8%69.3%27.3%64.4%
IV Percentile79.2%48.9%97.1%57.8%94.3%
Term Structure-0.2%-1.7%3.5%2.6%-1.6%
VWIV23.5%18.4%28.5%19.3%26.3%
Skew 25d4.6%3.0%9.4%9.4%5.2%
Skew 10d10.3%4.5%17.5%17.5%14.9%
Call IV 25d21.7%13.9%26.8%13.9%24.6%
Put IV 25d26.4%21.5%31.7%23.3%29.8%
Bid-Ask Spread %8.624.8315.474.837.06
Gamma HHI0.160.140.270.150.16
Net GEX37.1M20.1M67.2M28.1M29.1M
Net DEX-1.27B-2.15B-580.9M-976.9M-1.09B
Net VEX-17.8M-18.0M-17.5M-17.7M-17.7M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.640.171.620.230.78
Total Volume120,356.73938,382407,610141,07251,915
Total OI5,998,338.5225,778,2676,182,5535,778,2676,077,628

Daily Data (23 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call VolPut VolCall OIPut OI
2007-10-01$14.82$14.1719.0%5.5%18.3%27.3%19.3%9.4%2.6%28.1M-976.9M-17.7M0.234.83114,70526,3673,505,9292,272,338
2007-10-02$14.96$14.1718.1%5.2%18.3%22.8%18.6%3.6%3.5%31.8M-1.14B-17.9M0.176.81195,46532,7333,520,5482,277,624
2007-10-03$15.04$14.1718.8%5.4%16.4%26.0%18.4%3.9%2.8%35.8M-1.34B-17.9M0.666.82127,44683,7963,577,6682,283,900
2007-10-04$15.00$14.1718.6%5.3%16.5%25.0%20.4%3.0%2.9%33.0M-1.21B-18.0M1.416.1415,89722,4853,597,5132,307,927
2007-10-05$15.12$15.0018.7%6.1%16.0%25.6%20.8%3.8%-0.1%36.7M-1.40B-18.0M0.2110.52118,19124,7113,591,6782,316,282
2007-10-08$15.09$15.0019.8%6.4%16.0%31.2%21.5%4.3%-0.6%40.8M-1.35B-17.8M0.488.5329,97914,3193,632,1542,309,127
2007-10-09$15.07$15.0019.5%6.4%15.4%29.7%21.0%3.8%0.6%40.0M-1.30B-17.9M0.828.3256,68246,2813,649,7972,315,748
2007-10-10$15.20$15.0020.7%6.4%15.2%35.5%21.3%4.5%-0.2%43.4M-1.52B-17.7M0.879.1468,07059,4033,669,2312,314,998
2007-10-11$15.63$15.0021.4%6.1%17.6%38.8%21.9%4.1%-0.5%50.3M-2.05B-17.8M0.539.38266,067141,5433,695,2142,350,698
2007-10-12$15.69$15.0021.3%6.1%17.6%38.5%21.3%4.1%-0.6%57.0M-2.15B-18.0M0.406.9334,72813,8543,745,2452,410,623
2007-10-15$15.48$15.0022.5%6.5%18.5%44.4%23.2%4.2%-0.9%51.2M-1.88B-17.7M0.459.4159,20226,3553,721,1792,399,382
2007-10-16$15.29$15.0024.8%7.1%17.5%55.7%24.6%4.2%-1.0%45.2M-1.56B-17.8M1.049.5824,51625,5453,723,4232,404,986
2007-10-17$15.33$15.0025.4%7.3%17.4%58.5%24.3%4.3%-1.0%45.1M-1.60B-17.9M0.988.5463,52262,2503,727,0592,414,190
2007-10-18$15.30$15.0025.1%7.2%16.9%56.9%24.4%4.3%-1.0%40.9M-1.54B-17.9M0.3815.4743,98316,8993,738,6842,440,485
2007-10-19$14.99$15.0027.0%7.7%18.6%66.3%26.0%4.3%-1.6%67.2M-1.15B-18.0M0.8213.1760,76850,0793,737,6492,444,904
2007-10-22$15.08$15.0025.7%7.4%18.5%60.0%25.2%6.7%-0.4%28.9M-1.10B-17.9M0.4210.0082,46134,8363,552,8402,270,538
2007-10-23$14.64$15.0026.5%7.6%20.4%63.6%26.4%5.1%-1.3%22.1M-627.4M-17.5M0.478.44168,77480,0613,602,2202,289,567
2007-10-24$14.62$15.0026.5%7.6%20.4%63.7%27.2%4.9%-0.9%20.1M-580.9M-17.5M0.577.7980,51146,1463,630,2252,345,310
2007-10-25$14.63$15.0027.6%7.9%20.2%69.3%28.5%4.9%-1.2%21.6M-595.1M-17.7M1.629.2647,19976,6653,631,7282,343,213
2007-10-26$14.88$15.0026.3%7.5%21.1%62.8%26.7%4.4%-0.7%24.7M-873.5M-18.0M0.488.9032,94315,6693,635,1242,396,940
2007-10-29$15.00$15.0026.7%7.7%20.3%64.9%26.8%4.2%-1.2%28.0M-1.05B-17.7M0.305.2838,95511,7123,633,4952,393,688
2007-10-30$15.12$15.0026.9%7.7%20.2%66.0%26.1%5.5%-1.7%32.1M-1.21B-17.7M0.687.9444,26230,2553,656,7242,406,363
2007-10-31$15.07$15.0026.6%7.6%20.2%64.4%26.3%5.2%-1.6%29.1M-1.09B-17.7M0.787.0629,11522,8003,660,4892,417,139