Replies to post #1858 on QID - QLD TRENDS (fka )

[gmtheodore]

I think that the ratio gives you that heads up, but I've taken that a step further too. I also compute the number of stock that are within 1/2 of a percent in crossing above their 5 and 10 day averages, like like whose on deck.
so currently
Semi 10 Day = 3.85 which is 5 stocks above
Semi 5 Day = 13.85 which is 18 stocks above
Ratio = 3.6
Number of stock within 1/2% of breaking above their averages
10 day = 4
5 day = 6

so if the market keeps moving up the ratio will increase more.
Let me think how to display this.

[gtober]

I'm afraid you've got me there Larry. I used to program once upon a time, but that was long ago.

As a matter of fact, tell me which programming language you use and I just might learn it. I have been thinking about this for a while, and really just don't know which one to study. Visual Basic, JAVA, others?

My Sierra Charts will export directly to Excel tick by tick (or almost per tick anyway) so if I can figure out the programing, perhaps I can contribute more here.

[kevinb]

Larry,

THe simple solution seems to be putting the following formulas in a cell.

=MAX(xx:yy) where xx and yy are cell range references.
=MIN(xx:yy) gets you the same for MIN.

Hope that helps


Kevin