Good Day!

Is there a way to deploy a PCF for a scan condition or column monitoring in order to count cum(upticks / downticks) for each day, week, etc...?

Thanks! 

You can count the number of times a price went up or down for a bar in a cumulative fashion since the start of the chart, but it will not reset the count at the beginning of each day or week.

The count will use the bars on the chart as "ticks", so a daily time frame would count the number of up or down days, not ticks. You can set the time frame of the chart to Tick if you have the real time data, but it is not usually going to have enough data available for an entire day, let alone a full week.

Counting up ticks using a Custom PCF Cumulative Indicator would use the following formulas.

Counting down ticks would use the following formulas.

And running a cumulative total of up and down ticks would use the following formulas.

But again, keep in mind that this is going to use the bars on the chart as "ticks", so this would be up or down minutes on a 1-minute chart and only reflect ticks when using the Tick time frame.

I know that having tick capability on your history servers are quite co$tly, but at least you could do it In-House as a recomendation..?

If you could make this calculation from your own at server side and give it to us mortal users as an additional field like the cumulative total volume, it will make the already great screener a more robust breath analysis tool like no one does today on the market!   If you have uptick & downtick count, you could easily as well multiply it by volume for each tick and calculate MoneyFlow Turnover! (Accumulation on ups, Distribution on downs)  -- Only costly Reuters gives this kind of information and even the retail version is quite costly and with NO SCREENER capabilites.

Thanks for your advice Bruce!

Thank you for your suggestion.