Do we have any workaround to find all time high and all time low of a stock in our dataset? I have tried things like this recently, but different stocks have different historical timeframes.
HighVal(1255)-Close(0)
HighVal(2500,0,#High) will give you the ten-year high even if a stock has only been around for two years.
Max(HighVal(2500,0,#High),HighVal(2500,2000,#High)) will give you the eighteen-year high. That's as far back as you can go with this formula, I believe.
Substitute LowVal and #Low for lows.
1 Like
That is a great trick. Thanks Yuval I think that will work great to go further. Much appreciated