Can I specify whether I want ascending or descending date order when downloading historical data using the Excel Add-In?
When downloading data that is in time-series format, it is possible to specify ascending or descending date order by using the QSERIES formula or the Quandl Formula Builder. By default, the time-series data is downloaded in descending date order with the most recent dates at the top.
However, when downloading data that is in tables format, it is not possible to specify ascending or descending date order. For tables, we recommend downloading the data and filtering by the date column manually to change the order.
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 formulaNote that the structure of the QSERIES formula is as follows, with sortOrder as the fourth argument:
=QSERIES(quandlCode, dateRange, frequency, sortOrder, transformation, limit, headers, dates, transpose)
To return data in ascending order, put "asc" in the sortOrder argument, like this:
The above formula will return data from the XNAS/ACIW time-series in ascending order.
The sortOrder argument can be "desc" for descending or "asc" for ascending.
Using the Quandl Formula Builder
To return data in ascending order 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 Sort order, select Ascending from the drop down, like this:
- Enter any other desired filters and click Next. Follow the prompts to download the data.