𝐀𝐈-𝐏𝐨𝐰𝐞𝐫𝐞𝐝 𝐓𝐞𝐜𝐡𝐧𝐢𝐜𝐚𝐥 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 - 𝐰𝐢𝐭𝐡 𝐏𝐲𝐭𝐡𝐨𝐧 & 𝐆𝐞𝐦𝐢𝐧𝐢 𝐕𝐢𝐬𝐢𝐨𝐧
- Amar Harolikar
- Apr 9
- 2 min read
Updated: 7 days ago
PDF + Web Report | Python-in-Excel | xlwings Lite | Part 5
𝐖𝐡𝐚𝐭 𝐝𝐨𝐞𝐬 𝐭𝐡𝐞 𝐄𝐱𝐜𝐞𝐥 𝐚𝐩𝐩 𝐝𝐨
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
𝐃𝐨𝐜𝐬
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.
𝐅𝐢𝐧𝐞 𝐏𝐫𝐢𝐧𝐭
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