Getting Started With The Tuned Power BI Template

Power BI is a Microsoft desktop software that runs on Windows. This software allows the end-user to visualize complex data sets.

Tuned has developed a Power BI Template to assist creators in understanding backtest, live, paper for Packs on single execution plus Batchtest results.

Power BI is free for personal use, and cloud services are available at additional cost. More information about Power BI can be found here: Power BI Website. 

Download Links:

Power BI Download Page 

Tuned Template: Tuned Power BI Dashboard V4.2 release

Getting Started:

1. Download and install Power BI (upgrade to the latest version if available).
2. Create a new folder where you will store the JSON files downloaded from Tuned. For example, 'C:\Users\<user>\Documents\TunedDownloads' — it is important that only the JSON files are stored here, any other files could cause the Power BI Template to create errors.
3. Download JSON file from Tuned and place it in the folder chosen above.
   1. Backtest, Papertrade or Live (pack or single execution)
      
   2. Due to the potential size of Batchtests, the downloaded JSON file will only include the runs which have been favourited.
      
4. Place all downloaded JSON files into your chosen directory and make sure not to rename any of the files.
5. Download the Tuned Power BI Template file and store it somewhere sensible.
6. Load Power BI by double-clicking on the template file.
7. Because this is a template file, you will be asked for the folder location — this is where you paste in the folder address for the JSON files and click load: e.g., 'C:\Users\user>\Documents\TunedDownloads' for this example
   
8. Power BI will spend some time loading the data and creating the visuals. Depending on the amount of data and the speed of your computer, this could take anywhere from just a few seconds up to ~1 minute. 
9. Once loaded, the dashboard will need to be saved (File → Save As). To avoid making the dashboard large and difficult to use, try using multiple files that look at different exchanges or markets.
10. When new JSON files are added to the folder or removed, you can refresh the dashboard by clicking refresh on the ribbon.
    

If there are any problems or errors, please raise them in the #bug-report Discord channel where someone will be able to support you.