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
- Topics: 22
- Replies: 35
- Posts: 57
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 9 months ago by
Karen.