Reply To: Watchlist day, week, month %age change

Optuma Forums Optuma Scripting Watchlist day, week, month %age change Reply To: Watchlist day, week, month %age change

#66837
Karen
  • Topics: 22
  • Replies: 35
  • Posts: 57

Hi Darren,

I can’t get the formula to work.  The formula below is trying to work out the difference between yesterday’s close and today’s close as a percentage.  Can you please let me know why it is not working.

(CLOSE(Day(PERIODAMOUNT=1), 0) – CLOSE(Day(PERIODAMOUNT=1), 1))/CLOSE(Day(PERIODAMOUNT=1), 1)

I would like to use a similar formula for the week and monthly formula. Please let me know what is wrong.

The formula CHANGE(INT_TYPE=Day)  CHANGE(INT_TYPE=Week)    CHANGE(INT_TYPE=Month)   is not working when I toggle between day week and month on the worklist ie it is not showing the correct day, week and month calcs in the relevant time frame. Please let me know.
Thanks and kind regards,
Karen

Pin It on Pinterest