Pulling Yahoo Finance Data Into Your Own Trackers. Excel, Sheets, a Web Tool, or Straight From an AI Agent.
Published: August 26, 2026
Need to pull Yahoo Finance market data into your trackers and tools? Excel, Sheets, Web tools? Prices, Calendar, Financials, Reccos. Tigzig's YFIN API is built for that. Share the API doc with your AI and have it set it up for you or guide you. Free, no signup, no key needed.
If your trackers are in Excel, you can pull the data via Power Query, Python-in-Excel (xlwings Lite), VBA or a WEBSERVICE formula. Each has trade-offs. There is a ready xlwings Lite tracker template for calendar and prices, and AI can adapt the code for you (link below).
Google Sheets takes a few lines of Apps Script.
If you are building an HTML web tool, it's a simple API call from JavaScript.
And if you work through an AI agent, it is on MCP and needs no code at all.
You don't need to code it yourself. If you are using an AI Agent / Coder it will do it for you, and if you are using AI Chat like ChatGPT it can share code / formula and guide you where to paste. Share or copy the API docs with it, explain what you need.. it knows what to do.
- API docs (for you): tigzig.com/apis/yahoo-finance
- For your AI: yfin-h.tigzig.com/v1/openapi.json
- Python-in-Excel (xlwings Lite) tracker template: An Excel Tracker for Hundreds of Yahoo Finance Tickers
Easiest is with an AI agent
Easiest is with an AI agent, Claude Cowork, ChatGPT, or a coder like Claude Code or Google Antigravity. Basic subscriptions cover these.
You need the desktop app, it does not work on web. The agent goes straight into your Excel file. An xlsx is XML underneath, so it works on the internals directly. It will set up the Power Query step, write the formula, or lay out the sheet the way you asked. You don't need to know the code.
Python-in-Excel (xlwings Lite) is what I mostly use. I describe what I want, it gives me the code, I paste it in the code box and run it.
WEBSERVICE it will also set up for you. That one is volatile though, all the cells fire at once, so ask it to batch, yfin takes 25 tickers in a call. For anything large or frequent, Power Query or xlwings Lite is the better route.
Same idea for Google Sheets, or a JavaScript web tool.
No agent subscription? Plain chat is fine. Share the API doc link, ask it to use the batch API, and ask it to show you where to paste. A bit more tedious but works.
Either way, validate what comes back.
Quick start guides: tigzig.com/claude-for-analytics
A few quick ones
Yahoo wants the exchange ticker, not the company name. For Indian stocks that is
RELIANCE.NSon the NSE,RELIANCE.BOon the BSE. The company name with.NSon the end returns nothing. You can check the symbol on the Yahoo Finance site or use the search endpoint (see below).There is a search endpoint now, and it is mainly there for agents. Point your agent at it and it stops guessing tickers from memory. It searches, gets back the real symbols with the exchange each one sits on, and asks you which one you meant. You can also set up a search box in your tool off it. One caution: Yahoo always returns its nearest guesses, so a name that does not exist still comes back with confident looking rows, sometimes an index or a futures contract. Check the match.
For the financial statements, use the
/v1/excel/versions. They come back as structured rows that go into a sheet cleanly. The plain ones are pipe delimited text.On WEBSERVICE, ask your agent for an array formula that sends 25 tickers per call instead of one cell per ticker. A few hundred single-ticker cells all recalculate at the same instant, arrive as one burst, and start timing out.