TickerInside

Every US ETF this server can answer for, with the date of the data and where the holdings come from: the issuers' own daily files (tickers), or SEC filings for the other US stock ETFs (tickers_sec_nport). Call it when you are not sure a fund is covered.

{
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

One US ETF: its holdings with weights, largest first, and its cost, assets, returns over one, three and five years, volatility, beta, worst fall and concentration. Every figure carries the date of the issuer file, SEC filing or prices it came from.

{
  "type": "object",
  "properties": {
    "ticker": {
      "type": "string",
      "description": "A US ETF ticker, for example VOO. Case does not matter."
    },
    "holdings": {
      "type": "integer",
      "minimum": 0,
      "maximum": 500,
      "default": 25,
      "description": "How many of the largest holdings to return. 0 for none."
    }
  },
  "required": [
    "ticker"
  ],
  "additionalProperties": false
}

Any two covered US ETFs: holdings overlap measured three ways (by weight, and the share of each fund held in common), the largest shared holdings, the correlation and covariance of weekly returns, and the cost, return and risk of each.

{
  "type": "object",
  "properties": {
    "a": {
      "type": "string",
      "description": "A US ETF ticker, for example VOO. Case does not matter."
    },
    "b": {
      "type": "string",
      "description": "The other US ETF ticker."
    }
  },
  "required": [
    "a",
    "b"
  ],
  "additionalProperties": false
}

Every pair in a list of 2 to 30 US ETFs, ranked by overlap by weight, to see which funds in a portfolio duplicate each other. Uncovered tickers are listed and skipped.

{
  "type": "object",
  "properties": {
    "tickers": {
      "type": "array",
      "minItems": 2,
      "maxItems": 30,
      "items": {
        "type": "string",
        "description": "A US ETF ticker, for example VOO. Case does not matter."
      },
      "description": "2 to 30 US ETF tickers."
    }
  },
  "required": [
    "tickers"
  ],
  "additionalProperties": false
}

Look through a list of US ETFs to the companies underneath: how much of each company the portfolio holds, in percent and in money when amounts are given, and which funds it comes through. Uncovered funds are listed and left out of the percentages.

{
  "type": "object",
  "properties": {
    "positions": {
      "type": "array",
      "minItems": 1,
      "maxItems": 60,
      "description": "The funds in the portfolio. Amounts are optional; with none, every fund counts equally.",
      "items": {
        "type": "object",
        "required": [
          "ticker"
        ],
        "additionalProperties": false,
        "properties": {
          "ticker": {
            "type": "string",
            "description": "A US ETF ticker, for example VOO. Case does not matter."
          },
          "amount": {
            "type": "number",
            "exclusiveMinimum": 0,
            "description": "What this line is worth, in one currency for all lines."
          }
        }
      }
    },
    "currency": {
      "type": "string",
      "description": "The currency of the amounts, for example USD. Echoed back; nothing is converted."
    },
    "top": {
      "type": "integer",
      "minimum": 1,
      "maximum": 200,
      "default": 25,
      "description": "How many companies to return."
    }
  },
  "required": [
    "positions"
  ],
  "additionalProperties": false
}

For a list of US ETFs: portfolio volatility, each position's share of the risk (Euler decomposition, summing to 100), the diversification ratio, and the correlation and covariance matrices of weekly returns over up to three years.

{
  "type": "object",
  "properties": {
    "positions": {
      "type": "array",
      "minItems": 1,
      "maxItems": 60,
      "description": "The funds in the portfolio. Amounts are optional; with none, every fund counts equally.",
      "items": {
        "type": "object",
        "required": [
          "ticker"
        ],
        "additionalProperties": false,
        "properties": {
          "ticker": {
            "type": "string",
            "description": "A US ETF ticker, for example VOO. Case does not matter."
          },
          "amount": {
            "type": "number",
            "exclusiveMinimum": 0,
            "description": "What this line is worth, in one currency for all lines."
          }
        }
      }
    },
    "currency": {
      "type": "string",
      "description": "The currency of the amounts, for example USD. Echoed back; nothing is converted."
    }
  },
  "required": [
    "positions"
  ],
  "additionalProperties": false
}

For one stock, the covered US ETFs that hold it and the weight in each, heaviest first, with each fund's holdings date and whether it comes from the issuer's daily file or an SEC filing. Returns the largest holders and the total count.

{
  "type": "object",
  "properties": {
    "ticker": {
      "type": "string",
      "description": "A stock ticker as issuer files write it, for example NVDA."
    },
    "top": {
      "type": "integer",
      "minimum": 1,
      "maximum": 200,
      "default": 50,
      "description": "How many funds to return, heaviest first."
    }
  },
  "required": [
    "ticker"
  ],
  "additionalProperties": false
}

Two US stocks with three years of prices: market cap, valuation, returns, worst fall, volatility, beta, the correlation of weekly returns, and the covered US ETFs holding both. A fund ticker works on one side and returns whether the fund holds the stock, at what weight and rank. For two ETFs use compare_funds.

{
  "type": "object",
  "properties": {
    "a": {
      "type": "string",
      "description": "A US stock ticker, for example NVDA. An ETF ticker also works."
    },
    "b": {
      "type": "string",
      "description": "The other ticker."
    }
  },
  "required": [
    "a",
    "b"
  ],
  "additionalProperties": false
}