question

Upvotes
Accepted
30 8 10 14

How to get Bloomber ticker and address of any fund?

What's the Eikon formula (TR.) to get Bloomber ticker/id and address of any fund?

eikon-data-apirefinitiv-dataplatform-eikon#technology#contentformula-builder
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.8k 3 3 4

@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
}
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.

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.