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

Notification

Icon
Error

Options
Go to last post Go to first unread
csbro  
#1 Posted : Friday, May 24, 2013 11:11:48 AM(UTC)
csbro

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 12/7/2006(UTC)
Posts: 35

Is this exploration possible?

Today’s High minus Low is greater than the (High minus Low of previous 250 periods).

AND

Yesterday’s High minus Low is greater than the (High minus Low of previous 250 periods).

csbro

csbro  
#2 Posted : Friday, May 24, 2013 3:25:33 PM(UTC)
csbro

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 12/7/2006(UTC)
Posts: 35

Re-statement: Is this exploration possible?

Today’s High minus today's Low is a greater difference than the difference of the High minus Low of any of the other individual previous 250 periods).

csbro

mstt  
#3 Posted : Saturday, May 25, 2013 1:44:45 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
Hi csbro

H – L > Ref(H – L ,- 250) doesn't do what you want but I'm sure the following line will.

H-L > Ref(HHV(H-L,250), -1);

Roy



csbro  
#4 Posted : Monday, May 27, 2013 8:43:52 AM(UTC)
csbro

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 12/7/2006(UTC)
Posts: 35

Hi Roy,

Thanks for the response. Unfortunately each variance of the various formulas returned the same error. I'm assuming the H-L is the problem.

H-L > Ref(HHV(H-L,250), -1); Error in col F:invalid time period (zero or negative) passed to HHV() function.

H-L > HHV (Ref (H-L,250), -1) Error in col F:invalid time period (zero or negative) passed to HHV() function.

H-L > HHV (Ref (H-L,-250), 1) Error in col F: invalid time period (zero or negative) passed to HHV() function.

H-L > HHV (Ref ((H-L),-250), 1) Error in col F: invalid time period (zero or negative) passed to HHV() function

I switched the 1st, with the 2nd, 3rd, & 4th based on the Formula Primer HHV() set up. I tried more variances but finally, after receiving the same error on all, wore out.

csbro

henry1224  
#5 Posted : Monday, May 27, 2013 2:52:34 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)
How many bars do you load in your exploration?

As for your exploration , what difference does the range of today makes vs the range of a bar 1 year ago?
were there any stock splits during that time frame?
mstt  
#6 Posted : Monday, May 27, 2013 2:57:37 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
Hi csbro

The problem is not with the code but I'm guessing that you have the Explorer set to load less than 250+ records. Try setting it to 260 records. Even a Minimum Records setting should work fine, but nothing less than 250 will for this particular line of code.

When an exploration column fails for some reason it's a good idea to create a test indicator with the code. An indicator is usually much easier to troubleshoot than an exploration because of the ability to plot multiple signals across a multiple bars.

Roy

csbro  
#7 Posted : Monday, May 27, 2013 3:24:13 PM(UTC)
csbro

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 12/7/2006(UTC)
Posts: 35

Trying to create Bulkowski's "Pipes". I've loaded 4000 bars v.s. 250 - Currently using his High Tight Flag (@ Breakout) with good success.
csbro  
#8 Posted : Friday, May 31, 2013 7:24:37 AM(UTC)
csbro

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 12/7/2006(UTC)
Posts: 35

This is a weekly exploration. I'm trying to compare the true range of the last two weeks with the previous year on an week by week basis. If these last two weeks true range are greater than each of the previous 50 week periods (not 250 as stated) and they are on a correction trend, then there is a good chance that they will reverse. (88% per Bulkowsk's study)



Col A: Week1 ATR(1)>ATR(7)*1.5
Col B: Week2 Ref(ATR(1),-1)>ATR(8)*1.5
Col C: RevPoint If(L<LLV(Ref(L,-2),5), 1, 0)
Col D: Ref(L,-1)<=L+.25
Col E: Volume V> Mov(V, 25, E)
Col F: H-L > Ref(HHV(H-L,250), -1);

Filter enabled Yes
Periodicity Weekly
Records required 4000

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.