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

Notification

Icon
Error
How to find a low of results - How to find a low of results
Options
Go to last post Go to first unread
Previous Topic Next Topic
Bulli  
#1 Posted : Tuesday, September 27, 2005 4:07:22 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
Hi, How can I find the lowest result value of the following: is there a formula that looks something like: writeval(Lowestvalue(mov(L,3,S),mov(L,4,S),mov(L,5,S))) Best regards, Bulli
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
StorkBite  
#2 Posted : Tuesday, September 27, 2005 5:02:37 PM(UTC)
StorkBite

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995

Was thanked: 14 time(s) in 10 post(s)
Hey Bulli- This is very similar to your previous thread here: http://forum.equis.com/viewtopic.php?t=2049and the index in the back of the User's Manual. Also, include with your post any code that you have already tried. Thanks! http://forum.equis.com/viewtopic.php?t=933
Back to top
Bulli  
#3 Posted : Tuesday, September 27, 2005 5:15:58 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
Sorry, but when I tried to do this using Valuewhen() I got an error saying only constant Data can be used, I thought it should not be the same. I will post code later as it is not in front of me. Best regards, Bulli
Back to top
Bulli  
#4 Posted : Wednesday, September 28, 2005 8:05:09 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
I got it solved, not the best coding, but what I could do, I am sharing it anyway! writeval(Min((Min(Min(Mov(L,5,E),Mov(L,6,E)),Min(Mov(L,7,E),Mov(L,8,E)))),(Min(Min(Mov(L,10,E),Mov(L,18,E)),Min(wilders(L,20),mov(L,25,S))))),0.2) For highest value just change Min to Max. as you can see, it is not similar to the other post, or at least I think so. I appreciate it if someone can do it in a better way. Thanks, Bulli
Back to top
Ridge Runner  
#5 Posted : Thursday, September 29, 2005 12:19:03 PM(UTC)
Ridge Runner

Rank: Newbie

Groups: Registered, Registered Users
Joined: 7/8/2005(UTC)
Posts: 3
Location: Seattle area
are you looking for LLV(Mov(L,OPT1,S),20) or just LLV(L,20) ?
Back to top
Bulli  
#6 Posted : Thursday, September 29, 2005 3:50:43 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
Hi Ridge Runner, I am looking for the lowest moving average on the last day (out of about 6 moving averages) this formula to be used in the calcualtion of an Expert Advisor, therefore no Opt, and also not LLV as this would give for one moving average and the value will not be of the last day but only the lowest one. To give you a clear picture, add six moving averages to a chart and see the value of each on the last day. (Which one is the lowest?) Thanks, Bulli
Back to top
Bulli  
#7 Posted : Thursday, September 29, 2005 3:59:59 PM(UTC)
Bulli

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 9/26/2005(UTC)
Posts: 185
Location: Brazil
This code was written by JOSE, as a reply to me in a different forum: ---8<----------------- { SMAs } ma1:=Mov(C,4,S); ma2:=Mov(C,5,S); ma3:=Mov(C,6,S); ma4:=Mov(C,7,S); ma5:=Mov(C,8,S); ma6:=Mov(C,9,S); ma7:=Mov(C,10,S); { Highest SMA on last bar } HiMa:=LastValue(Max(ma1,Max(ma2,Max(ma3,Max(ma4,Max(ma5,Max(ma6,ma7)) ))))); HiMa:= If(HiMa=LastValue(ma1),ma1, If(HiMa=LastValue(ma2),ma2, If(HiMa=LastValue(ma3),ma3, If(HiMa=LastValue(ma4),ma4, If(HiMa=LastValue(ma5),ma5, If(HiMa=LastValue(ma6),ma6, ma7)))))); { Lowest SMA on last bar } LoMa:=LastValue(Min(ma1,Min(ma2,Min(ma3,Min(ma4,Min(ma5,Min(ma6,ma7)) ))))); LoMa:= If(LoMa=LastValue(ma1),ma1, If(LoMa=LastValue(ma2),ma2, If(LoMa=LastValue(ma3),ma3, If(LoMa=LastValue(ma4),ma4, If(LoMa=LastValue(ma5),ma5, If(LoMa=LastValue(ma6),ma6, ma7)))))); { Plot on price chart } HiMa;LoMa ---8<----------------- jose '-) http://www.metastocktools.com Thanks Jose Bulli
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