How can I create a data dashboard to find the performance of different stocks using the Excel Add-in?
Note that each data feed on Nasdaq Data Link is delivered through one of the following Nasdaq Data Link APIs:
- Streaming API for real-time data
- REST API for real-time or delayed data
- REST API for time-series
- REST API for tables
You can learn more about these APIs, data formats here.
The Excel add-in may only be used with data delivered through the REST API for time-series or tables.
To create a data dashboard to find the performance of different stocks, you first have to download and install the Excel Add-In package as per the instructions here.
Once the Excel Add-In is installed, we recommend watching this short tutorial to learn how to create a data dashboard to find the performance of 30 different stocks.
The above video downloads data that is in time-series format and uses the QSERIES formula. You can learn more about using the Excel Add-in with time-series data here.
To learn how to use the Excel Add-In with tables data, please see here.