I played with the + or - 5 setting on the NAMO and found the results were pretty sensitive to that. Maximum effect observed at 7.88...
TC, the other parameter I want to investigate is the number of days you look back to determine the Max or Min, and to be able to change that within a formula. I think it may be some combination of the ADDRESS and/or OFFSET functions, but those are very cryptic to figure out how to use. Basically, I want to vary the number of days of look back as a user input and have the logic statement for the NAMO use that correctly.
Kind regards, -CAPT J
"What would you attempt to do if you knew you could not fail?"