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.

AI-Powered Technical Analysis in Excel

Generate professional technical analysis reports with Gemini Vision API, dynamic charts, and PDF/HTML outputs directly from Excel using xlwings Lite.

Download Excel Watch Video Guide

What This App Does

#

Creates professional technical analysis reports for Yahoo Finance tickers:

  • Pulls live price data from Yahoo Finance through a custom API layer
  • Processes technical indicators using the Python Finta package
  • Converts daily OHLCV data into weekly Mon-Fri timeframes
  • Builds advanced charts with dynamic scaling using Matplotlib
  • Sends charts to the Gemini Vision API for technical analysis
  • Generates PDF and HTML reports with embedded charts and tables
  • Automatically updates report URLs in Excel

Important Note

This tool is for educational and informational purposes only. Not investment research or advice.

How to Use

#
  1. Download and Install:
    • Download the Excel file using the button above
    • Install xlwings Lite from the Add-in button in Excel
  2. Get a Gemini API Key:
    • Go to aistudio.google.com
    • Navigate to "Get API Key -> Create AI Key"
    • Free, takes less than a minute (no credit card required)
  3. Enter Your Data:
    • Input a stock ticker symbol and date ranges
    • Run 'Generate Technicals Only' for charts and tables
    • Run 'Generate AI Analysis' for AI analysis with charts
  4. View Reports: click the generated URLs to view PDF and HTML reports

How It Works

#

Multi-tier architecture orchestration:

Data Processing

  • Excel frontend with xlwings Lite integration
  • Python backend for data processing and chart generation
  • Custom FastAPI server for Yahoo Finance data retrieval
  • Pandas for data manipulation and time series resampling

Visualization & Analysis

  • Matplotlib for professional-grade technical charts
  • Finta package for technical indicator calculations
  • Gemini Vision API for chart pattern recognition
  • Base64 encoding for image transmission

Report Generation

  • Custom FastAPI server for markdown to PDF/HTML conversion
  • Professional formatting with custom styles
  • Automatic URL generation and updates in Excel
  • Interactive HTML reports with embedded charts

Architecture Flow

Excelxlwings Lite PythonPandas + Finta Yahoo FinanceFastAPI Server MatplotlibCharts + Tables Gemini VisionAI Analysis PDF & HTMLReportsFastAPI Server

Data flows from Excel through Python processing to AI analysis and final report generation

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 FastAPI service that converts markdown to PDF reports
FastAPI - Yahoo Finance Pull

GitHub repo for the FastAPI service that connects to Yahoo Finance
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]