AUM historical data

Optuma Forums Optuma Scripting AUM historical data

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #68671
    James
    • Topics: 20
    • Replies: 11
    • Posts: 31

    Hi, I would like to create an ETF watchlist that has AUM in a column and AUM 1 month prior as a column. When I use the offset function I am not getting the desired results. How do i account for that the last data update to AUM is 6/15/22 when today’s date is 6/30/22? The data is updated monthly but I am getting daily values up to the last update date?

    Thanks, Jamie

    #68685
    Darren
    • Topics: 70
    • Replies: 832
    • Posts: 902

    Hi Jamie,

    We’re looking at our AUM daily updates, but in the meantime if you use the following the monthly change should work (a monthly offset isn’t required as V1 is already monthly, so the value in square brackets can be used to look at the previous value of V1).

    For YTD, change the timeframe to year:

    Capture

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest