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

Notification

Icon
Error

Options
Go to last post Go to first unread
FormulaPrimer  
#1 Posted : Monday, April 12, 2010 3:31:33 PM(UTC)
FormulaPrimer

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 8/12/2005(UTC)
Posts: 73

Everything running to fast !!! Want to slow everything down to a snail pace.... Want charts and templates to take all day to load... Then this indicator is for you. LOL. Barbecue your style !!! x:=If(C>Ref(C,-1),C,PREV); If(x>Ref(x,-1),PREV, If(x>Ref(x,-2),PREV, If(x>Ref(x,-3),PREV, If(x>Ref(x,-4),PREV, If(x>Ref(x,-5),PREV, If(x>Ref(x,-6),PREV, If(x>Ref(x,-7),PREV, If(x>Ref(x,-8),PREV, If(x>Ref(x,-9),PREV, If(x>Ref(x,-10),PREV, If(x>Ref(x,-11),PREV, If(x>Ref(x,-12),PREV, If(x>Ref(x,-13),PREV, If(x>Ref(x,-14),PREV, If(x>Ref(x,-15),PREV, x)))))))))))))));
johnl  
#2 Posted : Monday, April 12, 2010 7:15:49 PM(UTC)
johnl

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602

I think I will take your word on it.
v.trader  
#3 Posted : Monday, April 12, 2010 8:22:59 PM(UTC)
v.trader

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/26/2009(UTC)
Posts: 76
Location: Toronto, Canada

hah... not really.... my dual core eats it for 3 seconds.... Although you're using way too many PREVs, the PREV to be calculated is not as complicated... I have formulas that have to calculate only 2-3 PREVs, but the actual PREVs to be calculated are much more complex and they take 5 times more then the above formula.
wabbit  
#4 Posted : Tuesday, April 13, 2010 12:15:23 AM(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)
mstt  
#5 Posted : Tuesday, April 13, 2010 1:28:17 AM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
For those that didn't see the same post in the "equismetastock" Yahoo group today, this was my response.
In the event that you actually wanted to use this you could always write it as below to reduce the PREV count somewhat.
x:=If(C>Ref(C,-1),C,PREV);
If(x>Ref(LLV(x,15),-1),PREV,x);
If you're like me and not fond of PREV you could make some further changes to eliminate all PREVs.
a:=C>Ref(C,-1);
x:=If(a,C,ValueWhen(1,a,C));
b:=Ref(LLV(x,15),-1);
If(x>b,ValueWhen(1,x<=b,x),x);
ValueWhen() can be used to eliminate many of the PREV functions in the new formulas released with MS11. Unfortunately it doesn't work with the MS11 "adaptive" formulas but there are other ways to tackle most of those, as shown in the March 2010 issue of MSTT.
Roy
FormulaPrimer  
#6 Posted : Wednesday, April 14, 2010 1:34:35 PM(UTC)
FormulaPrimer

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 8/12/2005(UTC)
Posts: 73

I found in this indicator while I was clearing out my formula data base and found it amuzing... appreciate the link to where this came from so I can read in detail of the solutions.. Appreciate the link Wabbit and thanks for the help again Roy.
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.