SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : TA-Quotes Plus -- Ignore unavailable to you. Want to Upgrade?

To: Paul Beattie who wrote (3054)1/14/1998 11:12:00 PM
From: TechTrader42  Read Replies (1) | Respond to of 11149
 
Paul and Bob: I've checked the values of Bob's QP slope formula with the values given by this MSWIN formula:

( (14 * (Sum(Cum( 1 ) * C ,14 ) ) ) - (Sum(Cum( 1 ) ,14 ) * (Sum( C ,14) ) ) ) / ( (14 * Sum(Pwr (Cum( 1 ) ,2 ) ,14 ) ) - Pwr(Sum(Cum( 1 ) ,14 ) ,2 ) )

If I specify four digits to the right of the decimal point in Bob Jagow's scan (b:8:4), the values are exactly the same. Exactly. Bob's formula is an exact translation, believe it or not. Try it, for example, with BNGO, with the Metastock formula with a 14-day slope.
Tonight, it's -0.0184. In QP2, with Bob's formula, it's identical. What's more, if you use the stock slope formula in WOW, the value is once again exactly the same.

Congratulations, Bob -- it's a great formula.

Here it is again, for those who missed it:

output = "slopebob.lst";

issuetype common;
Daystoload = 50; //needed for R2 bug!!!
integer i, S, Sx, Sxx;
float b, Sxy, Sy;
S := 14;
Sx := 0;
Sxx := 0;
Sxy := 0;
Sy := 0;
for i = 1 - S to 0 do
Sx := Sx + i;
Sy := Sy + close(i); //kills println wo d2ld
Sxx := Sxx + i*i;
Sxy := Sxy + i*close(i); //kills println wo d2ld
//Sxy := Sxy + i*close(0);
next i;
b := (S*Sxy - Sx*Sy)/(S*Sxx - Sx*Sx);
println symbol,",",close(0):8:2,",",b:8:4;

I marvel at the beauty of it, Bob.

Brooke



To: Paul Beattie who wrote (3054)1/15/1998 12:41:00 AM
From: Bob Jagow  Read Replies (2) | Respond to of 11149
 
Thanks, but it's hardly a breakthrough, Paul--think the LS equations were known :-)
Re checking, I tried adding a LS trendine [adjusting the start to the QP start] in MSWIN 6.0, but couldn't figure out how to read the values in the data window.

Exporting to 1-2-3 for the check was laborious but a couple matched to the 8:2 output values; need to redo scan. Note that the output from R2 is a little flaky in that need to export > 30 days to get 30.

One thing I find amazing is that R2 can so quicky churn thru the amount of code in [for example] Brooke's BPS. The short pause at the beginning of a scan hints that it is precompiling--but still amazing to me. With its speed, TSF-type calcs shouldn't pose a problem.

Gary: How about sticking a profiler in the scan IDE :-)

Bob
[edit] Happy to see Brooke confirmed that QP & MS agree--but realize that doesn't mean either one is right :-)

Bob


HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News