---
title: "Pull your quants numbers directly with Claude / ChatGPT in Excel (with MCP)."
slug: qrep-mcp-quants-numbers-claude-chatgpt-excel
date_published: 2026-03-07T14:00:00.000Z
original_url: https://www.tigzig.com/post/qrep-mcp-quants-numbers-claude-chatgpt-excel
source: migrated
processed_at: 2026-03-07T14:00:00.000Z
---

# Pull your quants numbers directly with Claude / ChatGPT in Excel (with MCP).

![QREP Security Performance Report](/images/blog/qrep_mcp.png)

Ask in plain English: "Pull all stats for Apple, Google, Microsoft past 10 years".

Get back 81 metrics - returns, sharpe, sortino, drawdowns - the whole bucket load.

Powered by Ran Aroussi's (creator of yfinance python library) QuantStats library.

Works with Claude in Excel, ChatGPT in Excel, Claude Desktop, Cursor, n8n, or any MCP client.

MCP Server URL: qrep-api.tigzig.com/mcp

The server is free to use (rate limits apply). Just add that URL as custom connector and you are set.

This is the public version. No API key. No auth. For production use, always use OAuth / SSO (see links below).

At the same time, my standard MCP advice still stands - don't connect to unknown MCP servers blind. Use servers from reputed providers, or ones you deploy yourself. If you'd like to implement, easiest way - paste this message to your AI Coder. It knows what to do.

Full source code is open. Single Python file. Clone it, inspect it, deploy your own.

Web version of QREP: [qrep.tigzig.com](https://qrep.tigzig.com)

---

## Resources

- [GitHub - QuantStats](https://github.com/ranaroussi/quantstats) - The library powering the analysis
- [GitHub - QREP MCP](https://github.com/amararun/qrep-mcp) - Full source code, single Python file
- [Docs - QREP MCP](https://qrep-api.tigzig.com/docs) - API documentation
- [MCP with OAuth](https://www.tigzig.com/post/going-beyond-google-login-hardening-entry-points) - How to secure MCP servers for production use

<!-- blog-sidebar-related -->
## Related

Tools: [QRep - Security Reports](https://www.tigzig.com/qrep), [Quants Suite](https://www.tigzig.com/portfolio-analysis-suite), [Quants Agent](https://www.tigzig.com/n8n-tech-analysis)

Explore: [Claude for Analytics hub](https://www.tigzig.com/ai-in-excel), [Quant tools hub](https://www.tigzig.com/markets), [MCP servers hub](https://www.tigzig.com/apis)

More posts: [QREP in Excel: 81 Risk and Return Metrics Inside Your Sheet Through Claude in Excel.](https://www.tigzig.com/post/qrep-claude-in-excel-mcp-jun2026), [S&P 500 Drawdown Analysis with QREP](https://www.tigzig.com/post/sp500-drawdown-qrep-analysis), [MCP Guide for Claude in Excel - and any MCP client](https://www.tigzig.com/post/mcp-guide-claude-in-excel), [QRep - Powered by QuantStats. Live Now.](https://www.tigzig.com/post/qrep-quantstats-security-analytics-live), [Three Tools I Built for Market Analysis - QSUITE, TREMOR, QREP](https://www.tigzig.com/post/three-tools-market-analysis-qsuite-tremor-qrep)

---
Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar
Source: https://www.tigzig.com/post/qrep-mcp-quants-numbers-claude-chatgpt-excel
Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar.
License: https://www.tigzig.com/terms