--- title: "Pull 81 Risk and Performance Metrics Into Excel With One Formula" slug: qrep-excel-webservice-81-metrics-sep2026 date_published: 2026-09-17T10:00:00.000Z original_url: https://www.tigzig.com/post/qrep-excel-webservice-81-metrics-sep2026 source: fresh processed_at: 2026-09-17T10:00:00.000Z --- # Pull 81 Risk and Performance Metrics Into Excel With One Formula Did you know you can pull 81 risk and performance metrics for a stock, crypto, commodity or FX pair straight into Excel with one formula? It is powered by the Tigzig API. Copy the formula below into a cell, hit enter and give it a few seconds. It uses the Excel `WEBSERVICE` function to make an API call. That works well for many cases. It has some limitations too, and those are further down. ## The formula Paste this into a single Excel cell and hit enter. ``` =TEXTSPLIT(WEBSERVICE("https://qrep-api.tigzig.com/v1/compare?symbols=MSFT,META,ORCL,GOOGL,AMZN&benchmark=SPY&start_date=2025-03-14&end_date=2026-09-14&risk_free_rate=0.05&format=tsv"),CHAR(9),CHAR(10),FALSE,0,"") ``` If you get a warning, hit 'Paste without active content'. If it gives an error, go to the end of the formula and hit enter again. ## See the raw data in a browser Paste this into your browser if you just want to look at the numbers. ``` https://qrep-api.tigzig.com/v1/compare?symbols=MSFT,META,ORCL,GOOGL,AMZN&benchmark=SPY&start_date=2025-03-14&end_date=2026-09-14&risk_free_rate=0.05&format=tsv ``` Your browser will ask you to save a file named 'compare'. Save it, open it with Notepad and copy the values straight into Excel. Swap `format=tsv` for `format=json` if you would rather read it on screen. You can get the same thing from the tool itself. ## One caveat on WEBSERVICE Each call is one API request from one cell. That is fine for a single request like this one. Point it at a few hundred symbols and it stops working well. Excel sends all those calls out at once, so you run into the host's rate limit and get errors back for most of them. Power Query handles that case properly. So does Python inside Excel, which for me means xlwings Lite. I have written about both elsewhere. ## Parameters The risk free rate is a decimal fraction. 0.05 means 5 percent, and passing 5 is rejected. Six symbols is the maximum per call, and the benchmark sits outside that count. Dates are plain YYYY-MM-DD. ## The tool This is part of Tigzig's QDESK set of market tools. It is available via API, via MCP, through an AI agent interface, and through a form if you would like to do it yourself. It works for any Yahoo Finance ticker with data. For you: [tigzig.com/qrep](https://www.tigzig.com/qrep) For your agent: [api.tigzig.com](https://api.tigzig.com) ## Credit The backend is powered by the Python QuantStats library, [github.com/ranaroussi/quantstats](https://github.com/ranaroussi/quantstats). I have made some changes to the calculations. Those are covered in the Docs section of the tool. ![Pull 81 risk and performance metrics into Excel with one formula](/images/blog/qrepExcelSep2026.png) --- 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-webservice-81-metrics-sep2026 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 ## 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: [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), [Talk to Your Database from Excel - Postgres, DuckDB - via Claude in Excel with MCP](https://www.tigzig.com/post/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp), [xlwings Lite Local File Access: 8 Patterns You Can Use Today](https://www.tigzig.com/post/xlwings-lite-local-file-access-8-patterns)