In Excel, can I get historical data across the columns instead of down the rows?

Yes, you can transpose the data using the formula functions to have historical data across columns. Indicate "TRUE" in the appropriate part of the formula.

Example: Querying historical data across columns for the closing prices of 1 ticker (AAPL)
=QSERIES("WIKI/AAPL",,,,,,,,TRUE)
  1. Query the historical data for the closing prices of AAPL using the Formula Builder or by directly entering the Quandl formula.
  2. Add "TRUE" to the last part of the formula

Still need help? Contact Us Contact Us