Let us say i want to test 4 conditions simultaneously and assign each result for a different variable. How do i do that?
For example, I want to look at the close of the currentCandle and then compare it to the previous candle. If it is higher, assign the digit 1 to the variable currentCandle. If its lower, assign 2, if its same, assign 3.
When I use,
currentCandle = IIF(Close<(Close,-1) , 1 , "Im forced to give an else value here");
I dont want to give an else value.
I want it to say this
currentCandle = IIF(Close<(Close,-1), 1, "do nothing, just store the value of 1);
currentCandle = IIF(Close>(Close,-1), 2, "do nothing, just store the value of 2);
currentCandle = IIF(Close=(Close,-1), 3, "do nothing, just store the value of 3);
Thanks,
Pranav.