An Excel Formula That Pulls 81 Risk and Performance KPIs in a Few Seconds: Five Stocks Against SPY, and Any Ticker on Yahoo Finance
Published: November 9, 2026
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
The tool:
The API and MCP server:
Working on something similar? How I work covers the rates, the availability and what I take on.