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

Notification

Icon
Error

Options
Go to last post Go to first unread
Bullstock  
#1 Posted : Tuesday, January 22, 2008 1:01:52 AM(UTC)
Bullstock

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/28/2006(UTC)
Posts: 32

I wonder if we can code the above as in http://thepatternsite.com/123tc.html

Bullstock

johnl  
#2 Posted : Thursday, January 24, 2008 5:32:15 PM(UTC)
johnl

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
billtrudeau  
#3 Posted : Saturday, January 26, 2008 10:30:49 AM(UTC)
billtrudeau

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
Bullstock  
#4 Posted : Thursday, January 31, 2008 7:04:48 PM(UTC)
Bullstock

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.