Stockscreener
Build a Stock Screener using FastAPI (Python)
Install / Use
/learn @hackingthemarkets/StockscreenerREADME
Didn't see a lot of examples out there for this framework, so decided to create one.
Step 1: Hello World of FastAPI, Stub out the API endpoints
- Display Hello World
- Map out endpoints we will need, comment what they will do
Step 2: Mock the UI with Semantic UI and Jinja2 Templates
- Including CSS and JavaScript from the CDN
Step 3: Database Design
- To design our database, we create SQLAlchemy models
- See what yfinance provides
- forwardPE, forwardEps, dividendYield, 50 Day, 200 Day, Close
- SQLAlchemy create_all
Step 4: Add a stock endpoint
- Background task to fetch info and add to db also
- Use Insomnia to test it
Step 5: Wire home screen
- Show added stocks in a table
Step 6: Filters to filter table
- Filter boxes on UI
- Use SQLALchemy to filter in db
- Use query parameters to filter
Step 7: Modal to add stock tickers via UI
Related Skills
node-connect
349.9kDiagnose OpenClaw node connection and pairing failures for Android, iOS, and macOS companion apps
frontend-design
109.8kCreate distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, or applications. Generates creative, polished code that avoids generic AI aesthetics.
openai-whisper-api
349.9kTranscribe audio via OpenAI Audio Transcriptions API (Whisper).
qqbot-media
349.9kQQBot 富媒体收发能力。使用 <qqmedia> 标签,系统根据文件扩展名自动识别类型(图片/语音/视频/文件)。
