Earnings Season in Excel: A Free Template for Calendar and Prices on the S&P 500, Built With xlwings Lite and the YFIN API
Top•DUCKIT - CSV to DuckDB•QRep - Security Reports•QDesk - Quant Report Desk

Earnings Season in Excel: A Free Template for Calendar and Prices on the S&P 500, Built With xlwings Lite and the YFIN API

Published: November 9, 2026

Related toolsDUCKIT - CSV to DuckDB•QRep - Security Reports•QDesk - Quant Report Desk

For analysts tracking earnings season and pulling data from Tigzig's YFIN API - I had published an Excel template some time back to pull calendar and prices for S&P500. This uses Python in Excel with xlwings Lite add-in.

Pretty straightforward to use .. and this is a fully functional base template .... your AI can adapt it for other endpoints or modify the output format the way you'd like.

Never used xlwings Lite before - just install the xlwings Lite add-in in Excel and hit Run. The attached post has links and guides.

tigzig.com/post/sp500-excel-tracker-xlwings-yfin-aug2026

Working on something similar? How I work covers the rates, the availability and what I take on.