I’m writing this since I have a problem with the Refinitiv Workspace API regarding the Lipper RIC and the Lipper ID.
Let me explain step by step what I’m trying to do.
NOTE: I would like to use Python since is the easiest way to do this and I have a PDF file with all the codes - provided by a friend of mine - to perform this task (I’m currently using python through the jupiter notebook in ANACONDA).
1. The problem is that I’m trying to gather, from the refinitiv API, a list of fund based on their Lipper ID and, for each fund, his NAV, his TER and the relative date expressed in month/year. The problem is that, since I’m looking also for dead (liquidated) funds (due to survivorship bias problem), the Lipper RIC does not work (because the dead funds have a slightly different code) and I must use the Lipper ID (because, starting from the Lipper ID I can obtain the correct RIC code to, then download the NAV). Infact, furthermore, the NAV is the only data suitable for this search.
2. So, in the end, starting from the Lipper ID that I have attached i would like to have an excel file with (in the columns) Lipper ID, Name of the fund, his NAV, his TER and in the rows the relative date repeating for each single entries starting from january 2000 to january 2021 (20 years), monthly.
Is this possibile? Please contact me, I'm able to pay if needed
PS: As said I have a written guide to do all of this in python but I would like some help since I'm new to the program. I also have the list of Lipper ID to start the research