sheets-finance-mcp
This server lets you explore the SheetsFinance formula catalog and generate validated spreadsheet formulas.
sf_search: Search metrics/functions by query and get ranked metric_id candidates.
sf_formula: Build validated SheetsFinance formulas from a metric_id or explicit function/category/metric fields, with support for extra args and multi-symbol options.
sf_describe: Inspect category/function metadata, metric lists, and examples to pick the right metric or function.
Supports both SF() and non-SF functions (e.g., SF_OPTIONS_PRO, SF_BROKERAGE) with flexible symbol and parameter handling.
Provides tools for searching, building, and describing SheetsFinance formulas to retrieve financial market and company data in Google Sheets.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@sheets-finance-mcp search for gross margin metric"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
sheets-finance-mcp
MCP server for the SheetsFinance formula catalog.
This package exposes three tools:
sf_search: search metrics/functions and get rankedmetric_idcandidates.sf_formula: build validated SheetsFinance formulas from ametric_idor 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_mcpOr via console script (installed by pyproject.toml):
sheets-finance-mcpClaude Code MCP Config
{
"mcpServers": {
"sheetsfinance": {
"command": "python",
"args": ["-m", "sheets_finance_mcp"]
}
}
}Tool Reference
Tool | Purpose | Typical Next Step |
| Find matching metrics/functions | Use returned |
| Construct a formula string (single or multi-symbol) | Paste formula in Sheets |
| Inspect category/function metrics and options | Pick a metric/function for |
Example Workflow
Search for a metric:
sf_search(query="gross margin")Build a formula from the selected metric id:
sf_formula(symbol="AAPL", metric_id="SF.ratios.grossProfitMargin")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 toolssf_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
sf_searchB
Search SheetsFinance metrics/functions and return ranked metric matches.
Inputs: query (required), limit. Returns: object
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 3 tools
Each tool has a distinct purpose: describing metrics, building/validating formulas, and searching. No overlap or ambiguity.
All tools follow a consistent 'sf_verb' pattern (sf_describe, sf_formula, sf_search), making them easy to predict.
Three tools is a reasonable minimal set for the domain, though slightly thin; could benefit from one or two additional tools.
Covers the core needs of exploring, building, and searching finance formulas. Missing a 'list categories' tool but minor gap.
Maintenance
Related MCP Connectors
MCP server for Financial Modeling Prep API with 250+ financial data tools
MCP server for stocksense-ai documentation, generated by doc2mcp.
Official Intrinio MCP server. US stock prices, options and fundamentals for AI agents.
MCP registry & directory: search, find & install 31k+ MCP servers & tools. Catalog and marketplace.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceAn MCP server that enables interaction with Google Sheets through natural language, allowing users to create, read, update, and manage spreadsheet data via the Google Sheets API v4.-
- AlicenseNot gradedqualityBmaintenanceMCP server for Google Sheets - read, write, and query spreadsheet data.599 npm2MIT
- AlicenseAqualityDmaintenanceMCP server for interacting with Google Sheets, providing tools to list sheets, read data from cell ranges, and write data to cell ranges.33MIT
- AlicenseNot gradedqualityBmaintenanceFinancialFilings 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.2MIT