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

#66775
Darren
  • Topics: 69
  • Replies: 737
  • Posts: 806

Hi Karen,

That wasn’t a workbook file so I was unable to open it. Note that if you change the timeframe of the watchlist to weekly it will load only weekly data (ie Monday’s open, Friday’s close, intraweek highs and lows).  If doing % changes it will therefore calculate from the closest Friday close which is probably the cause of the discrepency.

Pin It on Pinterest