博文
PAGE OF TRENDS
||
WORKSHEET DESIGNING
TREND ANALYSIS PAGE
DAILY
(A3:A32): STOCK CODE
(D3:D32): The closing prices of 30 stocks of the day before yesterday.
(D2): SGI of the day before yesterday.
SGI=SQRT(SUMSQ(DAILY!D3:D32))
(E3:E32): The closing prices of 30 stocks of yesterday.
(E2): SGI of yesterday.
(F3:F32): Theclosing prices of 30 stocks of today.
(F2): SGI of today.
(G2): SGI%, =E2/D2, increasing rate of SGI
(G3:G32): Trendvalues of the 30 stocks of yesterday. The expectation is one, greater than one,means increasing, less than one means decreasing.
(H2): SGI%, =F2/E2, the increasing rate of SGI.
(H3:H32): Trend values of the 30 stocks of today. Stock% adjusted by SGI%. The expectation is one, greater than one, means increasing, less than one means decreasing.
(I2): Trend%, increasing rate MIT2/MIT1
(I3:I32): SecondDegree Trend values of the 30 stocks. The expectation is one, greater than one, means concave, less than one means convex.
(J2): MIT2*MITproduction of Trends
(J3:J32): AcomulatedTrend values (longer term trends)of the 30 stocks. The expectation is one, greater than one, means increasing, less than one means decreasing.
| A | B | C | D | E | F | G | H | I | J | |
| 1 | K-2 | K-1 | K | MIT1 | MIT2 | MIT/MIT | MIT*MIT | |||
| 2 | SGI | 898.326 | 895.240 | 901.392 | 0.996564 | 1.006871 | ||||
| 3 | AAPL | $173.14 | $174.96 | $174.97 | 1.0140 | 0.9932 | 0.9795 | 1.0071 | ||
| 4 | ADBE | $184.15 | $182.90 | $184.46 | 0.9966 | 1.0016 | 1.0050 | 0.9983 | ||
| 5 | ALGN | $256.43 | $254.38 | $254.76 | 0.9954 | 0.9947 | 0.9992 | 0.9901 | ||
| 6 | ANET | $241.43 | $239.01 | $242.06 | 0.9934 | 1.0058 | 1.0125 | 0.9992 | ||
| 7 | AVGO | $276.59 | $275.37 | $282.38 | 0.9990 | 1.0185 | 1.0195 | 1.0175 | ||
| 8 | BABA | $190.90 | $189.84 | $191.19 | 0.9979 | 1.0002 | 1.0024 | 0.9981 | ||
| 9 | BIDU | $244.30 | $249.65 | $249.42 | 1.0254 | 0.9923 | 0.9677 | 1.0175 | ||
| 10 | CGNX | $144.86 | $143.15 | $144.38 | 0.9916 | 1.0017 | 1.0102 | 0.9933 | ||
| 11 | DIA | $235.73 | $235.17 | $235.47 | 1.0011 | 0.9944 | 0.9934 | 0.9955 | ||
| 12 | EXAS | $59.75 | $59.17 | $59.27 | 0.9937 | 0.9949 | 1.0012 | 0.9886 | ||
| 13 | FB | $181.86 | $180.87 | $182.78 | 0.9980 | 1.0037 | 1.0057 | 1.0016 | ||
| 14 | FDN | $109.75 | $110.05 | $111.01 | 1.0062 | 1.0018 | 0.9957 | 1.0080 | ||
| 15 | FTEC | $50.78 | $50.66 | $50.92 | 1.0011 | 0.9983 | 0.9972 | 0.9993 | ||
| 16 | HD | $172.86 | $172.06 | $172.33 | 0.9988 | 0.9947 | 0.9959 | 0.9935 | ||
| 17 | HFC | $44.79 | $44.39 | $44.05 | 0.9945 | 0.9856 | 0.9910 | 0.9801 | ||
| 18 | JPM | $98.93 | $98.64 | $98.32 | 1.0005 | 0.9900 | 0.9895 | 0.9905 | ||
| 19 | KO | $45.78 | $45.84 | $45.88 | 1.0048 | 0.9940 | 0.9893 | 0.9988 | ||
| 20 | LOGM | $118.10 | $119.20 | $119.05 | 1.0128 | 0.9919 | 0.9794 | 1.0046 | ||
| 21 | LRCX | $218.91 | $215.17 | $216.83 | 0.9863 | 1.0008 | 1.0147 | 0.9871 | ||
| 22 | MCD | $168.30 | $169.05 | $169.11 | 1.0079 | 0.9935 | 0.9857 | 1.0014 | ||
| 23 | MIME | $30.69 | $30.70 | $30.53 | 1.0038 | 0.9877 | 0.9840 | 0.9914 | ||
| 24 | MSFT | $83.72 | $83.11 | $83.26 | 0.9961 | 0.9950 | 0.9988 | 0.9911 | ||
| 25 | NVDA | $216.05 | $214.93 | $216.96 | 0.9982 | 1.0026 | 1.0043 | 1.0008 | ||
| 26 | QID | $13.51 | $13.47 | $13.38 | 1.0005 | 0.9865 | 0.9861 | 0.9870 | ||
| 27 | ROG | $167.15 | $163.04 | $165.03 | 0.9788 | 1.0053 | 1.0271 | 0.9840 | ||
| 28 | SGMS | $52.20 | $52.00 | $51.70 | 0.9996 | 0.9874 | 0.9878 | 0.9871 | ||
| 29 | SPY | $259.99 | $259.76 | $260.36 | 1.0026 | 0.9955 | 0.9929 | 0.9980 | ||
| 30 | TXN | $99.19 | $98.08 | $99.30 | 0.9922 | 1.0055 | 1.0134 | 0.9977 | ||
| 31 | V | $111.45 | $110.82 | $111.97 | 0.9978 | 1.0035 | 1.0057 | 1.0012 | ||
| 32 | WMT | $96.52 | $96.41 | $96.62 | 1.0023 | 0.9953 | 0.9931 | 0.9976 |
(to be continued)
https://blog.sciencenet.cn/blog-333331-1086720.html
上一篇：Why we need a new worksheet
下一篇：How to design other Trend Pages
