Built and run by one person.
An Excel Tracker for Hundreds of Yahoo Finance Tickers, Built with xlwings Lite. For When WEBSERVICE Keeps Failing.
Top•DUCKIT - CSV to DuckDB•QRep - Security Reports•Quants Agent

An Excel Tracker for Hundreds of Yahoo Finance Tickers, Built with xlwings Lite. For When WEBSERVICE Keeps Failing.

Published: August 7, 2026

Related toolsDUCKIT - CSV to DuckDB•QRep - Security Reports•Quants Agent

If you are pulling hundreds of Yahoo Finance tickers into Excel through the Tigzig YFIN API and WEBSERVICE keeps failing, here is a tracker built for exactly that. Built with xlwings Lite, Python running inside Excel. Pulls dividend & earnings calendar data, and prices.

Uses YFIN's batching, up to 25 tickers at a time, batch size is configurable. Each batch writes back to the sheet as it comes in, with a spinner and a running status cell so you can see the load in progress.

All dates are UTC calendar dates in YYYY-MM-DD, no time of day. Yahoo timestamps each event to an exact instant, and we report the UTC date of that instant. For a US company reporting after roughly 8 PM Eastern, that instant crosses midnight UTC, so the UTC date is the next day. Convert from UTC to your own timezone rather than assuming the date is the US trading date.

Currently set up for S&P 500 tickers, swap in your own list. Full S&P 500 calendar pull takes around 9 minutes, price pull for 4 trading days takes around 2 minutes.

xlwings Lite, built by Felix Zumstein, is free, comes as an Excel add-in you install once, and then you write and run Python inside Excel itself. It is my tool of choice for Excel automation. Installation is simple, guide linked below.

If you need to modify anything, the code is right there, hand it to any AI, including ChatGPT, and it should be able to change it for you. Guides and templates on xlwings Lite are on my hub, also linked below.

Demystifying Tigzig API errors

The most common errors I see on my API backend and how to fix them: Demystifying Tigzig API errors

And if you share your error along with the link to the API docs above with your AI, it should be able to identify and fix it for you. Full catalogue of all Tigzig APIs is available at:

For MFPRO API users

For MFPRO API (tigzig.com/mfpro) users reading this: the same setup works for the India mutual fund APIs too. Hand the base code here to your AI along with the API doc links above, and it should be able to set it up for you fairly quickly. In fact you can go one step ahead, and have it set up calculations for risk, return, benchmark and other KPIs too.