SO IF I WANTED TO FIND STOCKS TRADING BETWEEN 3 AND 5 TIMES EBITDA TO ENTERPRISE VALUE HOW WOULD I WRITE THE EQUATION THNAKS 

is their a way to make sure that when i look at a scan result and i move between looking athe the daily weekly and monthly chart that every time i look at the daily the sma line is 30 days and the weekly and monthly are 10 week sma and monthly is 10 month sma. Right now every time i move between the daily weekly and monthly i have to edit the days of the moving average

i was wondering in a column can i create a formula to get the ratio of ebitda to enterprise value for a stock. Also can i create easy scans with fundamental data

hi bruce the formula for wash and rinse below at 52 week low is not turning up allot of candidtes. What would formula be for stocks that have reached 52 week low but have now risen above that low by 3% on a daily basis over a two week period. Thanks 

(C > MAXH5.1 AND H5 < MINL251.6) OR (C > MAXH6.1 AND H6 < MINL251.7) OR (C > MAXH7.1 AND H7 < MINL251.8) OR (C > MAXH8.1 AND H8 < MINL251.9) OR (C > MAXH9.1 AND H9 < MINL251.10) OR (C > MAXH10.1 AND H10 < MINL251.11) OR (C > MAXH11.1 AND H11 < MINL251.12) OR (C > MAXH12.1 AND H12 < MINL251.13) OR (C > MAXH13.1 AND H13 < MINL251.14) OR (C > MAXH14.1 AND H14 < MINL251.15) OR (C > MAXH15.1 AND H15 < MINL251.16)

thank you so much for all your great work. I have another formula request 

stocks that are above 1 a share and below 20 that are making a double bottom and within 30% of 52 week low. The double bottom could be in a time period of 4 months .thank You 

only one stock came up for reversal for 52 week low 

hi i don't seem to be getting any stocks with the new low scan any thoughts thanks 

I have the formula below to find stocks that are running down vertically over 4 to 5 days. However, it's not picking up any stocks today just one. Look at Libbey corp ( lby) that's a vertical run down that did not show up. I am trying to create a formula for stocks down each day over 5 to 6 or more days where the price bar does not overlap much Also can you help ad a second formula for stocks that meet this condition and are down 5 to 10% over the 5 to 6 day period

C < O AND C < C1 AND 3 * H + L <= 4 * L1 AND C1 < O1 AND C1 < C2 AND 3 * H1 + L1 <= 4 * L2 AND C2 < O2 AND C2 < C3 AND 3 * H2 + L2 <= 4 * L3 AND C3 < O3 AND C3 < C4 AND 3 * H3 + L2 <= 4 * L4

I am trying to write a formula for the two following scenarios

1. find stocks that make new 52 week high then reverse and close at low of the week or close at the low over next two or three weeks 

2. find stocks that make new 52 week low then reverse and close at the high of the week or higher two to three weeks later 

hello, I want to add a condition for a stock that has a tight price movement over a 3 week period. I would like the scan to pick up stocks that have not moved more than 2 or 3 % over a 3 week period. Could you suggest a formula thanks