Can anyone help to create the follwoing  Formula for improved On Balance Volume

Cumulative total of (volume * ((high-open) / (high-low)))  - Cumulative total of (volume * ((open-low) /  (high-low)))

I have the follwoing

Cum(V*((H-O)/(H-L)))-Cum(V*((O-L)/(H-L)))

The only thing tha I do not know how to do is the cumulativea

Thanks

The only way to make the formula cumulative in TC2000 is to use it in a Custom PCF Cumulative Indicator on the chart.

so cumulative indicators can only be made using custom PCF Cumulative?

Thanks for the formula

You're welcome. Yes, cumulative indicators can only be made in TC2000 currently using the Custom PCF Cumulative indicator. There is no syntax available for creating a stand alone cumulative formula.

The problem with that is that when I scan I have to set conditions for each single variable,

let say that I want to scan for a cumulative volume indicator of todays bar with ten days ago and then today with 20 bars ago and so on, I will have to create many conditions and then scan each of them.

I can use OBV on PCF formula but I think that OBV is not the best, I will be happy to use William A/D but there is not abbrevation for PCF like there is for OBV

Do you have any idea on how to solve this problem

The problem can be a bit worse than you think. It is not always possible to get around the situation by creating multilpe Custom PCF Cumulative indicators and creating conditions for each one.

For example, when I first glanced at your original request, I thought it was the ratio of two cumulative calculations instead of the difference between two cumulative calculations. I could write the difference as a Custom PCF Cumulative indicator, but there would have been no way to create the ratio instead.

I do not have a workaround. Thank you for your suggestion.

I have trying to do it with the follwoing formula

obv > obv1 and obv > obv2 and obv > obv3 and when I scan does not return anything

I also have tried obv > obv.1 and obv > obv.2 and obv > obv.3

But is not returning any results when I scan for stocks

I think your formulas were meant to be:

OBV > MAX(OBV1.1, 3)

So OBV > MAX(OBV1.1, 3) is the formula for todays OBV higher than obv during the previous 3 days

so for 5 or any other lookback perior would it be OBV > MAX(OBV1.1, 5) ?

Yes, you can change just the 3 to a 5 to change the number of bars to which the current value is compared. You could also write the three period version as follows, but using the MAX() function makes it shorter.

OBV > OBV1.1 AND OBV > OBV1.2 AND OBV > OBV1.3

thanks bruce

You're welcome.