超球面模型(MDSM)的探索与应用分享 http://blog.sciencenet.cn/u/TUGJAYZHAB 用多元向量表示系统状态,多元向量乘法群描述系统的运动,白-杰时间链连接历史和现实: Y(i,k+1)=[Y(i,k)*T(i,k)+D(i,k+1)]/2。

博文

Designing My Page

已有 1531 次阅读 2017-11-30 12:11 |个人分类:CLUB|系统分类:科研笔记

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








ABCDEFGHIJ
1 11/26/201711/29/2017
2 PRICESARIA SHARESM_INVESTPRICESA VALUESM SHAREM VALUES
3SGI901.3916


901.32529


4TOTAL
57957
57957 $58,069.34
$57,679.45
5%
6AAPL$174.97 1931.911.0413
$173.07 $     1,910.92 0$0.00 -1%
7ADBE$184.46 1931.910.4733
$185.40 $     1,941.74 0$0.00 1%

ALGN$254.76 1931.97.5832
$264.23 $     2,003.71 0$0.00 4%

ANET$242.06 1931.97.9811
$243.55 $     1,943.79 0$0.00 1%

AVGO$282.38 1931.96.8415
$277.40 $     1,897.83 0$0.00 -2%

BABA$191.19 1931.910.1046
$186.69 $     1,886.43 0$0.00 -2%

BIDU$249.42 1931.97.7456
$244.03 $     1,890.15 0$0.00 -2%

CGNX$144.38 1931.913.3807
$143.83 $     1,924.54 0$0.00 0%

DIA$235.47 1931.98.2044
$238.34 $     1,955.45 0$0.00 1%

EXAS$59.27 1931.932.5949
$58.79 $     1,916.25 0$0.00 -1%

FB$182.78 1931.910.5695
$182.42 $     1,928.09 15$2,736.30 0%

FDN$111.01 1931.917.4029
$111.26 $     1,936.25 0$0.00 0%

FTEC$50.92 1931.937.9399
$50.99 $     1,934.56 0$0.00 0%

HD$172.33 1931.911.2105
$176.57 $     1,979.43 0$0.00 2%

HFC$44.05 1931.943.8570
$45.26 $     1,984.97 70$3,168.20 3%

JPM$98.32 1931.919.6491
$101.36 $     1,991.63 0$0.00 3%

KO$45.88 1931.942.1077
$45.83 $     1,929.79 0$0.00 0%

LOGM$119.05 1931.916.2276
$120.85 $     1,961.11 30$3,625.50 2%

LRCX$216.83 1931.98.9097
$213.14 $     1,899.02 0$0.00 -2%

MCD$169.11 1931.911.4239
$171.34 $     1,957.38 0$0.00 1%

MIME$30.53 1931.963.2787
$30.03 $     1,900.26 0$0.00 -2%

MSFT$83.26 1931.923.2032
$84.88 $     1,969.49 35$2,970.80 2%

NVDA$216.96 1931.98.9044
$210.71 $     1,876.25 15$3,160.65 -3%

QID$13.38 1931.9144.3871
$13.32 $     1,923.24 0$0.00 0%

ROG$165.03 1931.911.7064
$163.72 $     1,916.56 0$0.00 -1%

SGMS$51.70 1931.937.3675
$51.75 $     1,933.77 0$0.00 0%

SPY$260.36 1931.97.4201
$262.87 $     1,950.52 0$0.00 1%

TXN$99.30 1931.919.4552
$99.48 $     1,935.40 0$0.00 0%

V$111.97 1931.917.2537
$113.36 $     1,955.88 0$0.00 1%
35WMT$96.62 1931.919.9948
$96.77 $     1,934.90 0$0.00 0%
36SPAXX 57957 42018
37FUNDS



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日是宪法日

0

该博文允许注册用户评论 请点击登录 评论 (1 个评论)

数据加载中...

Archiver|手机版|科学网 ( 京ICP备07017567号-12 )

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

Powered by ScienceNet.cn

Copyright © 2007- 中国科学报社

返回顶部