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 ...
PPT NOTES, V.10 1 Appl. Math Seminar, 223 Weber, Thursday, Sept.14, 2017 Title: Theodorus Spiral, Vector Algebra andSystem Monitoring Speaker: T. Jay Bai, Ph.D. 970-495-9716, tjbmdsm@yahoo.com Abstract: “Theodorus Spiral” can be expressed as a 17*17diagonal matrix, and then ...
MDSM Communication 171011 About the ARI: You COULD change the components/variables/funds, but you should NOT change them in middle of an experiment. We have been working in 30 dimensional space. So, changing variables is changing the 30-space, then everything in the 30-space get screwed. ...