Counter for number of occurences..

Counter for number of occurences..

allan nathan
2014-08-19 12:55:28

Hi,
How would I go about coding a "counter" which sums up the number of occurences over X days?

Would it be a combination of the IFFstring and Sum function? Would it be SumIf??

i am trying to set up a signal if there are 4 or more distribution days for the last 20 days with increasing volume.Its a short sell signal.

distribution day is a day where the close is down .2% or more from previuos close on increasing volume

dist=volume>ref(volume,1)and perf(close,1) <-0.20;

baddist=Sumif(dist>4,20);

thanks,

Allan

Seeker
2014-08-19 20:37:18

baddist = sum(dist, 20) >= 4;

allan nathan
2014-08-20 07:26:30

thanks seeker!

Get more messages

No more messages

Back


Trading Items Number of Increases for each Month/Year Number of Listed Companies for several Stock Exchanges Base or Counter Currency Extensive Fundamental Data for U.S. Stocks Time-series Sum for the first Minutes/Hours of a Trading Day	How-to Lessons How to display the number of stocks per day for different RSI gro... How to optimize the number of positions in a trading system How to plot the number of stock tweets per day How to add future bars to plan for market scenarios How to get fundamental data for U.S. Stocks
Related Forum Threads Preventing re-entery for certain number of bars In-Sample and Out-Of-Sample Dates for Optimization Custom Multi-Dimensional Fitness Formula (CMDFF) for Optimizer Chart for 1m bars over a custom time range An example for Excel COM automation - Further joint development?	Blog Posts Create custom metrics for the statistical data analysis tool How to Backtest Your Trading System for Each Industry How to Select the Best Market Indicator for your Trading System How to get buy and sell orders for a portfolio based on a trading... Step by step on how to get free realtime/delayed data for stocks,...