Reply To: 365 day high has occurred in the last 50 days

Optuma Forums Optuma Scripting 365 day high has occurred in the last 50 days Reply To: 365 day high has occurred in the last 50 days

#65981
Karen
  • Topics: 21
  • Replies: 32
  • Posts: 53

Hi Darren,

The formula results are still not working the way it is intended to work.  Please see attached chart – if you scroll to the very start of the chart there are green stars when there are no red stars.  I basically am trying to achieve a green star where a red star has appeared provided it is within 80 days of the red star occurring (and this should apply for daily, weekly and monthly charts accordingly). I have tried all types of combinations of codes and if functions but cannot get it to work.

Can you please have a look at it and let me know what is wrong with the formula please.

Thanks and kind regards,
Karen

  • This reply was modified 1 week ago by Karen.

Pin It on Pinterest