I need a scan to find stock where its daily MACD Histogram 7 15 9 two days ago is lower than yesterday. could you please help.

thx

Djoko

Assuming you are interested in an Exponential MACD Histogram 7,15,9:

XAVGC7.2 - XAVGC15.2 - XAVG(XAVGC7.2,9) + XAVG(XAVGC15.2,9) < XAVGC7.1 - XAVGC15.1 - XAVG(XAVGC7.1,9) + XAVG(XAVGC15.1,9)

Understanding MACD

Thank you Bruce.. it seems works well :)

As i am currenty subscribing to platinum service, how about finding stocks for minutes time frame. that have MACD Histogram 7 15 9 one minutes ago is lower than now. can you make the formula?

regards

Djoko

and how to find stocks which yesterday and 2 days ago has volume more than 100k ?

thank you

Djoko

A Condition Formula for an Exponential MACD Histogram 7,15,9 being lower 1-bar ago than currently could be written as:

XAVGC7.1 - XAVGC15.1 - XAVG(XAVGC7.1,9) + XAVG(XAVGC15.1,9) < XAVGC7 - XAVGC15 - XAVG(XAVGC7,9) + XAVG(XAVGC15,9)

A Condition Formula for volume being greater than 100k shares both 1-bar ago and 2-bars ago could be written as:

V1 > 100000 AND V2 > 100000

Or as:

MINV2.1 > 100000

When you create or edit a Condition Formula, there will be a Time Frame setting which can be adjusted. This would allow you to use a 1-minute time frame for the first Condition Formula and a Daily Time Frame for the second Condition Formula.

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

Hi again Bruce,

is there any way to write the pcf formula to find stocks where 2 DAYS AGO the stock have the HIGHEST OBV for 6 month period?

Thank you

Djoko

If you mean the 6 month period ending during the current day:

OBV1.2 = MAX(OBV,126)

If you menth tthe 6 month period ending two days ago:

OBV1.2 = MAX(OBV1.2,126)