Best used with an AI agent

40+ live apps, open data APIs, MCP servers, and 200+ guides - more than anyone wants to click through. Point your AI here and it reads the whole map and does the work: finds the tool, pulls the data, runs the analysis, and hands you the links.

Here for the open-source code? Your agent finds the right repo for you - and can even clone and deploy it.

Prefer to explore on your own? Go right ahead.

Paste this to Claude Code, Codex, or any AI agent:
Go to tigzig.com and read tigzig.com/llms.txt. It is a practitioner toolkit - 40+ analytics apps, open no-auth data APIs, MCP servers, open-source repos (github.com/amararun), and 200+ build guides. Help me [your task]. Surface the exact links; where there is an API or MCP, call it directly; and if I want to self-host, find the repo and help me deploy it.

QREP in Excel: 81 Risk and Return Metrics Inside Your Sheet Through Claude in Excel.

Published: June 29, 2026

Asset Returns, drawdowns, Sharpe, Sortino, alpha, beta, volatility.. QREP does it inside Excel. Straight into your sheet through Claude in Excel. 81 risk and return metrics.

Just ask Claude in Excel e.g. "Compare gold and bitcoin, last 10 years." or "compare Mag 7 past 10 years"... or any other stock, commodity, crypto etc that's there on Yahoo Finance.

Change symbols, time period, run your cuts the way you want ... have it format it the way you like, or push it into a deck.. or just do it directly in PowerPoint ....works the same way.

How to get it:

For you: the QRep MCP guide is here -> Tigzig.com ⇒ MCP ⇒ QREP

For your AI: just ask Gemini, ChatGPT or Claude etc "help me connect Claude in Excel to QRep from tigzig.com" and it will walk you through it.

Wary of connecting to someone else's MCP server? Fair.. that is the right instinct. The code is open source, a single Python file. Just ask your AI "help me deploy the QREP MCP server from tigzig.com" .. it knows where to go and what to do.

It is free to use. Powered by Ran Aroussi's QuantStats.

A few practical tips

A few practical tips if you start using this... also useful for any other analysis that you are doing with various avatars of Claude - Excel, PowerPoint, Cowork.

  1. The same connector works in PowerPoint too. So you can pull the numbers and have Claude build a formatted deck right there, and keep iterating on it as you go.
  2. Often it is easier to run your iterations in Excel first, get the numbers the way you want, then have Claude in Excel hand it over to Claude in PowerPoint for the deck. They can talk to each other. One catch.. the Claude window has to stay open and active, otherwise the connector does not respond.
  3. If you want really fine-tuned deck formatting, Claude in PowerPoint gets heavy and slow. For that I just go to Claude Cowork, have it build the output in HTML with whatever fonts and sizing I want.. a full research-report look or a plain one.. then convert it to PDF. Check my Claude Cowork Guide here tigzig.com/post/working-with-claude-cowork-claude-code-jun2026 .. or even easier - just have Cowork walk you through it ...

A few guides

QREP in Excel one-pager. Asset returns, drawdowns, Sharpe, Sortino, alpha, beta, volatility - 81 risk and return metrics straight into your Excel sheet through Claude in Excel. Ask Claude in Excel - 'Compare gold and bitcoin last 10 years', 'compare Mag 7 past 10 years', or any Yahoo Finance symbol. Open source, single Python file. Free. Powered by Ran Aroussi's QuantStats. tigzig.com - the analyst's tool shed - AI-agent first.