Technical Analysis ChatGPT (OLD)

Technical analysis with Yahoo Finance, Finta, and Gemini Vision API

Connect ChatGPT to FastAPI-MCP servers for advanced technical analysis - integrate with Yahoo Finance, Finta, Pandas, and Gemini Vision API for automated analysis and reports.

MCP Server & User Interfaces:

https://rex.tigzig.com/mcp-server-technical-analysis

What This Gpt Does

• Fetches live price data from Yahoo Finance via a custom API
• Calculates technical indicators using the Finta package
• Converts daily OHLCV to weekly (Mon-Fri) using pandas.resample()
• Generates advanced charts (e.g. price + EMA, RSI, ROC, volume overlays) via Matplotlib
• Uses Gemini Vision API to analyze chart patterns
• Compiles PDF and HTML reports with embedded visuals and tables
• Returns sharable report URLs

How To Use

Ask ChatGPT to guide. Starter prompts also built in. Some tips:

For Technical Analysis:

• Specify the Yahoo symbol (e.g., GOOG)
• Mention time ranges naturally: "last 3 months for daily, 1 year for weekly"
• Always request results in table format or table format inside code block for easy Excel copy-paste

How It Works

A multi-layered architecture with integrated FastAPI-MCP servers, connected to ChatGPT via Custom Actions and OpenAPI JSON schema.

Technical Analysis Execution:

• MCP server runs a FastAPI Technical Analysis web service available as MCP Server
• Pulls daily data from a second FastAPI Yahoo Finance web service
• Converts daily to weekly using Pandas resample()
• Computes indicators using Finta
• Generates dynamic charts via Matplotlib
• Sends charts + data to Gemini Vision API
• Markdown responses (with charts & tables) returned

Report Generation:

• This is done by the 3rd FastAPI server for converting markdown to PDF and HTML
• Markdown with embedded images are passed to this server
• Report saved as PDF & HTML and URLs returned to ChatGPT

Tech Stack:

• fastapi-mcp python package to expose FastAPI servers as MCP servers
• FastAPI, Pandas, Matplotlib, Finta, Gemini API
• Static file serving for downloadable reports

How To Replicate

• Deploy Backend Servers
• Yahoo Finance data API (prices & financials)
• Markdown to PDF Server: Converts Markdown reports to PDF/HTML
• Technical Analysis Server:
• Yahoo Finance and Technical analysis FastAPIs already mounted with MCP
• Update Yahoo finance API endpoint in Technical Analysis server
• Setup Custom GPT
• Copy the Custom Action OpenAPI JSON Schema into new Custom GPT's custom actions
• That's it! Your GPT is ready to use

Resources

Custom GPT JSON Schema:

https://github.com/amararun/shared-fastapi-mcp-technical-analysis

OpenAPI Schema for connecting Custom GPT to backend Technical Analysis FastAPI-MCP Server. Available in docs folder

MCP Server - Technical Analysis:

https://rex.tigzig.com/mcp-server-technical-analysis

Detailed information about the Technical Analysis MCP server including build guides and source code

MCP Server - Yahoo Finance:

https://rex.tigzig.com/mcp-server-yahoo-finance

Detailed information about the Yahoo Finance Data Pull MCP server including build guides and source code

Markdown to PDF FastAPI:

https://mdtopdf.hosting.tigzig.com/

FastAPI server for converting markdown content to PDF and HTML reports

Backend Process Flow:

/images/mcpTechAnalysBackend.png

High level view of backend API call flows

Built On

OpenAI's GPT Platform - This custom GPT leverages ChatGPT's capabilities to provide an intuitive interface for technical analysis.

Source: tigzig.com | Open source AI tools for analytics, databases & automation | Amar Harolikar