MCP.so
Sign In

Fruit Stand Fund Returns MCP ServerVerifiedFeatured

@fruitstanddev

Basic information

Transport

Streamable HTTP

Authentication

API Key

Last updated

Category

Finance & Commerce

Author

fruitstanddev

Submitted by

Samuel Estigoy

About Fruit Stand Fund Returns MCP Server

Hosted MCP server for trailing and calendar-year total returns of 32,000+ US mutual funds and ETFs — compare, screen, and explain fund performance by ticker.

#fund returns#trailing returns#calendar year returns#annualized returns#ETFs#funds#mutual funds

Connection details

https://api.fruitstand.dev/mcp

Setup

claude mcp add fruit-stand-fund-returns --transport http https://api.fruitstand.dev/mcp

Fruit Stand Fund Returns MCP Server tools

6

Search the ~32,000 US mutual funds and ETFs by name or ticker to get the `code` the other tools need. Returns fund metadata only — name, type (ETF or FUND), exchange, currency, ISIN, and the date range with return data — plus `next_cursor` for keyset paging. No performance figures here; use getTrailingReturns / getCalendarReturns for those.

Fetch one fund's metadata by ticker (`code`): name, type (ETF or FUND), exchange, currency, ISIN, active/inactive status, and the date range for which return data exists. Returns 404 if the ticker is unknown. Use searchFunds to resolve a name to a code; use the returns tools for performance.

Trailing total returns for one fund: 1d, 1w, 1m, 3m, 6m, YTD, 1y-20y, and since inception. Latest by default, or pass `as_of` (snaps to the prior trading day). Values are decimal fractions of total return, distributions reinvested (0.1234 = +12.34%); multi-year figures are cumulative. Use batchTrailingReturns for many funds.

Trailing total returns for up to 100 funds in one call - same data as getTrailingReturns. Pass `codes` and optional `as_of`. One row per fund; funds with no data are omitted and order is not guaranteed, so match on `code`. Values are decimal fractions, total return, distributions reinvested. Use this to compare or screen funds.

Full calendar-year (Jan-Dec) total return for one fund. Pass `year`, or omit for the latest completed year. `calendar_year_return` is a decimal fraction, distributions reinvested (0.263 = +26.3%); `base_date`/`end_date` give the actual span (partial in launch/delist years). Use getTrailingReturns for rolling windows.

Calendar-year total returns for up to 100 funds in one call - same data as getCalendarReturns. Pass `codes` and optional `year`. One row per fund; funds with no data are omitted and order is not guaranteed, so match on `code`. Values are decimal fractions, total return, distributions reinvested. Use this to compare funds across a year.

Overview

Trailing and calendar-year total returns for 32,000+ US mutual funds and ETFs, over MCP.

Give an AI assistant a direct line to fund-performance data — compare, screen, and explain how funds have done, by ticker, without a Morningstar or Bloomberg contract.

What it does

Six tools covering trailing total returns (1-day through 20-year and since-inception) and full calendar-year returns for ~32,000 US mutual funds and ETFs, refreshed daily. An agent can resolve a ticker, pull returns for one fund or batch up to 100 in a single call, and answer questions like:

  • "How did SPY, QQQ, and VTI compare over 1, 5, and 10 years?"
  • "Which of these funds had the best 2022 calendar year?"
  • "Show me a few large-cap ETFs and their YTD returns."

Every figure is a total return with distributions reinvested, returned as a plain decimal (0.1234 = +12.34%) alongside the date it reflects.

Connect

Remote MCP over Streamable HTTP. Get a free API key at app.fruitstand.dev (no card), then point your client at https://api.fruitstand.dev/mcp with your key as a bearer token.

Claude Desktop (claude_desktop_config.json):

{
  "mcpServers": {
    "fruit-stand": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "https://api.fruitstand.dev/mcp",
        "--header",
        "Authorization: Bearer YOUR_API_KEY"
      ]
    }
  }
}

Native remote-MCP clients (Cursor, Claude "Add custom connector"): use the URL above with header Authorization: Bearer YOUR_API_KEY.

Tools

ToolDescription
searchFundsSearch or list the ~32,000 US mutual funds and ETFs by name or ticker to get the code the other tools need. Metadata only.
getFundOne fund's metadata by ticker — name, type, exchange, currency, ISIN, data-coverage dates.
getTrailingReturnsTrailing returns for one fund: 1d, 1w, 1m, 3m, 6m, YTD, 1y–20y, since inception. Latest or as-of a date.
batchTrailingReturnsTrailing returns for up to 100 funds in one call.
getCalendarReturnsFull calendar-year total return for one fund — a specific year or the latest completed one.
batchCalendarReturnsCalendar-year returns for up to 100 funds in one call.

Notes

  • Data: ~32,000 US mutual funds & ETFs, total return with distributions reinvested, refreshed daily from the same pipeline behind the Fruit Stand datasets on Snowflake Marketplace.
  • Free tier, no card. Same key, data, rate limits, and quotas as the REST API.
  • On the official MCP Registry as dev.fruitstand/fund-returns.

Links

Frequently asked questions

1

What is the Fruit Stand Fund Returns remote MCP server?

The Fruit Stand Fund Returns remote MCP server is a hosted Model Context Protocol endpoint at https://api.fruitstand.dev/mcp, so AI assistants can connect to it without installing or running anything locally.

2

How do I connect to the Fruit Stand Fund Returns MCP server?

Add the endpoint https://api.fruitstand.dev/mcp to any MCP-compatible client such as Claude Code, Cursor, or VS Code. The setup snippets on this page configure each client in one step.

3

Does the Fruit Stand Fund Returns MCP server require authentication?

Yes. Fruit Stand Fund Returns requires an API key — check the official documentation for how to obtain one, then include it in your client's configuration.

4

Which transport does the Fruit Stand Fund Returns MCP server use?

Fruit Stand Fund Returns exposes a Streamable HTTP endpoint, the transport used by remote MCP servers and supported by all major MCP clients.

Comments