Hi, @annemarie.otto and @aramyan.h ,

Firstly, I have some comments on the answer @aramyan.h provided. It is the historical NAV (price) of the fund, not the return. You can derive the return from NAV, but that is just the price return not total return. I guess @annemarie.otto wanted total return of the funds that includes distribution reinvestment and also events like fund unit merge and split. But if price return is fine for the purpose, then yes, that @aramyan.h 's solution is a good one.

About the historical data for fund performances (total return), @annemarie.otto can you check with if your organisation have access to RDP Funds API? Like Lipper for Investment Management, it also can provide historical returns (daily).

If there is only a short list of funds you need the historical return time-series data, then you may want to try manually to get it fund by fund from the Eikon/Workspace platform. i.e., get the fund page and then go to "Price & Charts" --> "Rolling Performance". Once the chart show the correct data based on your chart configuration, you can just click the "Excel" icon at top right of the page to export to Excel file.

Hi @annemarie.otto,

If I understood your question correctly, you can consider using get_history function from RD Libraries for Python. See an example below:

import refinitiv.data as rd

rd.open_session()

rd.get_history("LP40187458", fields = ["NAVALUE"], start = '2020-01-01', end = '2024-03-15')

You can search for other fields in Data Item Broswer by typing DIB in the search box of Workspace/Eikon.

Hope this helps.

Best regards,

Haykaz

Hi @bob.lee ,

thank you for your reply! In fact, I guess I don't have access to RDP Funds API.

To conclude I have two options:

1. Calculating the return with the NAVs -> But it's no real return since capital gains and dividends are not included, right? So I guess it's not such a good measure for my purpose.

2. Taking the Rolling Performance. But is it really the "normal" monthly total return? I worry that it's some return measured from the beginning of each year or so? I really need the "normal" total return since I want to insert it in some regression equations (for example CAPM, 4-factor model, ...).

Concerning the Rolling Performance:

I tried to obtain it a)via your suggested way ("Price & Charts" -> "Rolling Performance" -> Export to Excel) and b)via Python. However, there were different results even though it was for the same fund. Do you maybe know what's the problem?

Hello @annemarie.otto ,

1. I agree with you that price only return is not ideal for your research task. In theory, you can also get the dividend (not sure about capital gain) data and derive your “total return”, assuming no other events like unit merge or split happened to your funds. But this is a much time-consuming task.
2. The monthly return should be the standard return (in %) for month-end to month-end period. E.g., the return with value 5.969459 as of 2024-02-29 should be the return for the period from 2024-01-31 to 2024-02-29. I checked that using Lipper for Investment Management (Lipper IM), the value matches.

I am not sure how you get the other values (via Python?). If so, you can you share the Python code?

Hello again @annemarie.otto,

I tried to guess where is your "wrong" values (from the 2nd screenshot you show) came from. It seems these are returns of the same fund but in EUR. So, the differences is due to the different currency. The sample fund you are using is denominated in USD.

@annemarie.otto , So, as your Python code shows, you already have the solution, i.e., getting the rolling performance (total return) of funds using Python from Eikon/Workspace. Thanks for showing that code as I learned something new as I was not aware the "TR.FundRollingPerformance" function exists.