---
title: "An Excel Formula That Pulls 81 Risk and Performance KPIs in a Few Seconds: Five Stocks Against SPY, and Any Ticker on Yahoo Finance"
slug: qrep-excel-formula-81-kpis-nov2026
date_published: 2026-11-09T09:24:00.000Z
original_url: https://www.tigzig.com/post/qrep-excel-formula-81-kpis-nov2026
source: fresh
processed_at: 2026-11-09T09:24:00.000Z
---

# An Excel Formula That Pulls 81 Risk and Performance KPIs in a Few Seconds: Five Stocks Against SPY, and Any Ticker on Yahoo Finance

An Excel formula that pulls 81 risk and performance KPIs in a few seconds. Copy it into a cell:

```
=TEXTSPLIT(WEBSERVICE("https://qrep-api.tigzig.com/v1/compare?symbols=MSFT,META,ORCL,GOOGL,AMZN&benchmark=SPY&start_date=2025-11-03&end_date=2026-11-07&risk_free_rate=0.05&format=tsv"),CHAR(9),CHAR(10),FALSE,0,"")
```

It hits my API and works for anything on Yahoo Finance: stocks, crypto, commodities, FX. This one compares Microsoft, Meta, Oracle, Alphabet and Amazon against the SPY ETF over the last year. Swap in your own tickers, up to six, and change the dates. If Excel shows a warning, choose Paste without active content. If it gives an error, go to the end of the formula and press Enter again.

The same backend is available as an API and an MCP server.

How it works, the parameters, and the limits of WEBSERVICE:

[tigzig.com/post/qrep-excel-webservice-81-metrics-sep2026](https://www.tigzig.com/post/qrep-excel-webservice-81-metrics-sep2026)

The tool:

[tigzig.com/qrep](https://www.tigzig.com/qrep)

The API and MCP server:

[tigzig.com/apis/qrep](https://www.tigzig.com/apis/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-excel-formula-81-kpis-nov2026
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

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

Tools: [QRep - Security Reports](https://www.tigzig.com/qrep), [QDesk - Quant Report Desk](https://www.tigzig.com/qdesk), [DUCKIT - CSV to DuckDB](https://www.tigzig.com/duckit-xlwings)

Explore: [QREP API docs](https://www.tigzig.com/apis/qrep), [API and MCP catalog](https://www.tigzig.com/apis), [Python in Excel](https://www.tigzig.com/xlwings-starter)

More posts: [Pull 81 Risk and Performance Metrics Into Excel With One Formula](https://www.tigzig.com/post/qrep-excel-webservice-81-metrics-sep2026), [QDESK: A Reporting Desk for Portfolio Reports and Financial Data. Just Ask in Plain Language.](https://www.tigzig.com/post/qdesk-reporting-desk-sep2026), [YFIN API Now Returns Plain CSV on Most Endpoints. Add format=csv to the Same URL.](https://www.tigzig.com/post/yfin-api-csv-format-multiple-tickers-sep2026), [MCP Guide for Claude in Excel - and any MCP client](https://www.tigzig.com/post/mcp-guide-claude-in-excel), [xlwings Lite Local File Access: 8 Patterns You Can Use Today](https://www.tigzig.com/post/xlwings-lite-local-file-access-8-patterns)