ETF buying and selling
get_etf_flowsUse this when the user asks how much money went into or out of US ETFs or one ETF, whether ETFs are buying or selling a stock, or which stocks entered or left an index fund. Without a ticker, returns the day's ETF inflows and outflows and the largest net additions and reductions of stocks. With an ETF's ticker (QQQ), its net creations and redemptions in dollars on each of the last 20 closes. With a stock's ticker, the net change in shares held by the US ETFs read daily from their issuers' files on the latest market close, its value at the files' own prices, the ETFs that added and trimmed, a 20-close series, index entries and exits and corporate actions. A change mixes creations of the ETFs' own shares with rebalancing; beyond_growth leaves out the first. Mergers, spin-offs and splits are no trades: left out of the sums. Not for which ETFs hold a stock (find_etfs_holding_stock) or one ETF's holdings changes (get_etf_holdings_changes).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ticker | No | An ETF ticker for its own money flows, for example QQQ, or a stock ticker, for example NVDA, or a line listed abroad such as 7203.JP. Leave it out for the day's flows. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | No | The market close of the figures. | |
| latest | No | ||
| series | No | ||
| ticker | No | ||
| covered | No | ||
| how_to_quote | No | ||
| index_events | No | ||
| added_by_value | No | ||
| reduced_by_value | No | ||
| corporate_actions | No |