Reply To: monthly returns

Optuma Forums Optuma Scripting monthly returns Reply To: monthly returns

#59297
DarrenDarren
  • Topics: 55
  • Replies: 461
  • Posts: 516

Hi Lorenzo,

You can use the MONTHNUM function for each month, so for June use the following which calculates the difference between the close of June (M1) and May (M2):

It’s the same process as for this example for quarterly performance.

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close