Live data

With live data the chart obtains the data from an external resource data in JSON or CSV format. A refresh rate is set for updating the chart within a certain interval.

How to set up Live Data

To use the new live data option follow these steps:

Go to the Import Data step in the project wizard
Click on the Link data icon
Paste the Spreadsheet url from the address bar. Do not use the link in the Share dialogue, because this will not work. Then select the refresh time from the drop down menu
Click Connect my data

Make sure to set up your data properly

Setting up a public data file

You can use JSON Column and JSON Row, the difference is the data order. Some examples are listed below.

Creation of these files are normally done by a developer of a third-party service you wish to fetch data from, or a developer of your page who makes the data available, as these files are normally synchronized to a database of some sort. The method for publishing this file depends on the system you have in use. It is only important to serve the file as raw data, and make sure you have CORS enabled so that we can read data from your domain.

If need any help setting up a data file for live data, we are happy to discuss if you email us at support@everviz.com!

One quick way to test whether a given CSV file can be accepted, is to use pastebin.

JSON Columns

https://demo-live-data.highcharts.com/time-cols.json

[
    ['Column 1', 0, 1, 2, 3],
    ['Column 2', 10, 20, 30]
]

JSON Rows

https://demo-live-data.highcharts.com/time-rows.json

[
    ['Column 1', 'Column 2'],
    [0, 10],
    [1, 20],
    [2, 30],
    [3, 40]
]

CSV

https://demo-live-data.highcharts.com/time-data.csv

Column 1, Column 2
1,5
2,8
3,3
4,6
5,13
6,4
7,9
8,10
9,1
10,5

Polygon.io integration

We also have a Polygon.io integration. Read more about Polygon.io in our knowledge base