Hi Bruce

i need help with creating indicator formula what i m trying to do is create ratio indicator for overbought and oversold using as below

(C - O / H - L )*V

but what i want is to segregate all the positive days that close was above the open so add up all the buying pressure days and divide by absolute value of buying pressure to selling pressure, so output will be RATIO of buying pressure and i wish to see this for 13 period , 55 period and 89 periods,

2) and second question is there a way in TC2000 to get output as number when using fundamentals

(netprofit margin(post tax) + dividend)  / price to book

i can do this manually but it would be easy to get a watchlist column or something of that sort ,

If you can please help ?

Cheers

Dhiren

Bruce will be back next week.

Thanks Stock guy will wait for Bruce to respond !

Regards

There isn't a way to do the fundamentals part.

You can change both instances of 13 in the following Indicator Formula to use a different number of bars.

100 * SUM(IIF(H > L, IIF(C > O, (C - O) / (H - L) * V, 0), 0), 13) / SUM(IIF(H > L, ABS(C - O) / (H - L) * V, 0), 13)

Thanks Bruce

but i wanted to have the ratio go below zero as well to see the selling pressure days as per your formula it stays above zero only !

so what to tweak to get buying pressure days and divide by absolute value of buying pressure  plus (+) selling pressure, so output will be RATIO of buying pressure

thanks again

If you only count buying pressure days (I'm assuming that is when price ends above the open) for the numerator, then the value is always going to be positive.

You would need to count both buy and selling pressure days in the numerator in order for the value to go negative.

This will shorten the formula because we don't need to check for close to be above the open in the numerator.

100 * SUM(IIF(H > L, (C - O) / (H - L) * V, 0), 13) / SUM(IIF(H > L, ABS(C - O) / (H - L) * V, 0), 13)

The version given originally would run from 0 to 100 while this version would run from -100 to 100.

Bruce the second formula is better but im trying to make it more proper defined" where
when the buying and selling really translates into price movement"

so in the second formula is there a math idea to do close is greater then open in numerator and still get negative values  ??

because my idea is  " if you open on a low and close on high all the activity of the day was buying and if you open on high and close on a low all the activity of the day were selling like running a cumulative index, "

so in your second formula SUM(IIF(H > L, (C - O) / (H - L) * V, 0), 13)  where can we add close is above open to seggregate all positive days of buying in that 13 bar period to get overbought or oversold

Regards

If we segregate all close is above the open, we get the first formula.

Alrite Bruce then one last request on this topic can u pls give me pcf indicator formula for "moving up from negative side towards zero ? but not necessarily crossing zero and inverse for the same for moving down from positive side towards zero but not necessarily crossing below zero

100 * SUM(IIF(H > L, (C - O) / (H - L) * V, 0), 13) / SUM(IIF(H > L, ABS(C - O) / (H - L) * V, 0), 13)

thanks a lot for your help

Moving up from negative.

100 * SUM(IIF(H > L, (C - O) / (H - L) * V, 0), 13) / SUM(IIF(H > L, ABS(C - O) / (H - L) * V, 0), 13) > 100 * SUM(IIF(H1 > L1, (C1 - O1) / (H1 - L1) * V1, 0), 13) / SUM(IIF(H1 > L1, ABS(C1 - O1) / (H1 - L1) * V1, 0), 13) AND 100 * SUM(IIF(H1 > L1, (C1 - O1) / (H1 - L1) * V1, 0), 13) / SUM(IIF(H1 > L1, ABS(C1 - O1) / (H1 - L1) * V1, 0), 13) < 0

Moving down from positive.

100 * SUM(IIF(H > L, (C - O) / (H - L) * V, 0), 13) / SUM(IIF(H > L, ABS(C - O) / (H - L) * V, 0), 13) < 100 * SUM(IIF(H1 > L1, (C1 - O1) / (H1 - L1) * V1, 0), 13) / SUM(IIF(H1 > L1, ABS(C1 - O1) / (H1 - L1) * V1, 0), 13) AND 100 * SUM(IIF(H1 > L1, (C1 - O1) / (H1 - L1) * V1, 0), 13) / SUM(IIF(H1 > L1, ABS(C1 - O1) / (H1 - L1) * V1, 0), 13) > 0