8/01/2014

How I get the Market Monitor Numbers


I am often asked by readers about how the numbers in Stockbee Market Monitor are calculated.

I use the old version of Telechart to run MM scans . If you are telechart users you will understand what these scans try to find. The following scans are for both versions.

Common Stock is the list used for all scans as it eliminates ETF.

Telechart Version 7 Scans

Universe: US common stocks

Number of Stocks up 4% plus today

( 100 * (C ­ C1) / C1) >= 4 AND V >= 1000 AND V > V1


Number of Stocks down 4% plus today

( 100 * (C ­ C1) / C1) <= ( ­-4) AND V >= 1000 AND V > V1


Number of Stock up 25% plus in a quarter

100 * ((C + .01) ­ ( MINC65 + .01)) / (MINC65 + .01) >= 25 and AVGC20 * AVGV20 >= 2500


Number of Stock down 25% plus in a quarter

(100 * ((C + .01) ­ (MAXC65 + .01)) / (MAXC65 + .01)) <= ( ­ 25) and AVGC20 * AVGV20 >= 2500


Number of stocks up 25% plus in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 2500 AND 100 * (C ­ C20) / C20 >= 25


Number of stocks down 25% plus in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 2500 AND 100 * (C ­ C20) / C20 <= ( ­ 25)


Number of stock up 50% or more in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 2500 AND 100 * (C ­ C20) / C20 >= 50


Number of stock down 50% or more in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 2500 AND 100 * (C ­ C20) / C20 <= ( ­ 50)


Stock up 50% or more in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 2500 AND 100 * (C ­ C20) / C20 >= 50


Number of stocks up 13% plus in 34 days

100 * ((C + .01) ­ ( MINC34 + .01)) / (MINC34 + .01) >= 13 and (AVGC20 * AVGV20) >= 2500


Number of stocks down  13% plus in 34 days

(100 * ((C + .01) ­ (MAXC34 + .01)) / (MAXC34 + .01)) <= ( ­ 13) and (AVGC20 * AVGV20) >= 2500


Scans for Telechart Version 12.4

Universe: US Common Stocks


Number of Stocks up 4% plus today

( 100 * (C ­ C1) / C1) >= 4 AND V >= 100000 AND V > V1


Number of Stocks down 4% plus today

( 100 * (C ­ C1) / C1) <= ( ­ 4) AND V >= 100000 AND V > V1


Number of Stock up 25% plus in a quarter

100 * ((C + .01) ­ ( MINC65 + .01)) / (MINC65 + .01) >= 25 and AVGC20 * AVGV20 >= 250000


Number of Stock down 25% plus in a quarter

(100 * ((C + .01) ­ (MAXC65 + .01)) / (MAXC65 + .01)) <= ( ­ 25) and AVGC20 * AVGV20 >= 250000


Number of stocks up 25% plus in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 250000 AND 100 * (C ­ C20) / C20 >= 25


Number of stocks down 25% plus in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 250000 AND 100 * (C ­ C20) / C20 <= ( ­ 25)


Number of stock up 50% or more in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 250000 AND 100 * (C ­ C20) / C20 >= 50


Number of stock down 50% or more in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 250000 AND 100 * (C ­ C20) / C20 <= ( ­ 50)


Stock up 50% or more in a month

C20 >= 5 AND (AVGC20 * AVGV20) >= 250000 AND 100 * (C ­ C20) / C20 >= 50


Number of stocks up 13% plus in 34 days

100 * ((C + .01) ­ ( MINC34 + .01)) / (MINC34 + .01) >= 13 and (AVGC20 * AVGV20) >= 250000


Number of stocks down  13% plus in 34 days

(100 * ((C + .01) ­ (MAXC34 + .01)) / (MAXC34 + .01)) <= ( ­ 13) and (AVGC20 * AVGV20) >= 250000

All these scan measure breadth on of different magnitude and duration. As a general observation extreme breadth happens near turns.

If you want to use market timing tools like these spend some time understanding the concept of market breadth.

5 comments:

Unknown said...

Hi Sir,

I'm using TC20000 version 20.0 and I'¸m having issue with the formula in this list of scans you share. Exemple: Number of stock up 25% plus in quarter.
100 * ((C + .01) ­ ( MINC65 + .01)) / (MINC65 + .01) >= 25 and AVGC20 * AVGV20 >= 250000
only thing I changed is .01 for 1/100 beacause I'm from Canada.

Thanks

Pradeep Bonde said...

https://www.tc2000.com/~cnoBOw

use above layout.

Trader_Sherpa said...

Hi Pradeep,
I have this chart layout https://www.tc2000.com/~cnoBOw. I have copied the same formulas but when I scan I don't see stocks in my scan but in yours, I see a few stocks. Do you know what might be causing it?
Thanks

Pradeep Bonde said...

Your default list may not be set to US stocks

JA said...

Hi Pradeep, how do you get the watchlists background to change color (green/red)? this is great when glancing quickly. Much appreciated!