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