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