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