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

全部精选博文导读

GMT+8, 2022-1-23 02:00