||
Recall:
This will be the starting point for second test for the new year of 2018, "Using the 30-DIA, but to overcome the DIA".
Column ABCD are the starting point on 12/29/2017;
while the Column FGHI are the ending point of given day, as today.
But, column E is the ratio between the starting and ending points.
This table includes all and every stocks in DIA30. The DIA listed them by weight, we are listed them by code alphabetically to easier to find a variable. This might cost a little bit differences, might.
My goal is to beat the market everage, sum of A VALUES, in orange.
TABLE ONE | ||||||||
12/29/2017 | % | 12/31/2017 | ||||||
SGI | 754.2765621 | 0.00% | 754.2765621 | |||||
PRICES | ARI | A SHARES | 0.00% | PRICES | A VALUES | M SHARE | M VALUES | |
TOTAL | $ 14,274.00 | 0.00% | $ 14,274.00 | $14,274.00 | ||||
SPAXX | $14,274.00 | |||||||
CASH | 0 | 0 | 0 | |||||
AAPL | $169.23 | 475.80 | 2.8116 | 0.00% | $169.23 | $ 475.80 | 0 | $0.00 |
AXP | $99.31 | 475.80 | 4.7911 | 0.00% | $99.31 | $ 475.80 | 0 | $0.00 |
BA | $294.91 | 475.80 | 1.6134 | 0.00% | $294.91 | $ 475.80 | 0 | $0.00 |
CAT | $157.58 | 475.80 | 3.0194 | 0.00% | $157.58 | $ 475.80 | 0 | $0.00 |
CSCO | $38.30 | 475.80 | 12.4230 | 0.00% | $38.30 | $ 475.80 | 0 | $0.00 |
CVX | $125.19 | 475.80 | 3.8006 | 0.00% | $125.19 | $ 475.80 | 0 | $0.00 |
DIS | $107.51 | 475.80 | 4.4256 | 0.00% | $107.51 | $ 475.80 | 0 | $0.00 |
DWDP | $71.22 | 475.80 | 6.6807 | 0.00% | $71.22 | $ 475.80 | 0 | $0.00 |
GE | $17.45 | 475.80 | 27.2665 | 0.00% | $17.45 | $ 475.80 | 0 | $0.00 |
GS | $254.76 | 475.80 | 1.8676 | 0.00% | $254.76 | $ 475.80 | 0 | $0.00 |
HD | $189.53 | 475.80 | 2.5104 | 0.00% | $189.53 | $ 475.80 | 0 | $0.00 |
IBM | $153.42 | 475.80 | 3.1013 | 0.00% | $153.42 | $ 475.80 | 0 | $0.00 |
INTC | $46.16 | 475.80 | 10.3076 | 0.00% | $46.16 | $ 475.80 | 0 | $0.00 |
JNJ | $139.72 | 475.80 | 3.4054 | 0.00% | $139.72 | $ 475.80 | 0 | $0.00 |
JPM | $106.94 | 475.80 | 4.4492 | 0.00% | $106.94 | $ 475.80 | 0 | $0.00 |
KO | $45.88 | 475.80 | 10.3705 | 0.00% | $45.88 | $ 475.80 | 0 | $0.00 |
MCD | $172.12 | 475.80 | 2.7644 | 0.00% | $172.12 | $ 475.80 | 0 | $0.00 |
MMM | $235.37 | 475.80 | 2.0215 | 0.00% | $235.37 | $ 475.80 | 0 | $0.00 |
MRK | $56.27 | 475.80 | 8.4557 | 0.00% | $56.27 | $ 475.80 | 0 | $0.00 |
MSFT | $85.54 | 475.80 | 5.5623 | 0.00% | $85.54 | $ 475.80 | 0 | $0.00 |
NKE | $62.55 | 475.80 | 7.6067 | 0.00% | $62.55 | $ 475.80 | 0 | $0.00 |
PFE | $36.22 | 475.80 | 13.1364 | 0.00% | $36.22 | $ 475.80 | 0 | $0.00 |
PG | $91.88 | 475.80 | 5.1785 | 0.00% | $91.88 | $ 475.80 | 0 | $0.00 |
TRV | $135.64 | 475.80 | 3.5078 | 0.00% | $135.64 | $ 475.80 | 0 | $0.00 |
UNH | $220.46 | 475.80 | 2.1582 | 0.00% | $220.46 | $ 475.80 | 0 | $0.00 |
UTX | $127.57 | 475.80 | 3.7297 | 0.00% | $127.57 | $ 475.80 | 0 | $0.00 |
V | $114.02 | 475.80 | 4.1730 | 0.00% | $114.02 | $ 475.80 | 0 | $0.00 |
VZ | $52.93 | 475.80 | 8.9892 | 0.00% | $52.93 | $ 475.80 | 0 | $0.00 |
WMT | $98.75 | 475.80 | 4.8182 | 0.00% | $98.75 | $ 475.80 | 0 | $0.00 |
XOM | $83.64 | 475.80 | 5.6887 | 0.00% | $83.64 | $ 475.80 | 0 | $0.00 |
Archiver|手机版|科学网 ( 京ICP备07017567号-12 )
GMT+8, 2024-11-24 17:40
Powered by ScienceNet.cn
Copyright © 2007- 中国科学报社