Can some one help me with the following formulas
1. explore stocks closing the day in the bottom 5% of the days range.
2. stocks making new 52 week highs for the first time. some stocks make highs and then keep making highs everyday. I need stocks that just made the high for the first time.
3. Stocks making new 52 week lows for the first time
I need three seperate formulas for the above. I would appreciate any help as I have no clue how to write any type of code.
1. explore stocks closing the day in the bottom 5% of the days range.
2. stocks making new 52 week highs for the first time. some stocks make highs and then keep making highs everyday. I need stocks that just made the high for the first time.
3. Stocks making new 52 week lows for the first time
I need three seperate formulas for the above. I would appreciate any help as I have no clue how to write any type of code.