Hello.

I'd like to expand on a calculation exampled yesterday:
CountTrue(O/O1>1.05,100)
which will give a count of the number of times the most recent open is 5% above the previous open over the last 100 bars.

I'm working with the same basic concept, except I'd like to calculate stats for:
percent of the time (as opposed to the count) over the last period that the open was X% or more above the previous open.

For example, I'd like to return a list of tickers that are calculated statistically:
opened 75% of the time higher than the previous open over the last 100 bars.

Does this make sense? Is it possible?

Thank you very much.

CountTrue(O/O1>1.05,100) > 75

Thanks StockGuy. The aribitrary "100 days" is convenient because it makes the above easy, however, I will be creating a bunch of these using various percents and periods. How is this calculated if, say, the period is 43 days?

Well you could do the math on how many bars need to return true, but you could also just write it like this.

CountTrue(O > 1.05 * O1, 43) > 75 * 43 / 100

I generally try to simplify things down to the simplest form in hopes that it will make the formula less resource intensive however.

CountTrue(O > 1.05 * O1, 43) > 32

Thanks very much, Bruce. The example provided does precisely what I'm looking for. Thanks again.

You're welcome.