My Python-based STOCK TRADING AGO web application is suffering from a real-time data issue: background processing runs, but the results reach the client side with a noticeable lag. I need you to trace that bottleneck, bring the pipeline back to true real-time behaviour, and then give the interface a fresh look while you’re in the codebase. Current stack • Python 3.10 with FastAPI • Celery + Redis for background jobs • PostgreSQL 13 • Front-end in plain HTML/CSS with a sprinkling of vanilla JS What I expect from you 1. Diagnose why background tasks aren’t pushing updates instantly—whether it’s queue configuration, database locking, or cache timing—and implement a clean, well-documented fix. 2. Refactor or rewrite any brittle algorithmic parts that slow ingestion or delivery. 3. Modernise the UI: a lightweight, responsive redesign (you can propose Tailwind, Bootstrap, or a minimalist custom approach as long as load time stays low). I’ll provide a colour palette and logo; everything else is open to your creative lead. 4. Supply concise setup notes and test scripts so I can reproduce results locally and on staging. I’m not on a tight clock, so take the time you need for a solid, maintainable solution, but please outline milestones and keep me in the loop with short progress updates. If you’re comfortable profiling Python, tuning Celery/Redis, and polishing a user-friendly front end, let’s get started.