Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
15 6 8 12

How to get historical AUM, performance fee, bloomberg ticker, UCITS and countries of sale of any fund?

I'm not be able to find the "TR." formula to get historical AUM, performance fee, bloomberg ticker, UCITS status and countries of sale of a fund.

eikon-data-api#contentpython api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
1.6k 3 2 3

@BlackBird ,

For Eikon data API, there are relatively limited contents for funds. For AUM, you can use the TR.FundTotalNetAssets and you can specify the start date and end date to get historical data. For countries registered for sale, you can use the TR.FundRegisteredCountry to check, but this function seems require user to input the countries code that user want to check and it returns a the country code that the fund is registered for sale in that country.

For Performance fees, UCITS flag, they are available in RDP Funds API. RDP Funds API also got the AUM, registered for sale countries and most cross-reference codes like ISIN, CUSIP, etc. However, I do not think Lipper carries Blomberg codes.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1. Not able to retreive historical FundTotalNetAssets with dates. Shows NA in the output with the below code.

column_fields = ["TR.FundTotalNetAssets"]
refinitiv_data, err = ek.get_data(["SPY"],
    fields=column_fields,
    parameters={
        "SDate": "2000-01-01",
        "EDate": "2023-04-31",
    },
)

2. TR.FundRegisteredCountry works fine

3. I couldn't fund performance fee, UCITS flag in RDP Funds API. Can you please give an example using RDP Funds API?

@BlackBird , Can you try change your end date to '2023-04-30'? For RDP Funds API, thanks to @marcin.bunkowski01 , now I think you got all the answers.

Hi @BlackBird,
for UCITS flag:

request_definition = rd.delivery.endpoint_request.Definition(
                method=rd.delivery.endpoint_request.RequestMethod.POST,
                url='https://api.refinitiv.com/data/funds/v1/assets',
                body_parameters={
                    "properties": [
                        {"name": 'Attributes',
                        "filter" : 'FGUCITS'}],
                    "universe": {
                        "symbols": ['HSXJ.L']}})
response = request_definition.get_data()
response.data.raw

performance fee:

request_definition = rd.delivery.endpoint_request.Definition(
                method=rd.delivery.endpoint_request.RequestMethod.POST,
                url='https://api.refinitiv.com/data/funds/v1/assets',
                body_parameters={
                    "properties": [
                        {"name": 'Fees',
                        "filter" : 'PERFORMANCEFEE%'}],
                    "universe": {
                        "symbols": ['LP65097408']}})
response = request_definition.get_data()
response.data.raw

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.