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 : Saturday, July 19, 2014 12:09:17 PM(UTC)
FormulaPrimer

Rank: Advanced Member

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

I think is was originally done by henry1224.
I think it needs to be little optimized for current markets.
Any suggestions?


Code:
{PP+ Ugly Double Bottom Sell Signal}
HP1:=ExtFml("PowerPivots.NthPivotPrice",1,0,1);HP2:=ExtFml("PowerPivots.NthPivotPrice",1,1,1);LP1:=ExtFml("PowerPivots.NthPivotPrice",-1,0,1);LP2:=ExtFml("PowerPivots.NthPivotPrice",-1,1,1);LP3:=ExtFml("PowerPivots.NthPivotPrice",-1,2,1);BHP1:=ExtFml("PowerPivots.BarsSinceNthPivot",1,0);BHP2:=ExtFml("PowerPivots.BarsSinceNthPivot",1,1);BLP1:=ExtFml("PowerPivots.BarsSinceNthPivot",-1,0);BLP2:=ExtFml("PowerPivots.BarsSinceNthPivot",-1,1);BLP3:=ExtFml("PowerPivots.BarsSinceNthPivot",-1,2);LP:=Min(If(BHP2>BLP1 AND BLP1>BHP1,LP1,1E6),Min(If(BHP2>BLP2 AND BLP2>BHP1,LP2,1E6),If(BHP2>BLP3 AND BLP3 >BHP1,LP3,1E6)));((HP2/HP1>1.05) AND (HP2/HP1<1.15) AND C<LP AND Ref(C,-1)>=LP AND LP<1E6)
henry1224  
#2 Posted : Sunday, July 20, 2014 12:46:47 PM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
Dear FP, No I did not post that formula!
No ugly,Pretty nor any sort of Double bottom formulas! just because the code uses Power Pivots Plus dll's , don't assume that I wrote them.
I have no affiliation with Equis nor the developer of this add-on. I bought the add-on when it first came onto the market and started experimenting with the code to see what developed, as for the code that is posted above, there is a missing variable 1E6 ? what ever that stands for! Another issue could be in the range of (HP2/HP1>1.05) AND (HP2/HP1<1.15) Maybe 5% to 15% is too great?

What ever, You first have to define what 1E6 stands for!
FormulaPrimer  
#3 Posted : Sunday, July 20, 2014 1:29:47 PM(UTC)
FormulaPrimer

Rank: Advanced Member

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

Thanks henry1224

I should have noticed that. Usually MS notifies if a variables are missing.
I'll work on variables. I appreciate the reply.

Regards,
FP

Users browsing this topic
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.