How himanshuj9/stockscreenerapp works
Stock Screener is a full-stack Indian-stock research application. Users search for a company, open its dashboard, and view live market fundamentals alongside stored company information, financial results, balance sheets, and shareholding. The React app calls the FastAPI service; the company endpoint queries SQLAlchemy-backed MySQL data and fetches current market data from Yahoo Finance. The README also documents ratios as a capability. Source excerpts establish the main route and query relationships; unsampled model details and other UI components are represented by their indexed files, without asserting additional call paths.
Main entry points: company.py Company endpoints · App.tsx Route application · Home.tsx Home page · Company.tsx Company dashboard
Components 20
React interface
- Route application
UI/src/App.tsx - Home page
UI/src/pages/Home/Home.tsx - Search hero
UI/src/components/Hero/Hero.tsx - Navigation bar
UI/src/components/Navbar/Navbar.tsx - Company dashboard
UI/src/pages/Company/Company.tsx - API client
UI/src/services/api.ts
API service
- FastAPI application
backend/app/main.py - Company endpoints
backend/app/routers/company.py
Market data
- Market data service
backend/app/services/market_data.py
Persistence
- Database session
backend/app/database.py - Company records
backend/app/models/company.py - Company information
backend/app/models/company_information.py - Financial results
backend/app/models/financial_result.py - Financial metrics
backend/app/models/metric.py - Balance sheets
backend/app/models/balance_sheet.py - Shareholding patterns
backend/app/models/shareholding.py - Ratio records
backend/app/models/ratio.py
Other components
- Stock researcher
- Yahoo Finance
- MySQL database
Connections 21
- Stock researcher → Route application: opens app
README.md - Route application → Home page: routes to
UI/src/App.tsx - Route application → Company dashboard: routes to
UI/src/App.tsx - Home page → Search hero: renders
UI/src/pages/Home/Home.tsx - Home page → Navigation bar: renders
UI/src/pages/Home/Home.tsx - Search hero → API client: searches through
UI/src/components/Hero/Hero.tsx - Company dashboard → API client: loads and searches through
UI/src/pages/Company/Company.tsx - API client → Company endpoints: requests search and company data
UI/src/services/api.ts - FastAPI application → Company endpoints: registers routes
backend/app/main.py - FastAPI application → Database session: checks database health
backend/app/main.py - Company endpoints → Database session: obtains sessions
backend/app/routers/company.py - Company endpoints → Market data service: fetches market data
backend/app/routers/company.py - Market data service → Yahoo Finance: fetches quotes and fundamentals
backend/app/services/market_data.py - Database session → MySQL database: connects to
backend/app/database.py - Company endpoints → Company records: queries
backend/app/routers/company.py - Company endpoints → Company information: queries
backend/app/routers/company.py - Company endpoints → Financial results: queries
backend/app/routers/company.py - Company endpoints → Financial metrics: joins results with
backend/app/routers/company.py - Company endpoints → Balance sheets: queries
backend/app/routers/company.py - Company endpoints → Shareholding patterns: queries
backend/app/routers/company.py - Company dashboard → Company endpoints: displays returned dashboard data
UI/src/pages/Company/Company.tsx