Home
To make it simple, install mySQL and import the following SQL file: GuppyDashboard.sql
Download pt2msql.php and make the following changes:
mySQL database login details: $con = mysqli_connect("**<DATABASE_IP>**", "**<DB USER>**", "**<PASSWORD>**", "PT_DATA");
Path to the PT JSON file: $PTdb = '/YOUR/PATH/TO/PROFITTRAILER/ProfitTrailerData.json.backup';
Modify to suit your timezone:
$tz = new DateTimeZone('Australia/Brisbane');
date_default_timezone_set('Australia/Brisbane');
The Profit Trailer team currently support the following exchanges:
- Binance
- Bittrex
- Poloniex
The Guppy Dashboard utilizes the logfile from Profit Trailer so no api access is required.
Ubuntu
Run
sudo crontab -e
Add the following to run the script every 10 mins:
*/10 * * * * /usr/bin/php /PATH-TO-SCRIPT/.scripts/bin2msql.php
*/10 * * * * /usr/bin/php /PATH-TO-SCRIPT/.scripts/pt2msql.php
CentOS
Run
sudo nano /etc/crontab
Add the following to run the script every 10 mins:
*/10 * * * * USERNAME /usr/bin/php /PATH-TO-SCRIPT/.scripts/bin2msql.php
*/10 * * * * USERNAME /usr/bin/php /PATH-TO-SCRIPT/.scripts/pt2msql.php
Before you begin, ensure that you have a Grafana instance up and running.
Next add your mySQL data source:
Download and import the Guppy's Dashboard - GIT Version.json template into your Grafana installation.
If you are using the hosted version of Grafana, you will need to enable a remote user on your mySQL server installation. This user should only need SELECT access. Also ensure that your server can be accessed externally.
If done correctly, this should be the end result:
This content is provided free of charge so please don't get scammed into paying 3rd party fees. If you wish to donate to support the ongoing and development to date you may donate to either of the following addresses:
- BTC: 13QHePrFtKPY2axwRLVjEM6AjbbRvDSmP6
- ETH: 0x61a11050DC156CBA3ec49B81FC4F368FBd112059