---
title: "AI-Powered Technical Analysis in Excel - with Python & Gemini Vision"
slug: 9e37b53b
date_published: 2025-04-09T07:47:11.605Z
original_url: https://www.tigzig.com/post/9e37b53b
source: migrated
processed_at: 2025-12-02T10:00:00.000Z
---

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

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

![Technical Analysis Report](https://static.wixstatic.com/media/ef0c19_fe6b592de4334202ac82739594f57e5f~mv2.png/v1/fill/w_360,h_215,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/ef0c19_fe6b592de4334202ac82739594f57e5f~mv2.png)

Check out dedicated xlwings LIte info page on [REX AI Co Analyst](https://tigzig.com/technical-analysis-report) 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](https://tigzig.com/technical-analysis-report) | [xlwings Lite](https://tigzig.com/xlwings-lite) | [LinkedIn](https://lnkd.in/gVrsvzGF)

**xlwings Lite**, created by [Felix Zumstein](https://www.linkedin.com/in/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](https://lite.xlwings.org)