API Changes : Recommendations

Owned by smrati smrati
Last updated: Jun 21, 2017
3 min read

Suggested changes to following two APIs

Get all holdings for a given CompositeTicker in the decreasing order of their weights.

LeverageRatio, Coupon, Face, NotionalValue, QuantityHeld, Weighting ---> data type will be float
MarketValueHeld, QuantityPerShare ------>  data type will be Integer
Request:
GET /api/v1.0/holdings?ticker=IVV&count=2&offset=10


Response:

{
  "data": {
    "CompositeName": "iShares Core S&P 500 ETF",
    "CompositeTicker": "IVV",
    "Date": "20170328",
    "ETFType": "US Equities",
    "LeverageRatio": null,
    "constituents": [
      {
        "BBGIDComposite": "BBG000BK6PH2",
        "BloombergSymbol": "",
        "CUSIP": "",
        "ConstituentName": "GENERAL ELECTRIC CO",
        "ConstituentTicker": "GE",
        "ConstituentType": "EQUI",
        "ContractExpiryDate": "",
        "Coupon": 2,
        "Currency": "",
        "Face": 1.5,
        "ISIN": "US3696041033",
        "ISOMarketIdentifierCode": "",
        "Identifier": "2380498",
        "IdentifierType": "SEDOL",
        "IndexProviderCode": "",
        "IndustryGroup": "",
        "Location": "US",
        "MarketValueHeld": 1293163378,
        "Maturity": "",
        "NotionalValue": 1293163377.86,
        "QuantityHeld": 43658453,
        "QuantityPerShare": null,
        "QuantityUnits": "",
        "RIC": "",
        "SEDOL": "2380498",
        "Weighting": 0.012742
      }
    ]
  },
  "message": null,
  "status": true
}


 

Get all CompositeTickers which contain a given ConstituentTicker as its Constituent (Reverse Lookup).

Weighting data type -→ float

Request:
GET /api/v1.0/constituent/in?ticker=z
 
 
Response:
{
    "data": [
        {
            "CompositeName": "Fidelity NASDAQ Composite Index Tracking Stock ETF",
            "CompositeTicker": "ONEQ",
            "ConstituentName": "Zillow Group Inc",
            "ETFType": "US Equities",
            "Location": "US",
            "Sponsor": "Fidelity",
            "Weighting": 0.0004
        },
        {
            "CompositeName": "Fidelity MSCI Information Technology Index ETF",
            "CompositeTicker": "FTEC",
            "ConstituentName": "Zillow Group Inc",
            "ETFType": "US Equities",
            "Location": "US",
            "Sponsor": "Fidelity",
            "Weighting": 0.0007
        }
    ],
    "message": null,
    "status": true
}