Perfect.  Thanks.  Without your help I wouldn't be able to tap into half the power of this software.

Thanks again,

Ty

I follow the part about the current version using incomplete bars and throwing off the comparison.  

I don't understand your recommended alternative though.  What is a PCF % True Indicator as opposed to a PCF Condition?

Thanks,

Ty

Hi Bruce,

Thanks for the formula.  However, there's a problem somewhere.  

I created a watchlist with 3 columns - The aroons5 indicator from a chart, and two pcf conditions - the first one you provide above on Jan 23 (that returns TRUE for valus 40, 60 or 80) and the 2nd one from today that should return TRUE for values 40, 60 or 80 when computed from 3 periods ago).  All columns are based on a 15 minute time frame.  All cols are on manual refresh.  

Every 15 minutes from 10 AM to 12:45 I refreshed the cols then took a screen shot of the watchlist checking to see that the checkmarks in the 3rd column (arroon-5 from 3 pds ago) matched the checkmarks in the 2nd column (current aroons-5) from 3 periods age. So col 3 at 10:45 should have the same symbols flagged as column 2 at 10:00.

Out of 9 comparions, 4 matched, 5 didn't.  The comparisons break down as follows:

10:45 - 10:00: doesn't match

11:00 - 10:15: matches

11:15 - 10:30: doesn't match

A screenshot of the results is here:

http://www.tyhallsted.com/Aroons3pdsAgoProblem.JPG

I looked at your formula and didn't see any inconsistencies in the changes.  You can probably duplicate these results more quickly with a 5 minute time frame.  I haven't tried that but don't see any reason why it wouldn't have similar results.

Ty

Hi Again.

The formula you provided above works fine.  As I understand it, it uses the most recent 6 days for it's computation.  I am interested as well, not just in days 0 to 6 but, as a separate formula, days 3 to 9.

I took a stab at modifying it but have missed something.  It doesn't return TRUE when it should. Can you correct or otherwise provide the needed formula?

Thanks,

Ty

Here's what I ended up with:

I ahven't had another 0 value appear in the symbols I'm watching so lets write that one off to operator error.

Thanks for your help,

Ty

I know it was forex but didn't screen shot it.  Next time one pops up I'll get it and let you know.

It MAY also have been  a refresh problem but I don't think so.  Pretty sure I got all the columns clicked.

Which brings me to two other feature requests:

1) a single refresh button in the watchlist to refresh all columns

2) an optional, "additional cost" level of service to prioritize refresh.  those with this service would be at the beginning of the refresh queue (assuming there is such a thing)

Thanks Bruce.

Works fine except also retusn TRUE for 0.

Thanks,

Ty

I want to create a condition that returns TRUE when a 5 period aroon oscillator value is either 40, 60 or 80.

I looked at the formulas in http://forums.worden.com/default.aspx?g=posts&t=53254 and am at a loss as to how to accomplish what I need.

I added the indicator to my watch list but would really like it as a condition.

Any help would be appreciated..

Thanks,

Ty

(if case number 9894 were implemented this would be a piece of cake...)

Another question re your comment on pivot point: "The Pivot Points are Daily and the formulas need to be Daily as well."

Based on your formula [PP=(H1 + L1 + C1) / 3], pivot is nothing but the avg of the prior period high, low and close.  So why is it only valid for a daily time frame.  If using a 1 minute or 1 hour chart, doesn't each bar have the H-L-C of that period?  If so, isn't the pivot computed from those values just as valid for that chart (at least as a reflection of the avg) as the daily pivot is for the daily?

Ty

Can I make another request?

For intra-day trading, it would be nice if we could specify the minute on which to base the refresh interval.  

A 15 minute refresh, could specify a minute from 0 through 14 where minute 0 would mean on the quarter hour, minute 1 would mean at 1, 16, 31 and 46 minutes ...etc

A 5 minute refres could specify a minute from 0 to 4.

Thanks,

Ty