Can I convert daily time-series to monthly observations using the Excel Add-In?
For time-series products, you can convert to lower frequencies in the Filters tab of the Quandl Formula Builder.
Alternatively, if you’d like to type it in manually, the structure of the Quandl formula is given below:
=QSERIES(quandlCode, dateRange, frequency, sortOrder, transformation, limit, headers, dates, transpose)
By specifying the frequency (“daily”, “weekly”, “monthly”, “quarterly”, or “annual”) as “monthly”, you will retrieve only monthly observations.
For more information on the Quandl Formula Builder, please see the following link: https://docs.quandl.com/docs/excel-time-series#section-download-data-with-the-quandl-formula-builder