stephenmcmahon83 15 posts msg #150675 - Ignore stephenmcmahon83 |
2/5/2020 1:52:22 PM
For example, if you have list of stocks, and stock ABC just reached the highest close in the most recent 86 days, have an 86 show up in a column. If it is the lowest close in 86 days, have a -86 show up. If stock BCD just reached a 6 day highest close, have a 6 show up, and so on and so forth, in one column for your entire list of stocks.
I know it is possible to have a 1 show up if todays close is the highest close in the last xx days (your choice), but Id really prefer the actual numerical that identifes exactly how high or low todays closing price is.
Any assistance here would be greatly appreciated.
|