ETFIQ

Find US listed ETFs by ticker, fund name, or a word from the name. Use this FIRST when the user names a fund loosely, then etf_profile with the ticker it returns. Refuses rather than returning a near match.

{
  "type": "object",
  "properties": {
    "query": {
      "type": "string"
    },
    "desk": {
      "type": "string"
    },
    "limit": {
      "type": "integer"
    }
  },
  "required": [
    "query"
  ]
}

Everything ETFIQ publishes about one fund: issuer, desk, and each figure with its source and as-of date, plus a one sentence verdict on how it did against what its own label promises.

{
  "type": "object",
  "properties": {
    "ticker": {
      "type": "string"
    }
  },
  "required": [
    "ticker"
  ]
}

What a fund holds, by weight, and how old that is. ALWAYS read lag_days before presenting it: an issuer file read today and a filing from two months ago both come back here and are not the same answer.

{
  "type": "object",
  "properties": {
    "ticker": {
      "type": "string"
    },
    "top_n": {
      "type": "integer"
    }
  },
  "required": [
    "ticker"
  ]
}

Every US listed fund in a theme, largest first, with what each charges and how much of it is already in the S&P 500. USE THIS for any "what X ETFs are there" or "top X ETFs" question: it returns the whole published set rather than a sample.

{
  "type": "object",
  "properties": {
    "theme": {
      "type": "string"
    },
    "limit": {
      "type": "integer"
    }
  },
  "required": [
    "theme"
  ]
}

Every theme ETFIQ publishes and how many funds each holds. Call when unsure what a theme is called, then etf_theme.

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

Read ANY published ETFIQ page as text: a theme hub, a ranking, a comparison of two funds, an issuer, a methodology note, a dated study. Takes a path like /themes/cyber or a full etfiq.com URL. This reaches all 40,000 pages, including everything the typed tools above do not cover, and returns the page content rather than its navigation.

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string"
    }
  },
  "required": [
    "path"
  ]
}

What ETFIQ publishes, section by section, with a page count for each. Start here when the question is not about one fund: it names every section and what is in it.

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

The pages inside one section, optionally filtered to those whose address contains a word. Use after etfiq_sections to find a page, then etfiq_page to read it. The count returned is the whole matching set even when the list is capped.

{
  "type": "object",
  "properties": {
    "section": {
      "type": "string"
    },
    "contains": {
      "type": "string"
    },
    "limit": {
      "type": "integer"
    }
  },
  "required": [
    "section"
  ]
}

Every fund matching some filters, largest first, each with its net assets and the source and date that figure came from. Use for "find me all X" questions rather than repeated searches. Fees are percentages, not basis points. Funds with no published size are set aside from a size filter and counted in no_size_figure rather than treated as small.

{
  "type": "object",
  "properties": {
    "desk": {
      "type": "string"
    },
    "issuer": {
      "type": "string"
    },
    "max_fee_pct": {
      "type": "number"
    },
    "min_assets_usd": {
      "type": "number"
    },
    "limit": {
      "type": "integer"
    }
  }
}

How much of their weight two funds hold in common, as ETFIQ published it on the comparison page for that pair. Use when asked whether two ETFs are the same thing, or whether owning both adds anything. Refuses rather than estimating when the pair is not compared or either holdings book is incomplete.

{
  "type": "object",
  "properties": {
    "a": {
      "type": "string"
    },
    "b": {
      "type": "string"
    }
  },
  "required": [
    "a",
    "b"
  ]
}

What ETFIQ published on a given date, from its frozen dated archive. Use when a question is about a past date, or when a figure needs to stay true after it is quoted: every other tool here answers about today and today moves overnight. Takes YYYY-MM-DD. Covers the pieces written that night, not an arbitrary per-fund figure on an arbitrary day.

{
  "type": "object",
  "properties": {
    "date": {
      "type": "string"
    }
  },
  "required": [
    "date"
  ]
}

Which US listed ETFs hold a given company, ranked by how much of each fund it is. USE THIS for any "which ETFs hold X", "which fund holds the most X", or "how do I get exposure to X" question, where X is a company rather than a fund, and for "which bond ETFs hold X's debt". Takes a company name or its ticker. Returns every fund holding its shares with the weight its issuer published and the date that book was filed, and separately every fund holding its bonds or other debt. Covers 31,019 companies.

{
  "type": "object",
  "properties": {
    "company": {
      "type": "string"
    },
    "limit": {
      "type": "integer"
    }
  },
  "required": [
    "company"
  ]
}

The ranked lists ETFIQ publishes, or one of them. Each ranks ONE published figure inside a stated set: the cheapest funds in a theme, the leveraged funds furthest from their stated multiple, the buffer funds closest to their cap. Call with no argument for the list.

{
  "type": "object",
  "properties": {
    "slug": {
      "type": "string"
    },
    "limit": {
      "type": "integer"
    }
  }
}

Builds a custom portfolio of US listed ETFs from construction choices about the PORTFOLIO and shows the rule it applied (ETFIQ custom construction rule, version 1): stocks at the chosen band's point, international stocks 40% of the stocks outside themes, themes 10% of stocks in equal parts, commodities and alternatives 5% each taken from bonds, US bonds the rest; in each sleeve the cheapest (or largest) funds that file N-PORT, hold at least $100 million and have three years of prices, each fund's fee with its filing date. BEFORE CALLING, ask the user in ONE short series for any missing choice: the band, described by stock share (conservative: more than 15% and up to 30% stocks; moderately-conservative: more than 30% and up to 50%; moderate: more than 50% and up to 70%; moderately-aggressive: more than 70% and up to 85%; aggressive: more than 85%); whether to include commodities, alternatives, international stocks and themes (and which themes, at most five, by the ids etf_themes lists); an optional fee ceiling in percent; the number of funds, 2 to 12; and cheapest or largest (default cheapest). NEVER ask about, and never pass, the person's age, income, savings, net worth, goals, time horizon, tax situation, risk tolerance, employment or family, and never turn what someone says about themselves into a band: the band is the user's choice about the portfolio's stock share. If asked whether a portfolio suits someone, or whether to buy or sell it, say that ETFIQ does not answer that and give the not-advice line. Every response carries the not-advice line in not_advice: show it with the portfolio.

{
  "type": "object",
  "properties": {
    "band": {
      "type": "string",
      "enum": [
        "conservative",
        "moderately-conservative",
        "moderate",
        "moderately-aggressive",
        "aggressive"
      ],
      "description": "The stock-share band the portfolio should sit in."
    },
    "include": {
      "type": "object",
      "additionalProperties": false,
      "required": [
        "commodities",
        "alternatives",
        "international",
        "themes"
      ],
      "properties": {
        "commodities": {
          "type": "boolean"
        },
        "alternatives": {
          "type": "boolean"
        },
        "international": {
          "type": "boolean"
        },
        "themes": {
          "type": "boolean"
        },
        "themeIds": {
          "type": "array",
          "items": {
            "type": "string"
          },
          "minItems": 1,
          "maxItems": 5,
          "uniqueItems": true,
          "description": "Theme ids, only when themes is true."
        }
      }
    },
    "feeCeiling": {
      "type": "number",
      "exclusiveMinimum": 0,
      "maximum": 3,
      "description": "The most any one fund may charge, in percent a year (0.25 is 0.25%)."
    },
    "funds": {
      "type": "integer",
      "minimum": 2,
      "maximum": 12
    },
    "criterion": {
      "type": "string",
      "enum": [
        "cheapest",
        "largest"
      ],
      "default": "cheapest"
    }
  },
  "required": [
    "band",
    "include",
    "funds"
  ],
  "additionalProperties": false
}