Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/7/2005(UTC) Posts: 1,346
|
hey aljnoobi.... jose would likely be your best bet.... but until then here is something we worked on sometime back.... eventually coded most all the conditions but in a haphazard fashion.... jose would have cleaner code....
we later coded up to day 19 using wabbits much shorter code suggestion.... the explorations are easy enough, just place the desired number day codes in a column.... v10 helps in that area........h
as an example, this locates potential buys on day 9's or greater.....
a:=(C < Ref(C,-4) AND Ref(C,-1) < Ref(C,-5) AND Ref(C,-2) < Ref(C,-6) AND Ref(C,-3)<Ref(C,-7)AND Ref(C,-4) < Ref(C,-8) AND Ref(C,-5) < Ref(C,-9) AND Ref(C,-6) < Ref(C,-10) AND Ref(C,-7)<Ref(C,-11) AND Ref(C,-8) < Ref(C,-12) );
aa:=(C < Ref(C,-4) AND Ref(C,-1) < Ref(C,-5) AND Ref(C,-2) < Ref(C,-6) AND Ref(C,-3)<Ref(C,-7)AND Ref(C,-4) < Ref(C,-8) AND Ref(C,-5) < Ref(C,-9) AND Ref(C,-6) < Ref(C,-10) AND Ref(C,-7)<Ref(C,-11) AND a<>1 );
aaa:=(C < Ref(C,-4) AND Ref(C,-1) < Ref(C,-5) AND Ref(C,-2) < Ref(C,-6) AND Ref(C,-3)<Ref(C,-7)AND Ref(C,-4) < Ref(C,-8) AND Ref(C,-5) < Ref(C,-9) AND Ref(C,-6) < Ref(C,-10) AND aa<>1 );
aaaa:=(C < Ref(C,-4) AND Ref(C,-1) < Ref(C,-5) AND Ref(C,-2) < Ref(C,-6) AND Ref(C,-3)<Ref(C,-7)AND Ref(C,-4) < Ref(C,-8) AND Ref(C,-5) < Ref(C,-9) ) AND aaa<>1;
BarsSince(a)<BarsSince(aaaa) AND a<>0
|