博文
Designing My Page
||
Designing My Page
My page made of two tables.
Table One:
Row 1, two cells: Starting time and today time, (=now())
Row 2, column names: starting Prices, Average Random Investment (ARI), A-Shares, MDSM Investment;
ending prices, A values, M shares, M values.
Row 3: ShangGaoIndex, B3= (SQRT(SUMSQ(B6:B35))=901.3916,
G3= (SQRT(SUMSQ(G6:G35))=901.32529
Row 4: TOTAL, C4=57957=E4
G4: ARI at today, 58069.34; I4: MDSM on today, $57679.45=sum(G6:G37)
Row 6:
A6=AAPL, B6=$174.97 starting price, C6=$57957/30=1931.9, D6=C6/B6=11.0413 ARI shares,
F6, today price, G6 today' A value G6=D6*F6, H6 M investment =0, I6=H6*F6
Row 7-35, same.
Row 36, 37 Cash value (SPAXX)
| TABLE ONE | ||||||||||
| A | B | C | D | E | F | G | H | I | J | |
| 1 | 11/26/2017 | 11/29/2017 | ||||||||
| 2 | PRICES | ARI | A SHARES | M_INVEST | PRICES | A VALUES | M SHARE | M VALUES | ||
| 3 | SGI | 901.3916 | 901.32529 | |||||||
| 4 | TOTAL | 57957 | 57957 | $58,069.34 | $57,679.45 | |||||
| 5 | % | |||||||||
| 6 | AAPL | $174.97 | 1931.9 | 11.0413 | $173.07 | $ 1,910.92 | 0 | $0.00 | -1% | |
| 7 | ADBE | $184.46 | 1931.9 | 10.4733 | $185.40 | $ 1,941.74 | 0 | $0.00 | 1% | |
| ALGN | $254.76 | 1931.9 | 7.5832 | $264.23 | $ 2,003.71 | 0 | $0.00 | 4% | ||
| ANET | $242.06 | 1931.9 | 7.9811 | $243.55 | $ 1,943.79 | 0 | $0.00 | 1% | ||
| AVGO | $282.38 | 1931.9 | 6.8415 | $277.40 | $ 1,897.83 | 0 | $0.00 | -2% | ||
| BABA | $191.19 | 1931.9 | 10.1046 | $186.69 | $ 1,886.43 | 0 | $0.00 | -2% | ||
| BIDU | $249.42 | 1931.9 | 7.7456 | $244.03 | $ 1,890.15 | 0 | $0.00 | -2% | ||
| CGNX | $144.38 | 1931.9 | 13.3807 | $143.83 | $ 1,924.54 | 0 | $0.00 | 0% | ||
| DIA | $235.47 | 1931.9 | 8.2044 | $238.34 | $ 1,955.45 | 0 | $0.00 | 1% | ||
| EXAS | $59.27 | 1931.9 | 32.5949 | $58.79 | $ 1,916.25 | 0 | $0.00 | -1% | ||
| FB | $182.78 | 1931.9 | 10.5695 | $182.42 | $ 1,928.09 | 15 | $2,736.30 | 0% | ||
| FDN | $111.01 | 1931.9 | 17.4029 | $111.26 | $ 1,936.25 | 0 | $0.00 | 0% | ||
| FTEC | $50.92 | 1931.9 | 37.9399 | $50.99 | $ 1,934.56 | 0 | $0.00 | 0% | ||
| HD | $172.33 | 1931.9 | 11.2105 | $176.57 | $ 1,979.43 | 0 | $0.00 | 2% | ||
| HFC | $44.05 | 1931.9 | 43.8570 | $45.26 | $ 1,984.97 | 70 | $3,168.20 | 3% | ||
| JPM | $98.32 | 1931.9 | 19.6491 | $101.36 | $ 1,991.63 | 0 | $0.00 | 3% | ||
| KO | $45.88 | 1931.9 | 42.1077 | $45.83 | $ 1,929.79 | 0 | $0.00 | 0% | ||
| LOGM | $119.05 | 1931.9 | 16.2276 | $120.85 | $ 1,961.11 | 30 | $3,625.50 | 2% | ||
| LRCX | $216.83 | 1931.9 | 8.9097 | $213.14 | $ 1,899.02 | 0 | $0.00 | -2% | ||
| MCD | $169.11 | 1931.9 | 11.4239 | $171.34 | $ 1,957.38 | 0 | $0.00 | 1% | ||
| MIME | $30.53 | 1931.9 | 63.2787 | $30.03 | $ 1,900.26 | 0 | $0.00 | -2% | ||
| MSFT | $83.26 | 1931.9 | 23.2032 | $84.88 | $ 1,969.49 | 35 | $2,970.80 | 2% | ||
| NVDA | $216.96 | 1931.9 | 8.9044 | $210.71 | $ 1,876.25 | 15 | $3,160.65 | -3% | ||
| QID | $13.38 | 1931.9 | 144.3871 | $13.32 | $ 1,923.24 | 0 | $0.00 | 0% | ||
| ROG | $165.03 | 1931.9 | 11.7064 | $163.72 | $ 1,916.56 | 0 | $0.00 | -1% | ||
| SGMS | $51.70 | 1931.9 | 37.3675 | $51.75 | $ 1,933.77 | 0 | $0.00 | 0% | ||
| SPY | $260.36 | 1931.9 | 7.4201 | $262.87 | $ 1,950.52 | 0 | $0.00 | 1% | ||
| TXN | $99.30 | 1931.9 | 19.4552 | $99.48 | $ 1,935.40 | 0 | $0.00 | 0% | ||
| V | $111.97 | 1931.9 | 17.2537 | $113.36 | $ 1,955.88 | 0 | $0.00 | 1% | ||
| 35 | WMT | $96.62 | 1931.9 | 19.9948 | $96.77 | $ 1,934.90 | 0 | $0.00 | 0% | |
| 36 | SPAXX | 57957 | 42018 | |||||||
| 37 | FUNDS | 0 |
So far, the worksheet is done. It cost me a week to finishe it from memory. Now we have these notes, we can design a new worksheet in one day on week end.
https://blog.sciencenet.cn/blog-333331-1087573.html
上一篇：How to design Page of COSINE
下一篇：昨天12月4日是宪法日
