Input new data in yellow boxes below:
Willis Enhanced 90 Day  Cash Barclay Systematic S&P500
Last day of month: VAMI Value T-Bill Return S&P 500 Price VAMI Value Returns
7/31/10                      1,774.17 0.0132% 1101.60 1,740 6.88%
When macro is finish, the cursor will appear here:
Calculations
Name: Willis Enhanced S&P500 Barclay Systematic Index
Trailing 12 months: 2.54% 11.56% -0.91%
Start to Date: 77.4% -7.5% 31.4%
Winning months: 43 38 32
Losing months: 19 24 30
% of profitable months: 69% 61% 52%
Average Winning months: 1.89% 2.81% 1.95%
Average Losing months: -1.17% -4.61% -1.13%
Max peak-to-valley (%): -6.11% -52.56% -5.95%
Max peak-to-valley (months): 18 33 19
Annual Sharpe Ratio: 1.21 -0.20 0.43
Standard Deviation of returns: 2.12% 4.81% 1.95%
Downside Deviation: 0.78% 4.17% 0.91%
Correlation with S&P500 -0.072 1.000 -0.119
Correlation with Barclay 0.318 -0.119 1.000
Program Start Date Jun-05
Start Value 1,000.00 0.2463% 1191.50 1,325.73
Trailing 12 months:                      1,730.24 0.0153% 987.48 1,757.76
Program VAMI Benchmark Data Return % VAMI winning months losing months Peak-2-Valley: New Peak Peak-2-Valley: # Months off peak Peak-to-Valley: % (Return-risk free rate) for Sharpe
Year End Willis Enhanced 90-Day T-Bill S&P500 Barclay Systematic Model S&P Barclay Model S&P Barclay Model S&P Barclay Model S&P Barclay Model S&P Barclay Model S&P Barclay Model S&P Barclay Model S&P Barclay
7/31/10                      1,774.17 0.0132% 1101.60 1,741.80 -0.37% 6.88% 0.18% 1774 1064 1742   6.9% 0.2% -0.4%     1781 1549 1828 1 33 19 -0.4% -28.9% -4.7% -0.4% 6.9% 0.2%
6/30/10                      1,780.75 0.0099% 1030.71 1,738.67 0.65% -5.39% -0.05% 1781 995 1739 0.6%       -5.4% -0.0% 1781 1549 1828 0 32 18 0.0% -33.5% -4.9% 0.6% -5.4% -0.1%
5/31/10                      1,769.30 0.0136% 1089.41 1,739.54 0.83% -8.20% -0.78% 1769 1052 1740 0.8%       -8.2% -0.8% 1781 1549 1828 18 31 17 -0.6% -29.7% -4.8% 0.8% -8.2% -0.8%
4/30/10                      1,754.81 0.0132% 1186.69 1,753.22 0.54% 1.48% 0.42% 1755 1146 1753 0.5% 1.5% 0.4%       1781 1549 1828 17 30 16 -1.5% -23.4% -4.1% 0.5% 1.5% 0.4%
3/31/10                      1,745.44 0.0127% 1169.43 1,745.89 -0.22% 5.88% 1.56% 1745 1129 1746   5.9% 1.6% -0.2%     1781 1549 1828 16 29 15 -2.0% -24.5% -4.5% -0.2% 5.9% 1.5%
2/28/10                      1,749.25 0.0084% 1104.49 1,719.07 0.56% 2.85% -0.09% 1749 1067 1719 0.6% 2.9%       -0.1% 1781 1549 1828 15 28 14 -1.8% -28.7% -5.9% 0.5% 2.8% -0.1%
1/31/10                      1,739.57 0.0051% 1073.87 1,720.62 0.61% -3.70% -2.63% 1740 1037 1721 0.6%       -3.7% -2.6% 1781 1549 1828 14 27 13 -2.3% -30.7% -5.9% 0.6% -3.7% -2.6%
12/31/09                      1,728.95 0.0042% 1115.10 1,767.09 -1.18% 1.78% -2.26% 1729 1077 1767   1.8%   -1.2%   -2.3% 1781 1549 1828 13 26 12 -2.9% -28.0% -3.3% -1.2% 1.8% -2.3%
11/30/09                      1,749.62 0.0042% 1095.63 1,807.95 1.62% 5.74% 2.73% 1750 1058 1808 1.6% 5.7% 2.7%       1781 1549 1828 12 25 11 -1.7% -29.3% -1.1% 1.6% 5.7% 2.7%
10/31/09                      1,721.76 0.0059% 1036.19 1,759.91 -0.11% -1.98% -1.49% 1722 1001 1760       -0.1% -2.0% -1.5% 1781 1549 1828 11 24 10 -3.3% -33.1% -3.7% -0.1% -2.0% -1.5%
9/30/09                      1,723.60 0.0099% 1057.08 1,786.53 -0.97% 3.57% 0.89% 1724 1021 1787   3.6% 0.9% -1.0%     1781 1549 1828 10 23 9 -3.2% -31.8% -2.3% -1.0% 3.6% 0.9%
8/31/09                      1,740.43 0.0144% 1020.62 1,770.77 0.59% 3.36% 0.74% 1740 986 1771 0.6% 3.4% 0.7%       1781 1549 1828 9 22 8 -2.3% -34.1% -3.1% 0.6% 3.3% 0.7%
7/31/09                      1,730.24 0.0153% 987.48 1,757.76 0.10% 0.07% -0.41% 1730 954 1758 0.1% 0.1%       -0.4% 1781 1549 1828 8 21 7 -2.8% -36.3% -3.8% 0.1% 0.1% -0.4%
6/30/09                      1,728.55 0.0148% 919.32 1,765.00 -0.46% 0.02% -1.39% 1729 953 1765   0.0%   -0.5%   -1.4% 1781 1549 1828 7 20 6 -2.9% -40.7% -3.4% -0.5% 0.0% -1.4%
5/31/09                      1,736.62 0.0153% 919.14 1,789.87 1.16% 5.31% 2.11% 1737 953 1790 1.2% 5.3% 2.1%       1781 1549 1828 6 19 5 -2.5% -40.7% -2.1% 1.1% 5.3% 2.1%
4/30/09                      1,716.72 0.0132% 872.81 1,752.89 -1.37% 9.39% -1.39% 1717 905 1753   9.4%   -1.4%   -1.4% 1781 1549 1828 5 18 4 -3.6% -43.7% -4.1% -1.4% 9.4% -1.4%
3/31/09                      1,740.52 0.0187% 797.87 1,777.60 -1.94% 8.54% -2.03% 1741 827 1778   8.5%   -1.9%   -2.0% 1781 1549 1828 4 17 3 -2.3% -48.5% -2.7% -2.0% 8.5% -2.0%
2/28/09                      1,774.87 0.0230% 735.09 1,814.43 0.12% -10.99% -0.23% 1775 762 1814 0.1%       -11.0% -0.2% 1781 1549 1828 3 16 2 -0.3% -52.6% -0.7% 0.1% -11.0% -0.3%
1/31/09                      1,772.66 0.0110% 825.88 1,818.61 0.84% -8.57% -0.50% 1773 856 1819 0.8%       -8.6% -0.5% 1781 1549 1828 2 15 1 -0.5% -46.7% -0.5% 0.8% -8.6% -0.5%
12/31/08                      1,757.86 0.0025% 903.25 1,827.75 -1.28% 0.78% 1.64% 1758 936 1828   0.8% 1.6% -1.3%     1781 1549 1828 1 14 0 -1.3% -41.7% 0.0% -1.3% 0.8% 1.6%
11/30/08                      1,780.73 0.0156% 896.24 1,798.26 0.16% -7.49% 2.06% 1781 929 1798 0.2%   2.1%   -7.5%   1781 1549 1798 0 13 0 0.0% -42.2% 0.0% 0.1% -7.5% 2.0%
10/31/08                      1,777.89 0.0584% 968.75 1,761.96 0.76% -16.94% 4.56% 1778 1004 1762 0.8%   4.6%   -16.9%   1778 1549 1762 0 12 0 0.0% -37.5% 0.0% 0.7% -17.0% 4.5%
9/30/08                      1,764.47 0.0943% 1166.36 1,685.12 2.14% -9.08% 1.71% 1764 1209 1685 2.1%   1.7%   -9.1%   1764 1549 1716 0 11 3 0.0% -24.7% -1.8% 2.0% -9.2% 1.6%
8/31/08                      1,727.52 0.1482% 1282.83 1,656.79 2.29% 1.22% -0.01% 1728 1330 1657 2.3% 1.2%       -0.0% 1728 1549 1716 0 10 2 0.0% -17.2% -3.5% 2.1% 1.1% -0.2%
7/31/08                      1,688.83 0.1406% 1267.38 1,656.96 0.58% -0.99% -3.46% 1689 1314 1657 0.6%       -1.0% -3.5% 1689 1549 1716 0 9 1 0.0% -18.2% -3.5% 0.4% -1.1% -3.6%
6/30/08                      1,679.09 0.1549% 1280.00 1,716.34 2.37% -8.60% 2.27% 1679 1327 1716 2.4%   2.3%   -8.6%   1679 1549 1716 0 8 0 0.0% -17.4% 0.0% 2.2% -8.8% 2.1%
5/31/08                      1,640.21 0.1491% 1400.37 1,678.25 0.85% 4.75% 1.32% 1640 1452 1678 0.8% 4.8% 1.3%       1640 1549 1691 0 7 3 0.0% -9.6% -0.7% 0.7% 4.6% 1.2%
4/30/08                      1,626.46 0.1074% 1385.58 1,656.38 0.93% 4.75% -0.87% 1626 1386 1656 0.9% 4.8%       -0.9% 1626 1549 1691 0 6 2 0.0% -10.6% -2.0% 0.8% 4.6% -1.0%
3/31/08                      1,611.46 0.1084% 1322.70 1,670.92 3.60% -0.60% -1.16% 1611 1323 1671 3.6%       -0.6% -1.2% 1611 1549 1691 0 5 1 0.0% -14.6% -1.2% 3.5% -0.7% -1.3%
2/29/08                      1,555.41 0.1719% 1330.63 1,690.53 6.81% -3.48% 6.42% 1555 1331 1691 6.8%   6.4%   -3.5%   1555 1549 1691 0 4 0 0.0% -14.1% 0.0% 6.6% -3.7% 6.2%
1/31/08                      1,456.26 0.2389% 1378.54 1,588.54 -2.97% -6.12% 2.70% 1456 1379 1589     2.7% -3.0% -6.1%   1501 1549 1589 1 3 0 -3.0% -11.0% 0.0% -3.2% -6.4% 2.5%
12/31/07                      1,500.88 0.2607% 1468.35 1,546.78 0.34% -0.86% 1.03% 1501 1469 1547 0.3%   1.0%   -0.9%   1501 1549 1547 0 2 0 0.0% -5.2% 0.0% 0.1% -1.1% 0.8%
11/30/07                      1,495.86 0.2753% 1481.14 1,531.01 1.89% -4.40% 0.92% 1496 1482 1531 1.9%   0.9%   -4.4%   1496 1549 1531 0 1 0 0.0% -4.4% 0.0% 1.6% -4.7% 0.6%
10/31/07                      1,468.17 0.3397% 1549.37 1,517.05 2.36% 1.48% 2.42% 1468 1550 1517 2.4% 1.5% 2.4%       1468 1549 1517 0 0 0 0.0% 0.0% 0.0% 2.0% 1.1% 2.1%
9/30/07                      1,434.26 0.3279% 1526.74 1,481.21 4.45% 3.58% 4.50% 1434 1528 1481 4.4% 3.6% 4.5%       1463 1531 1481 10 4 0 -1.9% -0.3% 0.0% 4.1% 3.3% 4.2%
8/31/07                      1,373.22 0.3669% 1473.99 1,417.43 -2.02% 1.29% -2.11% 1373 1475 1417   1.3%   -2.0%   -2.1% 1463 1531 1465 9 3 16 -6.1% -3.7% -3.3% -2.4% 0.9% -2.5%
7/31/07                      1,401.52 0.4213% 1455.27 1,447.98 -1.38% -3.20% -1.14% 1402 1456 1448       -1.4% -3.2% -1.1% 1463 1531 1465 8 2 15 -4.2% -4.9% -1.2% -1.8% -3.6% -1.6%
6/30/07                      1,421.16 0.3896% 1503.35 1,464.68 1.73% -1.78% 1.78% 1421 1504 1465 1.7%   1.8%   -1.8%   1463 1531 1465 7 1 14 -2.8% -1.8% 0.0% 1.3% -2.2% 1.4%
5/31/07                      1,397.00 0.4136% 1530.62 1,439.06 0.05% 3.26% 1.43% 1397 1531 1439 0.1% 3.3% 1.4%       1463 1531 1465 6 0 13 -4.5% 0.0% -1.8% -0.4% 2.8% 1.0%
4/30/07                      1,396.28 0.4118% 1482.37 1,418.77 0.92% 4.33% 2.16% 1396 1483 1419 0.9% 4.3% 2.2%       1463 1482 1465 5 0 12 -4.5% 0.0% -3.2% 0.5% 3.9% 1.7%
3/31/07                      1,383.55 0.4315% 1420.86 1,388.77 -1.21% 1.00% -1.89% 1384 1421 1389   1.0%   -1.2%   -1.9% 1463 1438 1465 4 2 11 -5.4% -1.2% -5.2% -1.6% 0.6% -2.3%
2/28/07                      1,400.54 0.3958% 1406.82 1,415.53 -2.46% -2.19% -1.48% 1401 1407 1416       -2.5% -2.2% -1.5% 1463 1438 1465 3 1 10 -4.2% -2.2% -3.4% -2.9% -2.6% -1.9%
1/31/07                      1,435.84 0.4340% 1438.24 1,436.79 -1.10% 1.41% 1.00% 1436 1439 1437   1.4% 1.0% -1.1%     1463 1438 1465 2 0 9 -1.8% 0.0% -1.9% -1.5% 1.0% 0.6%
12/31/06                      1,451.88 0.4221% 1418.30 1,422.57 -0.73% 1.26% -0.06% 1452 1419 1423   1.3%   -0.7%   -0.1% 1463 1418 1465 1 0 8 -0.7% 0.0% -2.9% -1.2% 0.8% -0.5%
11/30/06                      1,462.54 0.4167% 1400.63 1423.42 1.98% 1.65% 2.00% 1463 1401 1423 2.0% 1.7% 2.0%       1463 1401 1465 0 0 7 0.0% 0.0% -2.8% 1.6% 1.2% 1.6%
10/31/06                      1,434.19 0.4289% 1377.94 1395.51 1.38% 3.15% 0.37% 1434 1378 1396 1.4% 3.2% 0.4%       1434 1378 1465 0 0 6 0.0% 0.0% -4.8% 0.9% 2.7% -0.1%
9/30/06                      1,414.71 0.4052% 1335.85 1390.37 2.64% 2.46% -0.22% 1415 1336 1390 2.6% 2.5%       -0.2% 1415 1336 1465 0 0 5 0.0% 0.0% -5.1% 2.2% 2.1% -0.6%
8/31/06                      1,378.27 0.4323% 1303.82 1393.43 4.66% 2.13% -0.07% 1378 1304 1393 4.7% 2.1%       -0.1% 1378 1311 1465 0 4 4 0.0% -0.5% -4.9% 4.2% 1.7% -0.5%
7/31/06                      1,316.85 0.4315% 1276.66 1394.41 -0.92% 0.51% -2.43% 1317 1277 1394   0.5%   -0.9%   -2.4% 1329 1311 1465 1 3 3 -0.9% -2.6% -4.8% -1.3% 0.1% -2.9%
6/30/06                      1,329.03 0.4044% 1270.20 1429.14 1.88% 0.01% -1.54% 1329 1271 1429 1.9% 0.0%       -1.5% 1329 1311 1465 0 2 2 0.0% -3.1% -2.5% 1.5% -0.4% -1.9%
5/31/06                      1,304.56 0.4111% 1270.09 1451.49 2.82% -3.09% -0.93% 1305 1270 1451 2.8%       -3.1% -0.9% 1305 1311 1465 0 1 1 0.0% -3.1% -0.9% 2.4% -3.5% -1.3%
4/30/06                      1,268.72 0.3879% 1310.61 1465.12 0.71% 1.22% 4.05% 1269 1311 1465 0.7% 1.2% 4.1%       1278 1311 1465 3 0 0 -0.7% 0.0% 0.0% 0.3% 0.8% 3.7%
3/31/06                      1,259.80 0.3932% 1294.83 1408.09 -0.12% 1.11% 1.51% 1260 1295 1408   1.1% 1.5% -0.1%     1278 1295 1415 2 0 2 -1.4% 0.0% -0.5% -0.5% 0.7% 1.1%
2/28/06                      1,261.26 0.3483% 1280.66 1387.14 -1.33% 0.05% -1.94% 1261 1281 1387   0.1%   -1.3%   -1.9% 1278 1281 1415 1 0 1 -1.3% 0.0% -1.9% -1.7% -0.3% -2.3%
1/31/06                      1,278.29 0.3686% 1280.08 1414.59 4.68% 2.55% 1.55% 1278 1280 1415 4.7% 2.6% 1.6%       1278 1280 1415 0 0 0 0.0% 0.0% 0.0% 4.3% 2.2% 1.2%
12/31/05                      1,221.12 0.3372% 1248.29 1,392.99 3.92% -0.09% -0.82% 1221 1248 1393 3.9%       -0.1% -0.8% 1221 1249 1405 0 1 1 0.0% -0.1% -0.8% 3.6% -0.4% -1.2%
11/30/05                      1,175.03 0.3263% 1249.48 1,404.54 0.05% 3.52% 3.22% 1175 1250 1405 0.0% 3.5% 3.2%       1175 1249 1405 0 0 0 0.0% 0.0% 0.0% -0.3% 3.2% 2.9%
10/31/05                      1,174.50 0.3219% 1207.01 1,360.72 7.63% -1.77% -0.19% 1175 1207 1361 7.6%       -1.8% -0.2% 1175 1234 1363 0 3 1 0.0% -2.2% -0.2% 7.3% -2.1% -0.5%
9/30/05                      1,091.24 0.2868% 1228.81 1,363.31 4.86% 0.69% 0.37% 1091 1229 1363 4.9% 0.7% 0.4%       1091 1234 1363 0 2 0 0.0% -0.4% 0.0% 4.6% 0.4% 0.1%
8/31/05                      1,040.71 0.2990% 1220.33 1,358.29 0.20% -1.12% 1.04% 1041 1220 1358 0.2%   1.0%   -1.1%   1041 1234 1358 0 1 0 0.0% -1.1% 0.0% -0.1% -1.4% 0.7%
7/31/05                      1,038.65 0.2794% 1234.18 1,344.31 3.10% 3.60% -0.45% 1039 1234 1344 3.1% 3.6%       -0.4% 1039 1234 1350 0 0 1 0.0% 0.0% -0.4% 2.8% 3.3% -0.7%
6/30/05                      1,007.39 0.2499% 1191.33 1,350.38 0.74% -0.01% 1.86% 1007 1191 1350 0.7%   1.9%   -0.0%   1007 1192 1350 0 1 0 0.0% 0.0% 0.0% 0.5% -0.3% 1.6%
5/31/05                      1,000.00 0.2463% 1191.50 1,325.73   1000 1192 1326             1000 1192 1326 0 0 0 0.0% 0.0% 0.0% -0.2% -0.2% -0.2%