Saltar al contenido principal

Domo University Videos

Domo

Quandl Advanced Connector

Important: When referencing this page outside of Knowledge Base, use this link: http://knowledge.domo.com?cid=quandladvanced

Intro

Quandl is a search engine for numerical data. It indexes data from multiple sources allowing users to find and download in various formats. Use Domo’s Quandl Advanced connector to connect to the Quandl API and download DataSets. To learn more about the Quandl API, visit their website (https://www.quandl.com/help/api ).

Note: The user interface for building this connector is not yet available in our Connectors listing in the Data Center, meaning you will not be able to configure the connector on your own. However, we at Domo are more than happy to configure the connector for you so you can begin using it to pull your data into Domo. Please don't hesitate to reach out to your CSM or Domo Support. For contact information, see Getting Help.

You connect to your Quandl Advanced account in the Data Center. This topic discusses the fields and menus that are specific to the Quandl Advanced connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Primary Use Cases

Use this connector to retrieve stock quotes, currency rates, and economic performance indicator.

Primary Metrics

Stock price is a key metric, but since this is an aggregation site, there are many available metrics.

Primary Company Roles

  • CFO

  • Financial professional

  • Sales executive

Average Implementation Time

About 2 hours if codes are known, but could be up to 8 hours if you have to search for them.

Ease of Use (on a 1-to-10 scale with 1 being easiest)

7

Best Practices

  • Come DataSets are very specific and will return limited results, so several data pulls of specific information may need to be joined together.

  • The Quandl site aggregates data from numerous providers. There are free providers and pay providers. Access is permitted accordingly—whether payment has been made or if the DataSet is free.

  • Quandl utilizes a coding system to identify the data provider and specific data to pull (in the format yahoo/CPGX). Explore the available DataSets to identify the codes you need. 

Prerequisites

To connect to your Quandl account and create a DataSet, you must have a Quandl auth token. You can find this in your Account Settings after logging into Quandl.

Connecting to Your Quandl Account

This section enumerates the options in the Credentials and Details panes in the Quandl Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your Quandl account. The following table describes what is needed for each field:  

Field

Description

Auth Token Enter the auth token for your Quandl account.

Once you have entered valid Quandl credentials, you can use the same account any time you go to create a new Quandl DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select a Quandl report type. You can choose to retrieve your favorite DataSets or a specific DataSet, or you can search for a DataSet.

Favorite DataSets Returns a list of your favorite DataSets.
Specific DataSet Returns data for a specified DataSet.
Search DataSets Returns data for a specified search query.
Quandl Code

Enter the Quandl code for the DataSet you want to retrieve. For example, to retrieve the Google Finance DataSet for Apple, Inc., you would enter GOOG/NASDAQ_AAPL.

Each Quandl DataSet has a unique code made up of a database code and a table code. For example, the DataSet named "GDP of the United States" has the Quandl code FRED/GDP, where FRED is the database code and GDP is the table code. All DataSets from the same database have the same database code. However, table codes are not guaranteed to be unique across a database. SHFE/CUG2014 is not the same as MCX/2014. Both a database code and table code are required to fully identify a DataSet.

Duration Select whether you want to pull data for a specific date or a date range.
Report Date Select whether the report data is for a specific date or for a relative number of days back from today.
Specific Date Select the date for the report.
Date Offset Enter the number of past days that should appear in the report.
Date From Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in Date To.
Date To Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Date From.
Specific Date From Select the first date in your date range.
Specific Date To Select the second date in your date range.
Date From Offset

Enter the number of the farthest day back that should be represented in the report. Combine with Date To Offset to create a range of represented days.

For example, if you entered 10 for Date From Offset and 5 for Date To Offset, the report would contain data for 10 days ago up until 5 days ago. 

Date To Offset

Enter the number of the most recent day that should be represented in the report. Combine with Date From Offset to create a range of represented days.

For example, if you entered 10 for Date From Offset and 5 for Date To Offset, the report would contain data for 10 days ago up until 5 days ago.

Collapse Select the frequency (collapse) of the DataSet to be searched. Your report returns the last observation for the given period.
Transformation

Select a transformation (calculation) for the report data.
With data point for time t being denoted as y[t] and the data point for transformed data being denoted as y'[t], transformations are defined thusly:

Transformation Parameter Effect
Row-on-row change diff y'[t] = y[t] - y[t-1]
Row-on-row percentage change rdiff y'[t] = (y[t] - y[t-1])/y[t-1
Cumulative sum cumul y'[t] = y[t] + y[t-1] + ... + y[0]
Normalize normalize y'[t] = (y[t]/y[0] * 100
Note: For Normalize and Cumulative sum, y[0] in the above table refers to
the starting date, that is, the date specified by Start Date, not the starting
date of the entire DataSet.
Query Enter a search term to retrieve data for. For example, to return data about crude oil prices, you would enter "crude oil".
Required Action Select whether you want your report to return names or details of DataSets.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

Troubleshooting

Ensure that you have correct access rights to a DataSet. Generally free DataSets can be retrieved without limits. Paid DataSets are limited until payment is received.