Grafana_Dashboard

📊 Grafana Dashboard Setup Guide

This guide outlines how to install Grafana and connect it to the InfluxDB database to visualize historical stock market data.

🛠 Installation

✅ Windows

1. Download from: https://grafana.com/grafana/download
2. Extract and run grafana-server.exe.
3. Open http://localhost:3000 in a browser.
4. Default login: admin / admin (you’ll be prompted to change it).

✅ Linux (Debian/Ubuntu)

sudo apt install -y software-properties-common
sudo add-apt-repository "deb https://packages.grafana.com/oss/deb stable main"
sudo apt update
sudo apt install grafana
sudo systemctl start grafana-server

🔗 Connecting Grafana to InfluxDB

1. Go to Settings > Data Sources in Grafana.

2. Choose InfluxDB as the data source.

3. Enter:

   • URL: http://localhost:8086
   • Database(Bucket): stock_price
   • Auth Token (or username/password if InfluxQL)

4. Click Save & Test.

📈 Sample Dashboard

• Add new panel: Visualize stock_price by ticker.
• Example query:

from(bucket: "stock_price")
  |> range(start: -30d)
  |> filter(fn: (r) => r._measurement == "stock_price")

🧩 Dashboard Features

• Real-time graphing of prices and volume
• Ticker-based filtering
• Export options (CSV/PNG/PDF)

📥 Import Prebuilt Dashboard

Once all the InfluxDB data upload scripts have been executed and your database is populated, you can import the prebuilt Grafana dashboard for this project:

1. In Grafana, go to + > Import.

2. Upload the file Stock Market Prediction-1731762228187.json.

3. When prompted:

   • Set the data source to the InfluxDB instance you configured (ensure the name matches).

4. Click Import.

This will load a ready-to-use dashboard tailored for stock market data visualization.

📎 Notes

Ensure InfluxDB is running before launching Grafana. Use dashboard export/import to reuse panel layouts and backup configurations.