How to bound a long custom formula in an interval as compact as possible?
e.g.:
Bound(VeryLongFormula, -1, 1)
How to bound a long custom formula in an interval as compact as possible?
e.g.:
Bound(VeryLongFormula, -1, 1)
There’s no way right now. I like your suggestion. THanks
That’s already a good sign Marco.
Maybe its crippled relatives:
Max(Formula, Value)
Min(Formula, Value)
Makes sense too.
btw, I realise that Max and Min are already used but I’m craving for them.
Dan
Min Max are not the same. They are cross sectional , they operate of multiple stocks… Should be FMax(“formula”)
Bound is meant to trim outliers for a single stock, like Bound ( PE , 3 , 40) so it would return:
NA if PE is NA
3 if PE is 0-3
40 if PE > 40
otherwise PE
That’s what I interpreted…
Yes, should work with anything. I have problems in special Tools.CustomFormula to bound them because is a single line.