Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 9/28/2006(UTC) Posts: 32
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 11/7/2005(UTC) Posts: 602
|
Bullstock - you evil genius you.... Here is my first stab: I got 61% so I will have to play around with it. You can try playing with the 20 and see if you can get better results.
{-----------------------------------} p1:=Peak(2,C,20); p2:=Peak(1,C,20); t1:=Trough(2,C,20); t2:=Trough(1,C,20); d1:=TroughBars(1,C,20); d2:=PeakBars(1,C,20); d3:=TroughBars(2,C,20); d4:=PeakBars(2,C,20); {---------------------------------} c1:=If((d1<d2<d3<d4),1,0); c2:=If((t2>t1),1,0); c3:=If((p2<p1),1,0); c4:=If((t2<p2),1,0); {---------------------------------} e1:=Cross(C,p2)*c1*c2*c3*c4; e1
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users Joined: 4/27/2005(UTC) Posts: 132 Location: Manchester, NH
|
Seems like a perfect setup for PowerPivots
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 9/28/2006(UTC) Posts: 32
|
billtrudeau wrote:Seems like a perfect setup for PowerPivots
Can PowerPivots plot this pattern?
John,
I will try your code and see if I can go a bit further...
Bullstock
|
|
|
|
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.