𝐀𝐈-𝐏𝐨𝐰𝐞𝐫𝐞𝐝 𝐓𝐞𝐜𝐡𝐧𝐢𝐜𝐚𝐥 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 - 𝐰𝐢𝐭𝐡 𝐏𝐲𝐭𝐡𝐨𝐧 & 𝐆𝐞𝐦𝐢𝐧𝐢 𝐕𝐢𝐬𝐢𝐨𝐧

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

Go to Docs

𝐖𝐡𝐚𝐭 𝐝𝐨𝐞𝐬 𝐭𝐡𝐞 𝐄𝐱𝐜𝐞𝐥 𝐚𝐩𝐩 𝐝𝐨

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

𝐓𝐫𝐲 𝐢𝐭 𝐨𝐮𝐭

▸ 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

𝐃𝐨𝐜𝐬

https://rex.tigzig.com/xlwings-lite

Detailed walkthroughs for each app, with templates, full backend source code and build guides

𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞, 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.

https://lnkd.in/gVrsvzGF

𝐅𝐢𝐧𝐞 𝐏𝐫𝐢𝐧𝐭

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 rex.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