Exercise

Working with datatables in Quandl

In the previous exercises you used your Quandl skills to pull in time-series data. In this exercise you will learn how to make a call from R to pull in a datatable (which is used for non-time-series data).

Quandl supports two data formats: time-series and "datatables". Make sure to look to each database’s documentation to determine which format it employs.

An example: To get all rows for ZACKX/FC where ticker is AAPL you just do Quandl.datatable("ZACKS/FC", ticker="AAPL"). If you only want specific columns you add qopts.columns="ticker" and this returns just the ticker for AAPL.

Instructions

100 XP
  • Retrieve all rows from ZACKS/FC for AAPL (Apple) and MSFT (Microsoft). Assign the result to datatable_all.
  • Do the same as in the previous instruction, but this time only return the ticker and per_end_date columns. Assign the result to datatable_columns.