| 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% | ||||||||||||||||||||||||||