I’m excited to share a Stock Market Analytics App I built using Plotly Dash. This app provides interactive stock market insights and portfolio management tools, leveraging yfinance for data retrieval, Polars for fast data wrangling, and SQLite for storage. Styling is handled with dash-bootstrap-components for a sleek, responsive UI. I’d love your feedback on improving its features, design, and performance!
Market Dashboard – Interactive line charts, candlestick charts, volume analysis, and correlation heatmaps. Portfolio Dashboard – View key performance indicators (KPIs), portfolio distribution, and sector allocation. Portfolio Management – Add, edit, and delete stocks via an intuitive form. User Guide – Glossary of financial terms and data source details. Efficient Data Handling – Uses Polars for fast data processing and SQLite for structured storage. Modern UI – Styled with dash-bootstrap-components for responsiveness.
Upcoming Feature
Automated Data Updates – Daily stock data updates to SQLite (pending implementation).
Looking for Feedback!
I’d love to hear your thoughts on: UI/UX improvements Performance optimizations Additional features that would enhance usability
If you have suggestions or spot any bugs, let me know!
Big thanks to Plotly Dash, yfinance, and this amazing community! Looking forward to your feedback!
Hi! Amazing job mate!
By the way, I am currently enhancing my ‘MySQL knowledge’, so I would be more than pleased to collaborate with you in setting up the ground on MySQL Server and handling read and write opps.
What a great app, @Alfredo49 . Nice job!
One thing I would recommend is to ensure consistency in the theme. For example, convert the right bottom dropdown to black background, just like the other dropdowns on the main page.
Actually I am planning to migrate to a database on server, I am looking for a cloud provider with free tier for avoid costs, do you have any solution in mind?
Actually, I was thinking more like a home-based platform, however you’re right. And the knowledge that you could get to it could be massive. This is a ChatGPT answer… Maybe it’s worth to explore:
Amazon Web Services (AWS):
AWS provides a free tier for Amazon RDS, which includes MySQL. New AWS customers receive 750 hours per month of Amazon RDS Single-AZ db.t3.micro or db.t4g.micro instance usage for MySQL, along with 20 GB of General Purpose SSD storage and up to 100% of the total provisioned storage size for backup storage. This offer is valid for 12 months from the date your account is activated.
Azure offers a free account that includes access to Azure Database for MySQL Flexible Server. With this, you get 750 hours per month of Burstable B1MS instance usage, 32 GB of storage, and 32 GB of backup storage. This offer is available for 12 months.
Oracle Cloud’s Free Tier provides Always Free services, including Autonomous Transaction Processing and Autonomous Data Warehouse, which support MySQL-compatible workloads. These services are available for an unlimited period with certain usage limits.
Features
Market Dashboard – Interactive line charts, candlestick charts, volume analysis, and correlation heatmaps.
Portfolio Dashboard – View key performance indicators (KPIs), portfolio distribution, and sector allocation.
Portfolio Management – Add, edit, and delete stocks via an intuitive form.
User Guide – Glossary of financial terms and data source details.
Efficient Data Handling – Uses Polars for fast data processing and SQLite for structured storage.
Modern UI – Styled with dash-bootstrap-components for responsiveness.
Upcoming Feature
Automated Data Updates – Daily stock data updates to SQLite (pending implementation).
Looking for Feedback!
UI/UX improvements
Looking forward to your feedback! 
I plan to make similar dashboard.
