Reply To: Using the IF function to create a ranking value

Optuma Forums Optuma Scripting Using the IF function to create a ranking value Reply To: Using the IF function to create a ranking value

#67213
Louis
  • Topics: 23
  • Replies: 39
  • Posts: 62

Hi. I’d like to build on the idea of ranking using IF statements in a watchlist, if possible.

I have 2 IF statements. They both work. Each IF statement assigns a number if true and a different number if false. I want to use them together to save space on my watchlist. Below I am pasting 2 scripts, but in reality the IF statements are in different scripts/columns:

The idea is to have 1 column in the watchlist instead of 2 columns. I want to see 4 if it’s an all time closing high, 3 if its a 252 bar closing high, 2 if it’s a 63 bar closing high, and 1 if it’s a 21 bar closing high. I have tried many, may things and cannot seem to crack the code. Please let me know if I can accomplish this.

thank you,
Louis

Pin It on Pinterest