logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Translating Metastock Formulas Into Other Languages - Translating Metastock Formulas Into Other Languages
Options
Go to last post Go to first unread
Previous Topic Next Topic
btconnolly  
#1 Posted : Tuesday, October 25, 2005 2:24:15 PM(UTC)
btconnolly

Rank: Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/25/2005(UTC)
Posts: 12
I am trying to translate a formula that includes the Swing Index (Wells-Wilder) and the Projection Oscillator (Mel Widner) that come standard on Metastock. Unfortunately there is no detail on how those formulas work in Metastock Help and they are not listed on www.meta-formula.com either. Can anyone provide a Metastock or Excel language interpretation of these indicators so I can convert my formula in to a more sophisticated back-testing system? Many thanks,
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
Patrick  
#2 Posted : Tuesday, October 25, 2005 2:27:48 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
I just did a lot of work on the Accumulation swing index ... My best / only advice is to get the book ... "New Concepts in technical trading systems" by J.Welles Wilder Patrick :mrgreen:
Back to top
Patrick  
#3 Posted : Tuesday, October 25, 2005 2:35:22 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
Since I have the book opened, here is the formula for the swing index :D [code:1:fcbaeb31f9] SI = 50[(c2-c1 + .5(c2-o2) + .25(c1-o1))/R] . K/L [/code:1:fcbaeb31f9] Where K is the largest of H2-C1 L2-C1 And L the value of a limit move in one direction. Patrick :mrgreen:
Back to top
Patrick  
#4 Posted : Tuesday, October 25, 2005 2:43:53 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
C2 is today's close C1 is yesterday's close R is the largest of [code:1:d6a6ba1ed1] (H2-C1) + .5(L2-O2) + .25(C1-O1) (L2-C1) + .5(H2-O2) + .25(C1-O1) (H2-L2) + .25(C1-O1) [/code:1:d6a6ba1ed1] Patrick :mrgreen
Back to top
wabbit  
#5 Posted : Tuesday, October 25, 2005 3:05:55 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
If I have interpreted what you have posted so far, this should be pretty close....? ---8<----------------------------- {Using Patrick's strange nomenclature?} C1:=Ref(C,-1); C2:=C; H1:=Ref(H,-1); H2:=H; L1:=Ref(L,-1); L2:=L; O1:=Ref(O,-1); O2:=O; R1:=(H2-C1)+.5*(L2-O2)+.25*(C1-O1); R2:=(L2-C1)+.5*(H2-O2)+.25*(C1-O1); R3:=(H2-L2)+.25*(C1-O1); R:=Max(Max(R1,R2),R3); K:=Max(H2-C1,L2-C1); {And LL the value of a limit move in one direction???} SI:=50*(((c2-c1) + 0.5*(c2-o2) + 0.25*(c1-o1))/R)*(K/LL); SI; ---8<------------------------------ WITH THE EXCEPTION of the LL variable??? Good luck in defining that in MS! :evil: But what is it supposed to show? Beats me so far! Guess I will have to wait for the next thrilling installment of, "Patrick's Messing With Our Minds!" wabbit :D
Back to top
Patrick  
#6 Posted : Tuesday, October 25, 2005 3:14:16 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
Thannks Wabbit :D Well after a few corrections we are at : LL:=Input("Limit Move",0,1000,5); C1:=Ref(C,-1); C2:=C; H1:=Ref(H,-1); H2:=H; L1:=Ref(L,-1); L2:=L; O1:=Ref(O,-1); O2:=O; R1:=(H2-C1)+.5*abs(L2-O2)+.25*(C1-O1); R2:=abs(L2-C1)+.5*(H2-O2)+.25*(C1-O1); R3:=(H2-L2)+.25*(C1-O1); R:=Max(Max(R1,R2),R3); K:=Max(H2-C1,Abs(L2-C1)); SI:=50*( ( (c2-c1) + 0.5*(c2-o2) + 0.25*(c1-o1) )/R)*(K/LL); SI;
Back to top
wabbit  
#7 Posted : Tuesday, October 25, 2005 3:19:02 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
That took you nine minutes to correct - getting slow! :lol: LL being a user input threw a spanner in my thought processes, but now it all seems as clear as mud! So, the question still remains, what does it do? wabbit :D
Back to top
Bulli  
#8 Posted : Tuesday, October 25, 2005 3:48:24 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
I do not know what this thing is supposed to do #-o , but I will tell one thing, it is giving some very interesting signals for Swing Trading! , it is worth investigating! :D Bulli :D
Back to top
Patrick  
#9 Posted : Tuesday, October 25, 2005 3:53:46 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
Hey guys ... :D It's nothing new, it is simply Wilders Swing Index indicator, we just made a custom version to help out Connely translating it into something else :) But I guess you could mess around with it a little ... :P Patrick :mrgreen:
Back to top
Bulli  
#10 Posted : Tuesday, October 25, 2005 4:01:22 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
Well, if it is the Swing index #-o , that is why it is giving interesting Swings! :lol: :lol: :lol: Bulli
Back to top
btconnolly  
#11 Posted : Tuesday, October 25, 2005 4:42:46 PM(UTC)
btconnolly

Rank: Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/25/2005(UTC)
Posts: 12
you guys are great. Thanks for the Swing Indicator breakdown. Any possibility for doing the same with the Projection Oscillator or is that pressing my luck??
Back to top
Patrick  
#12 Posted : Tuesday, October 25, 2005 4:46:45 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
Well like I said I was working on Wilders ASI system so I had all the info avail ... ;) But you should press your luck, that's what the forum is for :D I don't know what "Projection Oscillator (Mel Widner)" is ... Do you have any info on it? Is this in MetaStock? Patrick :mrgreen:
Back to top
btconnolly  
#13 Posted : Tuesday, October 25, 2005 6:38:42 PM(UTC)
btconnolly

Rank: Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/25/2005(UTC)
Posts: 12
Yes in Metastock the Projection Oscillator is ProjOsc(Regression Periods, Slowing Periods) - there is also a verbal explanation on what it is supposed to do. I found a math interpretation but I am not sure how to read it (I am neither a math guy nor a programmer but I am trying to make it easier for a programmer to understand for the translation) For instance, I don't understand what the X and b are referencing. Also, the [-x] appears slightly below and to the right of "high" and "low" in the formula below and I don't know what that means. HiSlope= slope of regression line of the high over n periods LowSlope = slope of regression line of the low over n periods HiBand = max over n periods of (high[-x] + b * X) LowBand= min over n periods of (low[-x] +b * X) PBoscillator = 100 x ((close – LowBand)/(Hiband - LowBand))
Back to top
Bulli  
#14 Posted : Tuesday, October 25, 2005 7:08:00 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
Slope of High {14 period regression line of High)} ((14 * (Sum( Cum(1) * HIGH, 14))) - (Sum( Cum(1),14) * ( Sum(HIGH, 14)))) / ((14 * Sum( Pwr( Cum(1), 2), 14)) - Pwr( Sum(Cum(1),14), 2)) Slope of Low {14 period regression line of Low} ((14 * (Sum( Cum(1) * LOW, 14))) - (Sum( Cum(1), 14) * ( Sum(LOW, 14)))) / ((14 * Sum( Pwr( Cum(1), 2), 14)) - Pwr( Sum(Cum(1),14), 2)) Upper Projection Band Max(HIGH, Max( Ref(HIGH,-1) + 1 * Fml("slope of high"), Max( Ref(HIGH,-2) + 2 * Fml("slope of high"), Max( Ref(HIGH,-3) + 3 * Fml("slope of high"), Max( Ref(HIGH,-4) + 4 * Fml("slope of high"), Max( Ref(HIGH,-5) + 5 * Fml("slope of high"), Max( Ref(HIGH,-6) + 6 * Fml("slope of high"), Max( Ref(HIGH,-7) + 7 * Fml("slope of high"), Max( Ref(HIGH,-8) + 8 * Fml("slope of high"), Max( Ref(HIGH,-9) + 9 * Fml("slope of high"), Max( Ref(HIGH,-10) + 10 * Fml("slope of high"), Max( Ref(HIGH,-11) + 11 * Fml("slope of high"), Max( Ref(HIGH,-12) + 12 * Fml("slope of high"), Ref(HIGH,-13) + 13 * Fml("slope of high")))))))))))))) Lower Projection Band Min(LOW, Min( Ref(LOW,-1) + 1 * Fml("slope of low"), Min( Ref(LOW,-2) + 2 * Fml("slope of low"), Min( Ref(LOW,-3) + 3 * Fml("slope of low"), Min( Ref(LOW,-4) + 4 * Fml("slope of low"), Min( Ref(LOW,-5) + 5 * Fml("slope of low"), Min( Ref(LOW,-6) + 6 * Fml("slope of low"), Min( Ref(LOW,-7) + 7 * Fml("slope of low"), Min( Ref(LOW,-8) + 8 * Fml("slope of low"), Min( Ref(LOW,-9) + 9 * Fml("slope of low"), Min( Ref(LOW,-10) + 10 * Fml("slope of low"), Min( Ref(LOW,-11) + 11 * Fml("slope of low"), Min( Ref(LOW,-12) + 12 * Fml("slope of low"), Ref(LOW,-13) + 13 * Fml("slope of low")))))))))))))) Projection Oscillator 100 * (CLOSE - Fml( "Lower Projection Band" )) / ( Fml( "Upper Projection Band" ) - Fml( "Lower Projection Band" )) This code I picked up on the net, the programmer is unkown, see if it helps. Bulli
Back to top
Bulli  
#15 Posted : Tuesday, October 25, 2005 7:11:42 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
this smily 8) is actually: 8 ) (Smily deos not show inside the code anymore, either someone fixed it :twisted: , or I was seeing things! :eek: ) Bulli
Back to top
Bulli  
#16 Posted : Sunday, October 30, 2005 3:07:52 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
Dear btconnolly, Referring to the private message you have sent to me asking about the link if there is one for the formula of this indicator: I preferred to post the link here in order to benefit others from the link http://trader.online.pl/...ojection_Oscillator.html The same site maybe is the best site there is for formulas. Best regards, Bulli :D
Back to top
Patrick  
#17 Posted : Sunday, October 30, 2005 4:12:26 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
Quote:
either someone fixed it Twisted
It was me :goofy:
Back to top
Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET