What's the Eikon formula (TR.) to get Bloomber ticker/id and address of any fund?
What's the Eikon formula (TR.) to get Bloomber ticker/id and address of any fund?
@BlackBird, I do not think the Eikon/Workspace API got a formula (TR.xxx) can provide the Bloomber ticker or "address" of funds. Hope someone may have better knowledge can help you on that.
For the "address", if you mean the fund company address, the RDP Funds API can provide that under the property: serviceProviders. Below is a sample result for a fund. As you can see, there are different type of companies associated with the fund and their information is included in that query response from the API.
{ "assets": [ { "id": "60000012", "serviceProviders": [ { "code": "PROMOTER", "type": { "id": "7536", "name": "Promoter" }, "values": [ { "name": "abrdn", "longName": "abrdn", "code": "GRGY", "addressLine1": "1900 Market Street, Suite 200", "addressLine4": "PA", "city": "Philadelphia", "postalCode": "19103", "country": "United States", "telephone": "215-405-5700", "webSite": "www.aberdeenstandard.com", "date": "1800-01-01" } ] }, { "code": "CUSTODIAN", "type": { "id": "394", "name": "Custodian" }, "values": [ { "name": "BNP Paribas Lux", "longName": "BNP Paribas SA (Luxembourg Branch)", "code": "MWWS", "addressLine1": "50, Avenue J.F. Kennedy", "city": "LUXEMBOURG", "postalCode": "2951", "country": "Luxembourg", "telephone": "35242421", "fax": "35242422579", "webSite": "http://www.bnpparibas.lu/en/", "date": "2022-11-16" } ] }, { "code": "SUB-ADVISOR", "type": { "id": "9450", "name": "Sub-Advisor" }, "values": [ { "name": "Abrdn Asia", "longName": "Abrdn Asia Ltd", "code": "ABA$", "addressLine1": "21 Church Street", "addressLine2": "#01-01 Capital Square", "postalCode": "049480", "country": "Singapore", "telephone": "6563952700", "webSite": "https://www.abrdn.com/en/singapore/investor", "date": "1800-01-01" } ] }, { "code": "ADMINISTRATOR", "type": { "id": "393", "name": "Administrator" }, "values": [ { "name": "BNP Paribas Lux", "longName": "BNP Paribas SA (Luxembourg Branch)", "code": "MWWS", "addressLine1": "50, Avenue J.F. Kennedy", "city": "LUXEMBOURG", "postalCode": "2951", "country": "Luxembourg", "telephone": "35242421", "fax": "35242422579", "webSite": "http://www.bnpparibas.lu/en/", "date": "2022-11-16" } ] }, { "code": "INVESTMENT_ADVISOR", "type": { "id": "392", "name": "Investment Advisor" }, "values": [ { "name": "abrdn Invstmnts", "longName": "abrdn Investments Ltd", "code": "JXFG", "addressLine1": "10 Queen's Terrace", "addressLine4": "UNITED KINGDOM-NA", "city": "ABERDEEN", "postalCode": "AB10 1XL", "country": "United Kingdom", "telephone": "2154055700", "date": "2012-11-23" } ] }, { "code": "FUND_MANAGEMENT_COMP", "type": { "id": "391", "name": "Fund Management Company" }, "values": [ { "name": "abrdn Investment", "longName": "abrdn Investments Luxembourg SA", "code": "YFWP", "addressLine1": "35A, avenue J-F Kennedy", "city": "LUXEMBOURG", "postalCode": "1855", "country": "Luxembourg", "telephone": "35226433000", "date": "1800-01-01" } ] } ] } ], "totalRecords": 1, "fromIndex": 0, "toIndex": 0, "pageNumber": 0 }