why it this math doesn't work using the 2 period IFR? you would have zero every time you had two consecutive down moves, and 100 everytime you had two consecutive up moves, but looking at the platforms this is not the correct value.
You should really consider turning your arrays into tables and working from there. It’ll make your life a lot easier when creating a calculated column.
You averaged forward. Don't you wish to average backwards? Also, I think you're missing some parentheses in the RSI equation
14 periods so the average UP/DOWN can start to calculate at row 16! starting at row 17 means u had offset by 1 period. my OCD is screaming in agony
Can you please verify the RSI you calcuated
why it this math doesn't work using the 2 period IFR? you would have zero every time you had two consecutive down moves, and 100 everytime you had two consecutive up moves, but looking at the platforms this is not the correct value.
You should really consider turning your arrays into tables and working from there. It’ll make your life a lot easier when creating a calculated column.
Can we chat want to learn in detail from you plz