Real Time MySQL charts
We are going to create a sqlDashboard to display live charts of stock prices from a MySQL database.
Creating a SQL Dashboard for MySQL
In this demo we:
- Have a database that stores historical stock data and pulls the latest live prices from yahoo finance.
- Display our data in MySQL workbench
- Add Charts to our sqlDashboard
- Data table displaying the static data for a stock
- Time series graph of latest prices today for one particular stock
- OHLC Chart displaying the price history
- Use a form to allow the user to select particular stocks