In Excel, can I get historical data across the columns instead of down the rows?
However, when downloading data that is in tables format, it is not possible to get historical data across columns instead of down the rows. For tables, you would have to download the data and rearrange the data on your own after the data has been downloaded.
Note that data on Quandl 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 transpose as the ninth argument:
=QSERIES(quandlCode, dateRange, frequency, sortOrder, transformation, limit, headers, dates, transpose)
To return historical data across columns, put TRUE for the transpose argument, like this:
The above formula will return data across columns for the XNAS/ACIW time-series.
Using the Quandl Formula Builder
To download data across columns 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 data feed, like this:
- Click Next and follow the prompts. When you reach the Placement stage, check off "Show dates across columns" like this:
- Click Insert to download the data.