WMT Options History — April 2007

In April 2007, WMT traded between $15.75 and $16.59. ATM implied volatility averaged 18.0%. The 30-day expected move averaged 5.3%. IV traded above realized volatility by 2.2% (HV 20d: 15.8%). Max pain ranged from $15.83 to $15.83. Net GEX was positive for 20 of 20 trading days. Term structure was in contango for 9 of 20 days. Put/call ratio averaged 0.85.

Notable Days

  • 2007-04-11: Highest Volume — 1,042,992 contracts
  • 2007-04-12: Largest IV spike — 17.6% change
  • 2007-04-17: Largest Expected Move — 5.8%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$16.06$15.75$16.59$15.80$15.97
Max Pain$15.83$15.83$15.83$15.83$15.83
ATM IV18.0%14.5%20.3%15.2%19.6%
Expected Move5.3%4.3%5.8%4.4%5.6%
HV 20d15.8%13.5%18.1%15.7%17.1%
HV 60d16.9%16.2%17.7%16.2%17.6%
Term Structure0.0%-1.7%3.2%2.6%-0.8%
VWIV18.2%14.4%20.3%14.4%19.8%
Skew 25d2.4%-2.1%7.6%7.6%2.1%
Skew 10d4.5%-3.9%12.1%12.1%6.3%
Call IV 25d16.9%10.5%18.9%10.5%18.9%
Put IV 25d19.3%13.9%21.5%18.1%20.9%
Bid-Ask Spread %5.843.6511.075.937.51
Gamma HHI0.210.170.370.220.18
Net GEX65.2M53.1M99.8M62.3M55.6M
Net DEX-2.20B-2.90B-1.54B-1.73B-2.08B
Net VEX-19.0M-20.9M-17.9M-18.1M-19.9M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.850.113.230.871.55
Total Volume159,457.9525,6741,042,99254,210105,930
Total OI5,185,428.94,859,8655,748,9634,859,8655,320,893

Daily Data (20 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call VolPut VolCall OIPut OI
2007-04-02$15.80$15.8315.2%4.4%15.7%0.0%14.4%7.6%2.6%62.3M-1.73B-18.1M0.875.9328,92025,2903,078,3031,781,562
2007-04-03$16.03$15.8315.5%4.4%16.0%0.0%15.5%-1.7%3.1%69.7M-1.99B-18.3M0.676.29125,40383,6583,080,3521,780,452
2007-04-04$16.02$15.8315.7%4.5%16.0%0.0%15.7%-2.1%2.6%69.3M-1.96B-18.2M2.225.8116,62036,8913,146,1781,831,698
2007-04-05$16.09$15.8315.2%4.3%16.1%0.0%15.2%-1.1%3.2%63.0M-2.02B-18.0M0.755.5514,69410,9803,092,4121,857,756
2007-04-09$16.16$15.8317.5%5.6%15.7%0.0%17.5%3.6%-0.8%64.5M-2.08B-18.0M0.484.0071,92534,6593,096,3601,863,003
2007-04-10$15.98$15.8316.5%5.4%16.2%0.0%18.4%3.1%0.2%62.7M-1.93B-18.0M2.024.0819,13438,6553,134,0131,873,977
2007-04-11$15.76$15.8314.5%5.2%14.7%0.0%18.3%2.9%0.2%57.7M-1.54B-17.9M0.115.92943,75299,2403,127,4221,889,766
2007-04-12$15.75$15.8317.1%4.9%14.1%0.0%16.8%3.3%0.9%63.7M-2.40B-20.9M0.265.1379,41320,3283,812,4811,936,482
2007-04-13$15.80$15.8316.7%4.8%14.0%0.0%16.4%3.1%0.9%83.1M-2.31B-20.5M0.335.9246,68915,5853,696,1411,908,099
2007-04-16$16.02$15.8319.5%5.6%14.7%0.0%19.2%2.9%-1.2%77.3M-2.28B-19.0M0.154.61241,73436,7443,388,1461,894,593
2007-04-17$16.06$15.8320.3%5.8%14.5%0.0%20.2%2.8%-1.4%61.7M-2.24B-19.1M0.324.2282,52126,2023,340,8211,909,521
2007-04-18$15.99$15.8319.9%5.7%13.7%0.0%19.8%3.0%-1.0%63.9M-2.21B-19.2M3.235.2621,94870,8033,372,1111,914,051
2007-04-19$16.11$15.8320.3%5.8%13.5%0.0%20.1%3.6%-1.4%53.1M-2.27B-19.1M1.014.9835,51136,0093,334,2271,940,796
2007-04-20$16.59$15.8318.8%5.4%16.8%0.0%19.6%4.2%-1.0%99.8M-2.90B-18.5M0.255.51233,02258,8723,334,0291,947,360
2007-04-23$16.31$15.8318.9%5.4%18.0%0.0%19.7%2.0%-1.7%60.4M-2.48B-19.2M0.503.6570,77335,2023,270,0661,826,706
2007-04-24$16.23$15.8320.3%5.8%18.1%0.0%20.3%2.1%-1.2%58.4M-2.36B-19.1M1.376.9878,306107,3973,269,2261,838,010
2007-04-25$16.27$15.8318.9%5.4%17.9%0.0%19.3%1.7%-1.1%59.2M-2.42B-19.6M0.353.7149,46717,0763,322,9531,904,676
2007-04-26$16.23$15.8320.2%5.8%16.4%0.0%18.7%2.0%-1.4%60.0M-2.43B-19.2M0.4011.0763,64525,5573,345,7261,917,783
2007-04-27$16.11$15.8318.9%5.4%16.8%0.0%18.9%2.0%0.1%59.6M-2.33B-19.8M0.2010.7566,94813,6563,391,2391,939,188
2007-04-30$15.97$15.8319.6%5.6%17.1%0.0%19.8%2.1%-0.8%55.6M-2.08B-19.9M1.557.5141,53264,3983,377,3461,943,547