Hi Barry

There are a couple of ways you can do this. One is to create a column for increases and one for decreases. When the scan is finshed copy the results to Excel and sum the results (each TRUE should report a 1 and and each FALSE a 0). I assume you know how to code for checking today's CLOSE higher or lower than yesterday's CLOSE?

The other method is to use the Global Variable DLL (GV.DLL) to count advances and declines as the exploration proceeds. This method requires a single-security "reset" scan before each "count" scan but that's a small price to pay for eliminating Excel from the process. You can repeat the two-scan process on as many portfolios or folders as you want and literally read off advances and declines after each one set. I've written detailed instructions on the process in several MSTT newsletter articles.

At the heart of the process is the fact that a GV data array (used as an accumulator) need only be created once and from then on the accumulator can be read at the beginning of the column code and written with a new (updated) value at the end of the column code. This gets around the problem where a conventional variable cannot accumulate from one security to the next.

Roy

www.metastocktips.co.nz