henksaenen 5 posts msg #140161 - Ignore henksaenen |
12/17/2017 5:20:42 AM
Hello, I am trying to calculate the 'current price multiple' in a filter but I have no idea how to go about that. Any help would be greatly appreciated. If I can get this done then I can filter the tickers on the ones that have made the biggest moves.
The CPM = 52 week high price / 52 week low price
I am guessing I need to add a column for the high and low price and then add a column with the calculation but how or if it can even be done, I don't know.
Thanks in advance
Henk
|
mahkoh 1,065 posts msg #140163 - Ignore mahkoh modified |
12/17/2017 1:12:26 PM
|
henksaenen 5 posts msg #140164 - Ignore henksaenen |
12/17/2017 2:23:20 PM
Oh wow! Thanks a million Mahkoh!
|
glgene 616 posts msg #140166 - Ignore glgene |
12/17/2017 4:36:19 PM
Curious... what will this report get you?
Gene
|
henksaenen 5 posts msg #140195 - Ignore henksaenen |
12/18/2017 2:06:37 PM
Hi Gene this is just one part of the filter.
I am looking for stocks where macd's are showing upward momentum together with an upward EMA fan. The price multiple let's me sort the stocks that have made the biggest moves to the top of the list.
The assumption then is that those tickers could break out over their highs. The trend is more likely to continue basically.
|