AUM historical data

[James]

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

V1 = DATAFIELD(Month(PERIODAMOUNT=1), FEED=FD, FIELD=AssetsUnderManagement); V2 = OFFSET(Month(PERIODAMOUNT=1), V1, OFFSET=1); V1 - V2

1 2 3 4 5

V1 = DATAFIELD(Month(PERIODAMOUNT=1), FEED=FD, FIELD=AssetsUnderManagement); V2 = OFFSET(Month(PERIODAMOUNT=1), V1, OFFSET=1); V1 - V2

[Darren]

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).

V1 = DATAFIELD(Month(PERIODAMOUNT=1), FEED=FD, FIELD=AssetsUnderManagement); V1 - V1[1]

1 2 3 4

V1 = DATAFIELD(Month(PERIODAMOUNT=1), FEED=FD, FIELD=AssetsUnderManagement); V1 - V1[1]

For YTD, change the timeframe to year:

[Author]

Posts