Can I download percentage changes instead of raw data, using the Excel Add-In?
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:
Using the Nasdaq Data Link Formula BuilderTo return percentage changes by using the Nasdaq Data Link Formula Builder, please follow these steps:
- Open Excel
- Go to the Nasdaq Data Link 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.