Can I download percentage changes instead of raw data, using the Excel Add-In?

+When downloading data that is in time-series format, it is possible to download percentage changes by using the QSERIES formula or the Quandl Formula Builder

However, when downloading data that is in tables format, it is not possible to download percentage changes. For tables, we recommend downloading the raw data and carrying out the required transformation using your own analytics tool.

Note that data on Nasdaq Data Link comes in two formats:  time-series and tables. You can learn more about these formats here.

Using the QSERIES formula, note that the structure of the QSERIES formula is as follows, with transformation as the fifth argument:

=QSERIES(quandlCode, dateRange, frequency, sortOrder, transformation, limit, headers, dates, transpose)

To return percentage changes, put "rdiff" in the transformation argument, like this: 


The above formula will return row on row percentage changes for the XNAS/ACIW time-series. 

Please see here for other possible transformations for time-series data. 

Using the Quandl Formula BuilderTo return percentage changes by using the Quandl Formula Builder, please follow these steps:

  • Open Excel
  • Go to the Quandl tab and click Get Data

  • Search for the time-series data feed you want or enter the database code for the data feed you want. For example, enter XNAS for the NASDAQ Stock Market Prices, like this: 

  • Click Next and follow the prompts. When you reach the Filters stage and can filter by Transformation, select Row-on-row % change (rdiff) from the drop down, like this:

  • Enter any other desired filters and click Next. Follow the prompts download the data.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.