Twelve Data

@twelvedata show me the top 10 ETFs by total assets in the US market, sorted by size

Based on the latest directory data, here are the 10 largest US ETFs by total assets: SPY (SPDR S&P 500 ETF Trust) leads with $487B in assets, followed by IVV (iShares Core S&P 500 ETF) at $412B, and VOO (Vanguard S&P 500 ETF) at $389B. The list continues with QQQ, VTI, AGG, BND, VEA, IEFA, and VTV rounding out the top ten. All figures reflect the most recent daily update from the exchange. This snapshot gives you a quick view of where institutional and retail capital is concentrated across passive equity and fixed-income strategies.

This example uses the ETFS Directory tool to surface market structure insights. The data refreshes daily, so asset rankings shift with market movements. Requires a valid API key. Useful for portfolio research or understanding which funds dominate liquidity in a given market segment.

@twelvedata convert 50,000 EUR to USD at the current exchange rate and show me the calculation

At the current real-time rate of 1.0847 USD per EUR, 50,000 EUR converts to 54,235 USD. The conversion uses live forex data from Twelve Data's currency feed, which aggregates institutional pricing. This rate reflects the mid-market spot price at the time of the query. Keep in mind that actual transaction rates from banks or brokers will include a spread, so your realized conversion may differ by 0.5–2% depending on the provider.

This example demonstrates the Currency Conversion tool for real-time forex calculations. The rate returned is indicative and may not match the final settlement rate your bank offers. Ideal for quick estimates in multi-currency workflows, but always confirm with your payment provider before executing large transfers.

@twelvedata pull the last 8 quarters of earnings data for AAPL, including EPS estimates vs actuals and any surprise percentage

Here's Apple's earnings performance over the last 8 quarters: Q1 2024 showed EPS of $2.18 (estimate: $2.10, +3.8% surprise), Q4 2023 delivered $1.46 (estimate: $1.39, +5.0% surprise), and Q3 2023 came in at $1.26 (estimate: $1.19, +5.9% surprise). The pattern continues through Q2 2023 ($1.52 vs $1.43) and earlier quarters, with Apple consistently beating analyst expectations by 3–6%. The data includes both GAAP and non-GAAP figures where disclosed, along with revenue context for each period. This historical beat rate suggests strong execution relative to Street consensus.

This example combines the Earnings and EPS Trend tools to synthesize historical performance against analyst expectations. The AI can identify patterns (consistent beats, misses, or volatility) that inform investment theses. Requires a valid stock symbol and API key. Note that earnings data lags by one quarter, so the most recent report may not yet be available.

When Twelve Data wins for quarterly client portfolio reviews

A 3-person RIA firm runs quarterly reviews for 40 clients, each holding 8-15 positions across equities and ETFs. The advisor needs dividend history, EPS actuals, and currency conversions for international holdings—all in one place during the Zoom call. Twelve Data's 22 tools cover this ground without switching tabs: pull dividends for yield analysis, check EPS revisions to flag underperformers, convert CAD dividends to USD for tax reporting. The API key auth means the whole team shares one Switchy workspace with no per-seat OAuth dance. If your client base is under 100 accounts and you're not building a proprietary algo trading system, this MCP keeps review prep under 20 minutes per client. Book a call if you're tired of toggling between Bloomberg Terminal and Excel for the same five data points.

This MCP shortens pre-call research for buy-side teams

A 6-analyst buy-side shop covers 120 mid-cap names, with earnings calls stacked 4-deep every Tuesday in Q4. Each analyst needs EPS actuals vs. estimates, analyst revision trends, and surprise indicators before the call starts at 8am. Twelve Data's Earnings, EPS Revisions, and EPS Trend tools surface that trifecta in under 60 seconds per ticker—no manual scraping of investor relations PDFs. The shared Switchy workspace means the junior analyst can pre-load 15 tickers Monday night, and the PM reviews them over coffee without re-authenticating. This breaks down if your universe is over 500 names or you need intraday tick data; the MCP is optimized for fundamental research cadence, not high-frequency signals. If your team spends more than 10 hours a week copy-pasting earnings tables, this is the fix.

When this MCP accelerates ETF discovery for robo-advisors

A 5-person fintech startup is building a tax-loss harvesting feature that needs to match 200 core ETFs with similar-but-not-substantially-identical alternatives. The product manager and two engineers need to filter by asset class, family, and total assets—then validate the list weekly as new funds launch. Twelve Data's ETFS Directory, ETFS Family, and Get ETF Types tools return structured, daily-updated lists without maintaining a proprietary database. The API key setup means the PM can prototype screens in Switchy, hand off the query to engineering, and both see live results in the same thread. This works until you hit 2,000+ funds or need sub-second latency for live trading; for research and product scoping at early stage, it's the fastest path from idea to validated dataset. If you're still scraping fund websites or paying $3k/month for a data vendor you only query twice a week, try this first.