Input new data in yellow boxes below:
Swinford 90 Day  Cash Barclay Discretionary S&P500
Last day of month: VAMI Value T-Bill Return S&P 500 Price Index Vami Value Returns
10/31/08                      4,650.62 0.0584% 968.75 1,742 -16.94%
To update  calculations & layouts: Run Macro Advance_one_month :
When macro is finish, the cursor will appear here:
Calculations
Name: Swinford S&P500 Barclay Discretionary Index
Trailing 12 months: 21.66% -37.47% 15.41%
Start to Date: 365.1% -4.7% 80.6%
Winning months: 79 68 78
Losing months: 42 53 43
% of profitable months: 65% 56% 64%
Average Winning months: 3.02% 3.05% 1.17%
Average Losing months: -1.84% -3.78% -0.72%
Max peak-to-valley (%): -9.89% -46.28% -3.29%
Max peak-to-valley (months): 8 80 13
Annual Sharpe Ratio: 1.09 -0.17 0.61
Standard Deviation of returns: 3.33% 4.41% 1.24%
Downside Deviation: 2.02% 3.31% 0.69%
Correlation with S&P500 0.053 1.000 -0.072
Correlation with Barclay 0.186 -0.072 1.000
Program Start Date Oct-98
Start Value 1,000.00 0.3896% 1017.01 1,000.00
Trailing 12 months:                      3,822.75 0.3397% 1549.37 1,565.18
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 Swinford 90-Day T-Bill S&P500 Barclay Discretionary 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
10/31/08                      4,650.62 0.0584% 968.75 1,806.38 -1.3% -16.94% 3.35% 4651 969 1806     3.3% -1.3% -16.9%   4710 1549 1806 1 12 0 -1.3% -37.5% 0.0% -1.3% -17.0% 3.3%
9/30/08                      4,709.90 0.0943% 1166.36 1,747.83 1.1% -9.08% 0.11% 4710 1167 1748 1.1%   0.1%   -9.1%   4710 1549 1766 0 11 3 0.0% -24.7% -1.0% 1.0% -9.2% 0.0%
8/31/08                      4,659.70 0.1482% 1282.83 1,745.91 -0.3% 1.22% 0.33% 4660 1283 1746   1.2% 0.3% -0.3%     4675 1549 1766 1 10 2 -0.3% -17.2% -1.2% -0.5% 1.1% 0.2%
7/31/08                      4,674.83 0.1406% 1267.38 1,740.17 2.6% -0.99% -1.48% 4675 1268 1740 2.6%       -1.0% -1.5% 4675 1549 1766 0 9 1 0.0% -18.2% -1.5% 2.5% -1.1% -1.6%
6/30/08                      4,556.70 0.1549% 1280.00 1,766.31 7.9% -8.60% 2.57% 4557 1281 1766 7.9%   2.6%   -8.6%   4557 1549 1766 0 8 0 0.0% -17.4% 0.0% 7.8% -8.8% 2.4%
5/31/08                      4,221.20 0.1491% 1400.37 1,722.05 -0.8% 1.07% 0.81% 4221 1401 1722   1.1% 0.8% -0.8%     4341 1549 1729 2 7 3 -2.8% -9.6% -0.4% -0.9% 0.9% 0.7%
4/30/08                      4,255.28 0.1074% 1385.58 1,708.22 -2.0% 4.75% -0.03% 4255 1386 1708   4.8%   -2.0%   -0.0% 4341 1549 1729 1 6 2 -2.0% -10.6% -1.2% -2.1% 4.6% -0.1%
3/31/08                      4,341.20 0.1084% 1322.70 1,708.73 4.4% -0.60% -1.15% 4341 1323 1709 4.4%       -0.6% -1.2% 4341 1549 1729 0 5 1 0.0% -14.6% -1.2% 4.3% -0.7% -1.3%
2/29/08                      4,156.89 0.1719% 1330.63 1,728.61 -0.1% -3.48% 4.72% 4157 1331 1729     4.7% -0.1% -3.5%   4161 1549 1729 1 4 0 -0.1% -14.1% 0.0% -0.3% -3.7% 4.5%
1/31/08                      4,161.35 0.2389% 1378.54 1,650.70 4.9% -6.12% 2.82% 4161 1379 1651 4.9%   2.8%   -6.1%   4161 1549 1651 0 3 0 0.0% -11.0% 0.0% 4.7% -6.4% 2.6%
12/31/07                      3,967.36 0.2607% 1468.35 1,605.42 3.4% -0.86% 2.02% 3967 1469 1605 3.4%   2.0%   -0.9%   3967 1549 1605 0 2 0 0.0% -5.2% 0.0% 3.1% -1.1% 1.8%
11/30/07                      3,836.67 0.2753% 1481.14 1,573.64 0.4% -4.40% 0.54% 3837 1482 1574 0.4%   0.5%   -4.4%   3837 1549 1574 0 1 0 0.0% -4.4% 0.0% 0.1% -4.7% 0.3%
10/31/07                      3,822.75 0.3397% 1549.37 1,565.18 5.8% 1.48% -0.20% 3823 1550 1565 5.8% 1.5%       -0.2% 3823 1549 1568 0 0 1 0.0% 0.0% -0.2% 5.5% 1.1% -0.5%
9/30/07                      3,611.56 0.3279% 1526.74 1568.32 2.2% 3.58% 2.17% 3612 1528 1568 2.2% 3.6% 2.2%       3777 1531 1568 3 4 0 -4.4% -0.3% 0.0% 1.8% 3.3% 1.8%
8/31/07                      3,535.44 0.3669% 1473.99 1535.01 0.3% 1.29% -0.49% 3535 1475 1535 0.3% 1.3%       -0.5% 3777 1531 1543 2 3 1 -6.4% -3.7% -0.5% -0.1% 0.9% -0.9%
7/31/07                      3,525.08 0.4213% 1455.27 1542.57 -6.7% -3.20% 0.77% 3525 1456 1543     0.8% -6.7% -3.2%   3777 1531 1543 1 2 0 -6.7% -4.9% 0.0% -7.1% -3.6% 0.3%
6/30/07                      3,776.50 0.3896% 1503.35 1530.78 5.0% -1.78% 0.54% 3777 1504 1531 5.0%   0.5%   -1.8%   3777 1531 1542 0 1 4 0.0% -1.8% -0.7% 4.6% -2.2% 0.2%
5/31/07                      3,596.23 0.4136% 1530.62 1522.56 -0.3% 3.26% 0.88% 3596 1531 1523   3.3% 0.9% -0.3%     3698 1531 1542 5 0 3 -2.8% 0.0% -1.3% -0.7% 2.8% 0.5%
4/30/07                      3,605.30 0.4118% 1482.37 1509.28 -1.0% 4.33% -1.80% 3605 1483 1509   4.3%   -1.0%   -1.8% 3698 1518 1542 4 80 2 -2.5% -2.3% -2.1% -1.5% 3.9% -2.2%
3/31/07                      3,643.25 0.4315% 1420.86 1536.94 -0.9% 1.00% -0.34% 3643 1422 1537   1.0%   -0.9%   -0.3% 3698 1518 1542 3 79 1 -1.5% -6.4% -0.3% -1.3% 0.6% -0.8%
2/28/07                      3,675.00 0.3958% 1406.82 1542.19 2.9% -2.19% 1.24% 3675 1407 1542 2.9%   1.2%   -2.2%   3698 1518 1542 2 78 0 -0.6% -7.3% 0.0% 2.5% -2.6% 0.8%
1/31/07                      3,572.74 0.4340% 1438.24 1523.30 -3.4% 1.41% 0.78% 3573 1439 1523   1.4% 0.8% -3.4%     3698 1518 1523 1 77 0 -3.4% -5.2% 0.0% -3.8% 1.0% 0.3%
12/31/06                      3,698.29 0.4221% 1418.30 1511.51 3.0% 1.26% 0.94% 3698 1419 1512 3.0% 1.3% 0.9%       3698 1518 1512 0 76 0 0.0% -6.5% 0.0% 2.6% 0.8% 0.5%
11/30/06                      3,589.38 0.4167% 1400.63 1497.43 6.9% 1.65% 1.92% 3589 1401 1497 6.9% 1.7% 1.9%       3589 1518 1497 0 75 0 0.0% -7.7% 0.0% 6.5% 1.2% 1.5%
10/31/06                      3,357.36 0.4289% 1377.94 1469.22 4.7% 3.15% 2.65% 3357 1379 1469 4.7% 3.2% 2.7%       3559 1518 1469 5 74 0 -5.7% -9.2% 0.0% 4.3% 2.7% 2.2%
9/30/06                      3,207.05 0.4052% 1335.85 1431.29 -1.1% 2.46% -0.17% 3207 1336 1431   2.5%   -1.1%   -0.2% 3559 1518 1464 4 73 5 -9.9% -12.0% -2.3% -1.5% 2.1% -0.6%
8/31/06                      3,242.61 0.4323% 1303.82 1433.73 -6.3% 2.13% -0.84% 3243 1304 1434   2.1%   -6.3%   -0.8% 3559 1518 1464 3 72 4 -8.9% -14.1% -2.1% -6.7% 1.7% -1.3%
7/31/06                      3,458.89 0.4315% 1276.66 1445.88 0.2% 0.51% -0.18% 3459 1277 1446 0.2% 0.5%       -0.2% 3559 1518 1464 2 71 3 -2.8% -15.9% -1.3% -0.2% 0.1% -0.6%
6/30/06                      3,451.06 0.4044% 1270.20 1448.48 -3.0% 0.01% -0.85% 3451 1271 1448   0.0%   -3.0%   -0.9% 3559 1518 1464 1 70 2 -3.0% -16.3% -1.1% -3.4% -0.4% -1.3%
5/31/06                      3,559.09 0.4111% 1270.09 1460.90 0.7% -3.09% -0.23% 3559 1271 1461 0.7%       -3.1% -0.2% 3559 1518 1464 0 69 1 0.0% -16.3% -0.2% 0.2% -3.5% -0.6%
4/30/06                      3,536.02 0.3879% 1310.61 1464.27 -0.1% 1.22% 0.99% 3536 1311 1464   1.2% 1.0% -0.1%     3538 1518 1464 1 68 0 -0.1% -13.6% 0.0% -0.4% 0.8% 0.6%
3/31/06                      3,537.95 0.3932% 1294.83 1449.91 3.5% 1.11% 1.31% 3538 1295 1450 3.5% 1.1% 1.3%       3538 1518 1450 0 67 0 0.0% -14.7% 0.0% 3.1% 0.7% 0.9%
2/28/06                      3,418.12 0.3483% 1280.66 1431.17 1.0% 0.05% 0.69% 3418 1281 1431 1.0% 0.1% 0.7%       3418 1518 1431 0 66 0 0.0% -15.6% 0.0% 0.7% -0.3% 0.3%
1/31/06                      3,384.26 0.3686% 1280.08 1421.36 3.3% 2.55% 1.20% 3384 1280 1421 3.3% 2.6% 1.2%       3384 1518 1421 0 65 0 0.0% -15.7% 0.0% 2.9% 2.2% 0.8%
12/31/05                      3,277.39 0.3372% 1248.29 1404.51 0.0% -0.09% 1.39% 3277 1249 1405 0.0%   1.4%   -0.1%   3277 1518 1405 0 64 0 0.0% -17.8% 0.0% -0.3% -0.4% 1.1%
11/30/05                      3,276.22 0.3263% 1249.48 1385.25 0.9% 3.52% 0.45% 3276 1250 1385 0.9% 3.5% 0.4%       3276 1518 1385 0 63 0 0.0% -17.7% 0.0% 0.6% 3.2% 0.1%
10/31/05                      3,246.66 0.3219% 1207.01 1379.04 1.0% -1.77% -0.14% 3247 1207 1379 1.0%