Apart from the ribbon commands, are there any cell-level spreadsheet functions available in the Excel Add-In?
Yes, there are cell-level functions available in 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 and authentication here.
The Excel Add-in only works with data that is delivered through the REST API for time-series or the REST API for tables.
Use the QSERIES formula when accessing data from a time-series. To learn more about using the QSERIES formula, please see here.
Use the QTABLE formula when accessing data from a table. To learn more about using the QTABLE formula, please see here.
For both the QSERIES and QTABLE formulas, you will need to know the product code of the data you wish to access. You can learn more about product codes here.