AI-Powered Technical Analysis in Excel - with Python & Gemini Vision

Published: April 9, 2025

PDF + Web Report | Python-in-Excel | xlwings Lite | Part 5

Check out dedicated xlwings LIte info page on REX AI Co Analyst site

• Full templates
• How-to guides
• Backend code
• Technical breakdowns
• Resource Links

Detailed info , source codes, how-to guides, resources and templates available on REX

What does the Excel app do

with xlwings Lite, directly from within Excel:

• Pull price data from Yahoo Finance via a custom API Web Layer
• Process technical indicators using Python package (Finta)
• Convert daily OHLCV into weekly Mon - Fri timeframes (pandas.resample)
• Build advanced charts with dynamic scaling (Matplotlib):
  • Price/volume with EMA-12/26 + Bollinger Bands
  • MACD subplot
  • ROC + RSI subplot
• Convert charts to base64 and send to Gemini API for vision based analysis
• Get back AI-generated markdown with analysis
• Generate PDF + Web reports using custom FastAPI markdown-to-PDF service
• Push final PDF and HTML URLs back into Excel sheet

Try it out

• Single Excel file. Download from docs below
• Excel > Home > Add-in > 'xlwings Lite'
• Get a Gemini API key - free, under a minute. aistudio.google.com → Get API Key → Create AI Key → Select default project

Docs

Detailed walkthroughs for each app, with templates, full backend source code and build guides: Go to Docs | xlwings Lite | LinkedIn

xlwings Lite, created by Felix Zumstein, is a powerful way to run Python workflows inside Excel. Now runs on newest version of Pyodide - you can now use the OpenAI Python package directly in Excel.

Fine Print

This is not investment research or advice. This is a working prototype - a practical example of what's possible with xlwings Lite. Live use cases require iteration, validation, and human judgment.

Explore 20+ open-source AI, analytics, and automation apps at tigzig.com. Covers AI-enabled automation, natural language to SQL, multi-agent reasoning, Python charts, stats, and database connectivity. Also includes custom GPTs connected to databases, make.com, n8n and FastAPI based backends for automated workflows. Free access, full source code, and build guide

xlwings Lite official site: lite.xlwings.org