Skip to main content
Glama
sheets-finance-mcp

sheets-finance-mcp

sheets-finance-mcp

MCP server for the SheetsFinance formula catalog.

This package exposes three tools:

  • sf_search: search metrics/functions and get ranked metric_id candidates.

  • sf_formula: build validated SheetsFinance formulas from a metric_id or explicit function/category/metric fields.

  • sf_describe: inspect category/function metadata, metric lists, and examples.

What Is SheetsFinance?

SheetsFinance is a Google Sheets add-on for financial market/company data retrieval using spreadsheet formulas.

Related MCP server: google-sheets-mcp

Installation

From this package directory:

pip install -e .

Run as a module:

python -m sheets_finance_mcp

Or via console script (installed by pyproject.toml):

sheets-finance-mcp

Claude Code MCP Config

{
  "mcpServers": {
    "sheetsfinance": {
      "command": "python",
      "args": ["-m", "sheets_finance_mcp"]
    }
  }
}

Tool Reference

Tool

Purpose

Typical Next Step

sf_search(query, limit=10)

Find matching metrics/functions

Use returned metric_id with sf_formula

sf_formula(...)

Construct a formula string (single or multi-symbol)

Paste formula in Sheets

sf_describe(target)

Inspect category/function metrics and options

Pick a metric/function for sf_formula

Example Workflow

  1. Search for a metric:

    sf_search(query="gross margin")
  2. Build a formula from the selected metric id:

    sf_formula(symbol="AAPL", metric_id="SF.ratios.grossProfitMargin")
  3. Inspect a category/function when needed:

    sf_describe(target="income")

For a non-SF function, symbol supplies the function signature's first argument, while the selected metric_id supplies the cataloged selector parameter. Pass all remaining named parameters through extra_args. For example, SF_OPTIONS_PRO.calls selects dataType="calls", while SF_BROKERAGE.holdings selects type="holdings"; in the latter case symbol contains the brokerage account nickname rather than a market ticker.

Available Tools

3 tools
sf_describeC

Describe all metrics for a category or non-SF function.

Inputs: target (required). Returns: object

sf_formulaC

Build and validate a SheetsFinance formula for SF() or non-SF functions.

Inputs: symbol (required), year, metric, options, +4 more. Returns: object

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3/5.0

    Scored across 3 tools

    Disambiguation5/5

    Each tool has a distinct purpose: describing metrics, building/validating formulas, and searching. No overlap or ambiguity.

    Naming Consistency5/5

    All tools follow a consistent 'sf_verb' pattern (sf_describe, sf_formula, sf_search), making them easy to predict.

    Tool Count4/5

    Three tools is a reasonable minimal set for the domain, though slightly thin; could benefit from one or two additional tools.

    Completeness4/5

    Covers the core needs of exploring, building, and searching finance formulas. Missing a 'list categories' tool but minor gap.

    Maintenance

    ActivityStale
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      A
      quality
      D
      maintenance
      MCP server for interacting with Google Sheets, providing tools to list sheets, read data from cell ranges, and write data to cell ranges.
      3
      3
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      FinancialFilings gives AI assistants and agents official filings, as published (annual and interim reports, ad-hoc disclosures, insider transactions, ESG reports) and standardized financials for listed companies in the US, EU, UK, APAC and LATAM. Remote MCP server at https://mcp.financialfilings.com/mcp with OAuth sign-in: no API key to copy, free for any FinancialFilings account.
      2
      MIT