博文

Designing My Page

2017-11-30 12:11

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(SUM ...

个人分类: CLUB|2003 次阅读|1 个评论

How to design Page of COSINE

2017-11-28 13:25

Working on COSINE PAGE Create the page of cosine, name it COSINE A1: DATE, E1:GZ1=DATA!E1:GZ1 A2: SGI, E2:GZ2 =DATA!E2:GZ2 GZ3=DATA!GZ3/GZ$2, Decimal 4 Copy and paste to COSINE!A3:GZ32 NEXT COSINE GRAPHICS COSINE!$GA$3:$GZ$3,TITLE COSINE!$A$3 Then change $3 to $4, $5,… ti ...

个人分类: CLUB|1556 次阅读|1 个评论

How to design other Trend Pages

2017-11-28 13:19

How to design other Trend Pages from DAILY Next, I will explain how to use page Daily page to generate Weekly, Bi-Weekly, and Monthly Trends: Copy and paste the page Daily, and name it as Weekly. Go to Page DATA From GZ, group5 (GV3:GZ32) columns as This week ， group second 5(GQ3:GU32) colum ...

个人分类: CLUB|1665 次阅读|1 个评论

PAGE OF TRENDS

2017-11-25 08:39

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 yest ...

个人分类: CLUB|2369 次阅读|2 个评论

Why we need a new worksheet

2017-11-24 02:30

Thanks for JP‘ email. Her email broughta very good question. Why we need a new worksheet We have been a very successful year of 2017: after three months paper trading, we formed the first COLO Group and registered with Colorado state and invested into Fidelity mutual fundsmarket. The in ...

个人分类: CLUB|1484 次阅读|1 个评论

The new watching list of 30 stocks for the new year of 2018

2017-11-24 01:32

Hi, GB and others, I am in Tucson AZ. I am working on designing a new worksheet for the new year of 2018. This worksheet will include 30 variables, as well. The thirty variables will be stocks, instead of mutual funds, differ from last year, but not the ETFs. I have been collecting inputs f ...

个人分类: CLUB|1604 次阅读|1 个评论

【向量代数】（终结篇-25）

2017-11-10 13:52

So far, we have been logically reasoning the systems monitoring. Before go any further, let me give a summary: Our world is made of systems, a single variable has to be put in a multitde systems to make meaning. For example a stock, it looks like a random variable, jumping around,but a ...

个人分类: CLUB|1295 次阅读|没有评论

【向量代数】（终结篇-24）

2017-11-10 13:43

Combining the three trends : up, even, or down, with three turns ( TT ): concave, straight, or convex, these nine states describes each of the 17 funds and market more clearly than using scalars before. Then the 17 funds can be put in order by their Trend Values and/or Second De ...

个人分类: CLUB|1243 次阅读|没有评论

【向量代数】（终结篇-22）

2017-11-10 13:24

Back to continue our discussion on systems monitoring. For systems monitorin,g we bring in time indices: k , k -1, k -2 Instead of using IV, now we use cosine to express the state of vectors: Then the systems successional trends are defined as present cosine over the pr ...

个人分类: CLUB|1268 次阅读|没有评论

本页有 1 篇博文因作者的隐私设置或未通过审核而隐藏