Best used with an AI agent

40+ live apps, open data APIs, MCP servers, and 200+ guides - more than anyone wants to click through. Point your AI here and it reads the whole map and does the work: finds the tool, pulls the data, runs the analysis, and hands you the links.

Here for the open-source code? Your agent finds the right repo for you - and can even clone and deploy it.

Prefer to explore on your own? Go right ahead.

Paste this to Claude Code, Codex, or any AI agent:
Go to tigzig.com and read tigzig.com/llms.txt. It is a practitioner toolkit - 40+ analytics apps, open no-auth data APIs, MCP servers, open-source repos (github.com/amararun), and 200+ build guides. Help me [your task]. Surface the exact links; where there is an API or MCP, call it directly; and if I want to self-host, find the repo and help me deploy it.

Yahoo Finance Analyzer: Stock Data to AI-Powered Reports

Technical indicators, Gemini AI analysis, and PDF report generation directly in Excel using xlwings Lite.

Download Excel Watch Video Guide

What This App Does

#

Pull stock data, perform technical analysis, and generate AI reports:

  • Pull stock profiles from Yahoo Finance
  • Retrieve historical prices and financials
  • Compute technical indicators (EMA, RSI, MACD, Bollinger)
  • AI-powered analysis via Gemini
  • Generate styled PDF reports
  • Financial statements (P&L, Balance Sheet, Cash Flow)

Important Note

YLENS is a working prototype demonstrating xlwings Lite capabilities. Not investment advice. AI/automation in live use requires iteration, validation, and human judgment.

How to Use

#
  1. Download & Install: get the app above and install xlwings Lite
  2. Get Gemini API key: free at aistudio.google.com
  3. Built-in Functions:
    • get_profile - company info
    • get_prices - historical prices
    • create_technicals - calculate indicators
    • get_technical_analysis_from_gemini
  4. Enter tickers: Yahoo symbols (AAPL, ^NSEI, etc.)

How It Works

#

Data Retrieval

  • xlwings Lite calls a custom FastAPI server
  • FastAPI uses yfinance to fetch Yahoo Finance data
  • Server handles CORS issues from the browser environment

Technical Analysis

  • finta package calculates EMA, RSI, MACD
  • Indicators added as new columns to price data
  • Data prepared for AI analysis

AI Reporting

  • Price data + indicators sent to Gemini
  • Markdown output styled via FastAPI server
  • Converted to PDF via the md2pdf service

Resources

xlwings Lite

Official website with installation instructions and examples
xlwings Documentation

Comprehensive documentation with Excel object reference and API docs
FastAPI - Markdown to PDF

GitHub repo for the PDF conversion service
FastAPI - Yahoo Finance

GitHub repo for the yfinance data service
xlwings Lite

Built with xlwings Lite

Created by Felix Zumstein, it brings Python into Excel seamlessly - enabling native support for databases, AI agents, LLMs, advanced analytics, ML, APIs, and complete automation workflows.

Bugs,issues,questions? Drop a note: [email protected]