{"id":5196,"date":"2020-10-29T18:00:36","date_gmt":"2020-10-29T18:00:36","guid":{"rendered":"http:\/\/algotrading101.com\/learn\/?p=5196"},"modified":"2021-05-14T13:23:27","modified_gmt":"2021-05-14T13:23:27","slug":"quandl-guide","status":"publish","type":"post","link":"https:\/\/algotrading101.com\/learn\/quandl-guide\/","title":{"rendered":"Quandl: A Step-by-Step Guide"},"content":{"rendered":"<div class=\"pvc_clear\"><\/div><p id=\"pvc_stats_5196\" class=\"pvc_stats total_only  \" data-element-id=\"5196\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/algotrading101.com\/learn\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p><div class=\"pvc_clear\"><\/div>\n<h3 class=\"wp-block-heading\"><strong>Table of Contents<\/strong><\/h3>\n\n\n\n<ol><li><a href=\"#what-is-quandl\">What is Quandl?<\/a><\/li><li><a href=\"#what-is-quandl-data-structure\">What is Quandl&#8217;s Data Structure?<\/a><\/li><li><a href=\"#what-are-the-pros-and-cons-of-quandl\">What are the Pros and Cons of Quandl?<\/a><\/li><li><a href=\"#is-quandl-free\">Is Quandl Free?<\/a><\/li><li><a href=\"#free-vs-premium-products\">Free VS Premium Products<\/a><\/li><li><a href=\"#what-are-the-types-of-free-data-in-quandl\">What are the types of Free Data in Quandl?<\/a><\/li><li><a href=\"#what-are-the-types-of-paid-data-in-quandl\">What are the types of Paid Data in Quandl?<\/a><\/li><li><a href=\"#how-to-create-an-account-in-quandl\">How to create an account in Quandl?<\/a><\/li><li><a href=\"#how-to-access-quandl-data\">How to access Quandl Data?<\/a><\/li><li><a href=\"#how-to-extract-quandl-data-in-excel\">How to extract Quandl Data in Excel?<\/a><\/li><li><a href=\"#example-of-quandl-usage-in-excel\">Example of Quandl usage in Excel<\/a><\/li><li><a href=\"#how-to-extract-quandl-data-in-python\">How to extract Quandl data in Python?<\/a><ul><li><a href=\"#quandl-wti-crude-oil-data\">Example 1: WTI Crude Oil prices<\/a><\/li><li><a href=\"#quandl-us-gdp-data\">Example 2: US GDP&nbsp;Data<\/a><\/li><li><a href=\"#quandl-facebook-annual-report-data\">Example 3: Facebook Annual Report&nbsp;Data<\/a><\/li><\/ul><\/li><li><a href=\"#quandl-in-other-programming-languages\">Quandl in other programming languages<\/a><\/li><li><a href=\"#what-are-the-limitations-for-quandl-downloads\">What are the limitations for Quandl downloads?<\/a><\/li><li><a href=\"#what-are-some-quandl-alternatives\">What are some Quandl alternatives?<\/a><\/li><li><a href=\"#more-on-quandl-background\">More on Quandl&#8217;s background<\/a><\/li><li><a href=\"#download-code-quandl-guide\">Download code<\/a><\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/quandl-guide.png\" alt=\"Quandl Logo\" class=\"wp-image-5974\" srcset=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/quandl-guide.png 1024w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/quandl-guide-300x150.png 300w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/quandl-guide-768x384.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<a name=\"what-is-quandl\">\n\n\n\n<h2 class=\"wp-block-heading\">What is Quandl?<\/h2>\n\n\n\n<p>Quandl is a platform that provides its users with economic, financial and alternative datasets. <\/p>\n\n\n\n<p>Users can download free data, buy paid data or sell data to Quandl.<\/p>\n\n\n\n<p>In this guide, we will cover how to extract data using Excel and Python (separately).<\/p>\n\n\n\n<a name=\"what-is-quandl-data-structure\">\n\n\n\n<h2 class=\"wp-block-heading\">What is Quandl&#8217;s Data Structure?<\/h2>\n\n\n\n<p>Quandl&#8217;s data comes in two formats: the first one being Time-series and the second one being Tables. <\/p>\n\n\n\n<p>Have in mind that some datasets can be shown in both formats.<\/p>\n\n\n\n<p><strong>Time-series<\/strong><\/p>\n\n\n\n<p>Time-series data refer to data taken over a period of time.<\/p>\n\n\n\n<p>Time-series are commonly displayed using line graphs, where the X-axis represents dates and the Y-axis represents other numeric observations.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"782\" src=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-time-series-data-1024x782.png\" alt=\"\" class=\"wp-image-5976\" srcset=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-time-series-data-1024x782.png 1024w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-time-series-data-300x229.png 300w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-time-series-data-768x587.png 768w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-time-series-data-1536x1173.png 1536w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-time-series-data.png 1597w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Example Quandl time series data<\/figcaption><\/figure>\n\n\n\n<p>The Time-series format only contains numerical data which is indexed by one date field. This means that the data is sorted by dates. This allows users to retrieve the entire time-series or a particular part of it, also called a \u201cslice\u201d.<\/p>\n\n\n\n<p>Most Quandl datasets are stored in the Time-series format as financial data mostly consist of dates and observations which fit the format nicely.<\/p>\n\n\n\n<p><strong>Table format<\/strong><\/p>\n\n\n\n<p>Tables don\u2019t only contain numerical values. <\/p>\n\n\n\n<p>They can contain various unsorted data types such as strings, numbers, dates, etc. They can also be filtered into different fields.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"826\" src=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-table-data-1024x826.png\" alt=\"\" class=\"wp-image-5977\" srcset=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-table-data-1024x826.png 1024w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-table-data-300x242.png 300w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-table-data-768x619.png 768w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/10\/quandl-table-data.png 1137w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Example chart of Quandl table data<\/figcaption><\/figure>\n\n\n\n<p><strong>Quandl ID code<\/strong><\/p>\n\n\n\n<p>Each feed of data has a short ID, also known as a Quandl code.<\/p>\n\n\n\n<p>For example:<\/p>\n\n\n\n<ul><li>Federal Reserve Economic Data (time-series): FRED<\/li><li>Core US Fundamentals (tables): SF1<\/li><\/ul>\n\n\n\n<p>Time-series data such as FRED is built-up of a large number of individual time-series where each of them has its own Quandl code appended to the main Quandl code, for example: US civilian unemployment rate:&nbsp; FRED\/UNRATE.<\/p>\n\n\n\n<p>On the other hand, Tables data such as SF1 contain one or more tables where each of them has its own Quandl code, for example:&nbsp; The Quandl code for the Core US Fundamentals table is SHARADAR\/SF1.<\/p>\n\n\n\n<p>When it comes to Data Analysis tools, Quandl directly supports API, R, Python, Excel, Ruby and more.<\/p>\n\n\n\n<p>The full list can be found here: <a href=\"https:\/\/www.quandl.com\/tools\/full-list\">https:\/\/www.quandl.com\/tools\/full-list<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What are the Pros and Cons of Quandl?<\/h2>\n\n\n\n<a name=\"what-are-the-pros-and-cons-of-quandl\">\n\n\n\n<p><strong>The Pros:<\/strong><\/p>\n\n\n\n<ul><li>Quandl offers an enormous collection of data (over 20 million datasets).<\/li><li>All datasets are available for instantaneous download in any preferred format.<\/li><li>All datasets on Quandl are available through the same API, irrespective of who originally published the data or in what format.<\/li><li>Data is transparent.<\/li><li>Datasets are easy to find and clean.<\/li><li>Some parts of Quandl is free and open for everyone.<\/li><li>New data is added weekly.<\/li><li>Quandl can be used in many programs (Excel, Python, R, Ruby, MATLAB\u2026)<\/li><li>You can use Quandl to sell your data.<\/li><\/ul>\n\n\n\n<p><strong>The Cons:<\/strong><\/p>\n\n\n\n<ul><li>Many of the more exotic datasets are not free.<\/li><li>They offer limited amounts of help when constructing analyses or discovering information.<\/li><li>Not too beginner friendly.<\/li><li>They don\u2019t have real-time or delayed stock price data.<\/li><li>They don\u2019t have a master security list.<\/li><\/ul>\n\n\n\n<div style=\"padding:15px 15px 15px 15px;color: #555555;background-color: #E1FFC1;border: #dddddd 2px solid\">\n<p>\u00bb You can use the downloaded data to find suitable assets for Pairs Trading. \n<br><br>Alternatively, learn how to find assets for Pairs Trading without writing a line of code.  \n<br><br>\nLink: <a href=\"https:\/\/algotrading101.com\/learn\/pairs-trading-guide\/\" rel=\"noopener noreferrer\">Pairs Trading \u2013 A Real-World Guide<\/a> \n<\/p>\n<\/div>\n<br>\n\n\n\n<a name=\"is-quandl-free\">\n\n\n\n<h2 class=\"wp-block-heading\">Is Quandl Free?<\/h2>\n\n\n\n<p>Quandl offers both free and premium products. <\/p>\n\n\n\n<p>The Quandl API is free to use and grants access to all free datasets. <\/p>\n\n\n\n<p>Quandl users have to pay to access Quandl&#8217;s premium data products.<\/p>\n\n\n\n<a name=\"free-vs-premium-products\">\n\n\n\n<h2 class=\"wp-block-heading\">What are the differences between Free and Premium datasets?<\/h2>\n\n\n\n<p>As the devil is in the details, their free products come from various \u201ccredible and established\u201d sources such as central banks, government agencies, organizations, etc. <\/p>\n\n\n\n<p>On the other hand, their premium products come from data providers such as: AlgoSeek, Applied Research, Barchart, Brave New Coin, and CryptoCompare etc.<\/p>\n\n\n\n<p>The full list can be seen here: <a href=\"https:\/\/www.quandl.com\/publishers\">https:\/\/www.quandl.com\/publishers<\/a><\/p>\n\n\n\n<p>Quandl premium datasets have a regular update time while there are no guaranteed update times for free datasets and they can usually take anywhere from a few hours to weeks, months or years (depending on the data itself).<\/p>\n\n\n\n<p>Quandl\u2019s premium data is curated and maintained by professional providers with decades of expertise under their belts. This all adds on the betterment of documentation, correctness, organization, uniqueness and structure of the data. Here we can see the supremacy of the premium data.<\/p>\n\n\n\n<p>Premium data on Quandl can be purchased via subscriptions. With them you subscribe only to particular datasets that you need. This means that you only pay for what you need. Have in mind that there is no fee to use the platform itself or Quandl\u2019s open data feeds.<\/p>\n\n\n\n<p>Almost all premium datasets come with some free sample data. To see a free sample data, you need to log in to your Quandl account. After clicking on any premium data feed of your interest, the website will take you to the home page of that feed where you will be presented with some sample data.<\/p>\n\n\n\n<p>It needs to be mentioned that every single free data feed has a transparent link that leads to its source. This means that we can verify the data and the source it comes from.<\/p>\n\n\n\n<a name=\"what-are-the-types-of-free-data-in-quandl\">\n\n\n\n<h2 class=\"wp-block-heading\">What are the types of Free Data in Quandl?<\/h2>\n\n\n\n<p>When it comes to free data, Quandl offers you a massive range from Prices &amp; Volume, Fundamentals, Sentiment, Derived Metrics, National Statistics, and Other.<\/p>\n\n\n\n<p>Let\u2019s mention some of the free datasets:<\/p>\n\n\n\n<ul><li>Wiki Continuous Futures \u2013 This dataset is built on top of raw data from ICE, CME, LIFFE, etc, and is curated by the Quandl community.<\/li><li>Zillow Real Estate Data \u2013 This dataset is the leading real estate and rental marketplace.<\/li><li>Federal Reserve Economic Data \u2013 This dataset includes things such as growth, employment, inflation, labor, manufacturing and many more US economic data.<\/li><\/ul>\n\n\n\n<a name=\"what-are-the-types-of-paid-data-in-quandl\">\n\n\n\n<h2 class=\"wp-block-heading\">What are the types of Paid Data in Quandl?<\/h2>\n\n\n\n<p>When it comes to premium data, Quandl offers datasets related to Estimates, Corporate Actions, Alternative Data, Technical Analysis and more.<\/p>\n\n\n\n<p>Let\u2019s mention some of the premium datasets:<\/p>\n\n\n\n<ul><li>Zacks Sales Estimates \u2013 This dataset has a consensus of sale estimates for over 4k US and Canadian listed companies.<\/li><li>Nasdaq Dorsey Technical Analysis Data \u2013 This dataset is made up of 50+ technical indicators and chart information for over 49k global equities, mutual funds and ETFs.<\/li><li>Sharadar Core US Equities and Fund Prices \u2013 This dataset is self-explanatory.<\/li><\/ul>\n\n\n\n<a name=\"how-to-create-an-account-in-quandl\">\n\n\n\n<h2 class=\"wp-block-heading\">How to create an account in Quandl?<\/h2>\n\n\n\n<p>Having a Quandl account is important as it allows you to:<\/p>\n\n\n\n<ul><li style=\"text-align: justify\">Access their API, libraries and tools.<\/li><li style=\"text-align: justify\">Download free and\/or premium data in any format.<\/li><li style=\"text-align: justify\">Access their export and visualization tools.<\/li><li style=\"text-align: justify\">View relevant information about pricing and licensing for their premium data.<\/li><\/ul>\n\n\n\n<p>Let\u2019s get you started with your Quandl account. Have in mind that it is free and doesn\u2019t require any credit card information.<\/p>\n\n\n\n<p>Let\u2019s go over the steps:<\/p>\n\n\n\n<ol><li>Go over to the Quandl website (<a href=\"https:\/\/www.quandl.com\/\">https:\/\/www.quandl.com\/<\/a>) and click on the sign up button in the top right corner.<\/li><li>A screen will open that requires your first and last name, as well as your purpose of using Quandl (business, academic or personal). So feel free to input those fields. After that, click on \u201cNext\u201d.<\/li><li>Now, another screen will appear where you will input your email address and answer a question on \u201cHow will you be using this data?\u201d After that, click on \u201cNext\u201d.<\/li><li>The final screen of your signing up process will appear where you will be asked to create a password. After you have created your password and checked the terms of service box, click on \u201cCreate Account\u201d.<\/li><li>Now, a welcome screen will appear with your API key.<\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"394\" height=\"355\" src=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/ada.png\" alt=\"\" class=\"wp-image-5233\" srcset=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/ada.png 394w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/ada-300x270.png 300w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/><\/figure><\/div>\n\n\n\n<p>Wait Igor, what in the world is this API key?! You didn\u2019t prepare us for that!<\/p>\n\n\n\n<p>Calm down, be sure to copy your key and don\u2019t forget to verify your email address. If you pressed \u201cContinue\u201d without copying the API key, it\u2019s not an issue. You can find your key in the Account Details section.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"245\" src=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/Capture-1024x245.png\" alt=\"\" class=\"wp-image-5234\" srcset=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/Capture-1024x245.png 1024w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/Capture-300x72.png 300w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/Capture-768x184.png 768w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/Capture.png 1113w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>Now let\u2019s explain what an API key is!<\/p>\n\n\n\n<p>API key stands for the Application Programming Interface key and is represented as a string of code that gets passed in by a computer to an application. The program or application then uses the API key to identify the user to a website.<\/p>\n\n\n\n<p>The API key is a \u201csecret\u201d authentication token as well as a unique identifier.<\/p>\n\n\n\n<p>Think of it as your personal secret &#8220;password&#8221; for collecting data from Quandl.<\/p>\n\n\n\n<a name=\"how-to-access-quandl-data\">\n\n\n\n<h2 class=\"wp-block-heading\">How to access Quandl Data?<\/h2>\n\n\n\n<p>The data can be accessed using Excel, Python, R, MATLAB, Ruby and more. <\/p>\n\n\n\n<p>We will cover the Excel and Python methods in this article.<\/p>\n\n\n\n<a name=\"how-to-extract-quandl-data-in-excel\">\n\n\n\n<h2 class=\"wp-block-heading\">How to extract Quandl Data in Excel?<\/h2>\n\n\n\n<p>When it comes to Excel, you can pull Quandl datasets in a matter of minutes without any programming skills required.<\/p>\n\n\n\n<p>It\u2019s time for us to see Quandl in action. But first, we need to set up the Quandl Plugin for Excel.<\/p>\n\n\n\n<p>Let\u2019s do the steps together:<\/p>\n\n\n\n<ol><li>Go to this link (<a href=\"https:\/\/www.quandl.com\/tools\/excel\">https:\/\/www.quandl.com\/tools\/excel<\/a>) and click the blue \u201cDownload\u201d button.<\/li><li>Now, click on the downloaded \u201cQuandl Excel Addin\u201d and follow the installation steps.<\/li><li>After the installation, open up your Excel program and click on the newly appeared \u201cQuandl\u201d in your toolbar.<\/li><li>After that, click on the settings button and insert your API key in the newly opened window and click save (as shown in the picture below)<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/API.png\" alt=\"\"\/><\/figure>\n\n\n\n<a name=\"example-of-quandl-usage-in-excel\">\n\n\n\n<h2 class=\"wp-block-heading\">Example of Quandl usage in Excel<\/h2>\n\n\n\n<ol><li>Let\u2019s get our <b>Database<\/b>. Press the \u201cGet Data\u201d button inside of your Quandl toolbar.<\/li><li>After your API key gets verified (remember that?), we\u2019ll select our <b>Data<\/b>. For this example, I\u2019ll pick the European Stock Prices for FSE Frankfurt Stock Exchange.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/2.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>3.&nbsp;Click the blue \u201cNext\u201d button and select your preferred stock. I\u2019ll use the Zooplus (ZO1_X). Click \u201cNext\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/3.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>4. After that, a new window will open that will ask you to specify what <b>Columns<\/b> will your dataset have. I selected the Date, Open, High, Low and Close columns. Click \u201cNext\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/4.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>5.&nbsp;Now, we\u2019ll select the filters that we want for our data. As I<br>don\u2019t want to make the steps too complicated, I won\u2019t apply any filters.&nbsp;<\/p>\n\n\n\n<p>6.&nbsp;After clicking the \u201cNext\u201d button, you are given a <b style=\"color: black;font-size: 14pt;text-align: justify\">Placement <\/b>option aka where do you want your data to be placed at in your Excel sheet. When you specify your Excel Sheet and Cell, click the \u201cInsert\u201d button.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/6.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>7.&nbsp;Voil\u00e0! Your data is ready! If it didn\u2019t appear for you, don\u2019t panic! Just press the \u201cRefresh Sheet\u201d button that is found in your Quandl toolbar.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/7.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>For the next example, the steps are the same but the dataset will be different. I\u2019ll show you a Corporate Annual Report data for the Facebook Inc. dataset:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/ANNUAL.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>The next example will be different. We\u2019ll use the Quandl \u201cFormulas\u201d option to code what we need and want.<\/p>\n\n\n\n<p>Let\u2019s follow the steps:<\/p>\n\n\n\n<p>1. Let\u2019s suppose that we want to download the daily closing prices for two assets in the last 3 days (as shown in the picture). First we need to specify that we want the closing prices by writing the following string (=\u2019your cell\u2019&amp;\u201d\/CLOSE\u201d) in our formula Excel section. Be sure to do this for both assets. You can simply drag the cell with the written code to the other cell.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/excel1.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>2. Now, let\u2019s add our Start and End dates. For this I\u2019ll use the \u201ctoday()\u201d formula in Excel. For the Start date we will write \u201ctoday()-3\u201d which means past 3 days and for the End date we will just use \u201ctoday()\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/excela.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>3.&nbsp;This step requires us to use the \u201cqseries\u201d formula which, in our example, looks like this \u201c=QSERIES(D2:E2,B1:B2)\u201d As you can see, the D2:E2 specifies our asset filter and the B1:B2 part specifies our Start and End date. After the formula is written, refresh the sheet as we did in our past example, and you\u2019re done.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/escellll.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/excel3.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>If you want to change stuff up, and look at the data for the past 3 years, in the Start date field write \u201c=today()-365*3\u201d. Be sure to play with Quandl so you get a hang of it!<\/p>\n\n\n\n<a name=\"how-to-extract-quandl-data-in-python\">\n\n\n\n<h2 class=\"wp-block-heading\">How to extract Quandl data in Python?<\/h2>\n\n\n\n<p>For this part, I\u2019ll be using the Jupyter Notebook from the Anaconda application for Data Science.<\/p>\n\n\n\n<p>More info on how to set up your Jupyter Notebook: <a href=\"https:\/\/course.algotrading101.com\/courses\/pt101-practical-python-for-finance-trading-masterclass\/lectures\/8476257\">Preparing Your Python Coding Environment<\/a><\/p>\n\n\n\n<p>Firstly, we need to install the Quandl package for Python. For this, use the command \u201cpip install quandl\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/py1.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Let\u2019s show a few examples:<\/p>\n\n\n\n<a name=\"quandl-wti-crude-oil-data\">\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 1: WTI Crude Oil price<\/strong>s<\/h4>\n\n\n\n<p>For this example, we want to get the WTI Crude Oil price from the United States department of Energy:<\/p>\n\n\n\n<p>1. We need to import all the packages we\u2019re going to use. For this example, I\u2019ll import Quandl, NumPy and Pandas. Note that you need to have NumPy and Pandas installed. They come pre-installed with the Anaconda program and the codes go like this: \u201cpip install NumPy\u201d and \u201cpip install Pandas\u201d.<\/p>\n\n\n\n<p>2. After that, we need to activate our API key. Use the following command: quandl.ApiConfig.api_key = &#8220;YOUR_API_KEY&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"70\" src=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/afafaf.png\" alt=\"\" class=\"wp-image-5236\" srcset=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/afafaf.png 771w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/afafaf-300x27.png 300w, https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/afafaf-768x70.png 768w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p>3. The next step is to use the following command \u201cmydata = quandl.get(&#8220;EIA\/PET_RWTC_D&#8221;)\u201d. <\/p>\n\n\n\n<p>It is of utmost importance to know the Quandl code (&#8220;EIA\/PET_RWTC_D&#8221;) of each dataset you want to use. <\/p>\n\n\n\n<p>You can find the Quandl code for each dataset under the documentation page of each dataset. Example: <a href=\"https:\/\/www.quandl.com\/data\/EIA-U-S-Energy-Information-Administration-Data\/documentation\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.quandl.com\/data\/EIA-U-S-Energy-Information-Administration-Data\/documentation<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/pyp.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>If you want to get the same data, but as a NumPy array, you can use this code: mydata = quandl.get(&#8220;EIA\/PET_RWTC_D&#8221;, returns=&#8221;numpy&#8221;)<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/py3.png\" alt=\"\"\/><\/figure>\n\n\n\n<a name=\"quandl-us-gdp-data\">\n\n\n\n<h4 class=\"wp-block-heading\"><strong><strong>Example 2: US GDP<\/strong><\/strong> Data<\/h4>\n\n\n\n<p>For our next example, let\u2019s download a piece of macroeconomic data with specific dates and save it as a .csv file.<\/p>\n\n\n\n<p><strong>Downloading data from a specific date range in Quandl<\/strong><\/p>\n\n\n\n<a name=\"downloading-data-from-a-specific-date-range-in-quandl\">\n\n\n\n<p>1. In order to set specific Start and End dates, we shall write the following: mydata = quandl.get(&#8220;FRED\/GDP&#8221;, start_date=&#8221;2019-12-31&#8243;, end_date=&#8221;2020-9-26&#8243;)<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/py4.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>2. This is where Pandas come into play, as we want to save our extracted data to a .csv aka Excel format. <\/p>\n\n\n\n<p>We will convert our data into a Pandas DataFrame using the following command: \u201cdf = pd.DataFrame(mydata, columns= [&#8216;Date&#8217;,&#8217;Value&#8217;])\u201d<\/p>\n\n\n\n<p>3. After that, we will export our data and give the .csv file a name: \u201cdf.to_csv (&#8216;Name.csv&#8217;)\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/py6.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/py5.png\" alt=\"\"\/><\/figure>\n\n\n\n<a name=\"quandl-facebook-annual-report-data\">\n\n\n\n<h4 class=\"wp-block-heading\"><strong><strong>Example 3: Facebook Annual Report<\/strong><\/strong> Data<\/h4>\n\n\n\n<p>Let\u2019s download a Corporate Annual Report for Facebook. The steps are the same as in our first Python example, but with a little twist. Our Quandl code for this one is \u201cWIKI\/FB\u201d. <\/p>\n\n\n\n<p>We specify the years we want to go through and get the data we\u2019ll need to preprocess it. This means that we need to extract only the annual part of it.<\/p>\n\n\n\n<p>For this, we shall use the following command: <em>mydata = quandl.get(&#8220;WIKI\/FB&#8221;, collapse=&#8221;annual&#8221;)<\/em><\/p>\n\n\n\n<p>Now our data looks like this:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/pyannual-1024x692.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Now you are all equipped to go on a Quandl coding journey in Python!<\/p>\n\n\n\n<p><em><strong>\u201cMay the code be with you!\u201d \u2013 Obi Wan Kenobi<\/strong><\/em><\/p>\n\n\n\n<a name=\"quandl-in-other-programming-languages\">\n\n\n\n<h2 class=\"wp-block-heading\">Quandl in other programming languages<\/h2>\n\n\n\n<p>Quandl is also equipped for other programming languages like R, MATLAB, Ruby and others. <\/p>\n\n\n\n<p>In this article, we won\u2019t go into them as it would make it too long. But R, Ruby and MATLAB enthusiasts worry not, as I\u2019ll provide you with useful links where you can learn how to use Quandl in your programs!<\/p>\n\n\n\n<p>R &#8211; <a href=\"https:\/\/www.quandl.com\/tools\/r\">https:\/\/www.quandl.com\/tools\/r<\/a><\/p>\n\n\n\n<p>Ruby &#8211; <a href=\"https:\/\/github.com\/quandl\/quandl-ruby\">https:\/\/github.com\/quandl\/quandl-ruby<\/a><\/p>\n\n\n\n<p>MATLAB &#8211; <a href=\"https:\/\/github.com\/quandl\/Matlab\">https:\/\/github.com\/quandl\/Matlab<\/a><\/p>\n\n\n\n<a name=\"what-are-the-limitations-for-quandl-downloads\">\n\n\n\n<h2 class=\"wp-block-heading\">What are the limitations for Quandl downloads?<\/h2>\n\n\n\n<p>Quandl needs to limit their users when it comes to downloading so the API doesn\u2019t get over flooded and the whole service crashing down.<\/p>\n\n\n\n<p>Anonymous users are limited to 20 calls per 10 minutes and 50 calls per day; while authenticated users have a limit of 300 calls per 10 seconds, 2k calls per 10 minutes and 50k calls per day.<\/p>\n\n\n\n<p>When it comes to the free authenticated users, they have a concurrency limit of one which means that they can only make one call at a time and have an additional call waiting in the queue.<\/p>\n\n\n\n<p>As for the premium users, they have a limit of 5k calls per 10 minutes and a limit of 720k calls per day. They are also limited to 10 bulk downloads per hour.<\/p>\n\n\n\n<a name=\"what-are-some-quandl-alternatives\">\n\n\n\n<h2 class=\"wp-block-heading\">What are some Quandl alternatives?<\/h2>\n\n\n\n<p>When it comes to price and corporate fundamentals, there are the following: Yahoo finance, IEX, Alpha Vantage, Polygon, TradingView\u2026<\/p>\n\n\n\n<p>More info: <a href=\"https:\/\/algotrading101.com\/learn\/google-finance-api-guide\/\">Google Finance API and 9 Alternatives<\/a><\/p>\n\n\n\n<p>When it comes to Alternative data, there are the following: M Science, Advan, Thinknum, YipitData, Tegus, Arch Metrics and many more.<\/p>\n\n\n\n<p>Here is the full list &#8211; <a href=\"https:\/\/alternativedata.org\/data-providers\/\">https:\/\/alternativedata.org\/data-providers\/<\/a><\/p>\n\n\n\n<a name=\"more-on-quandl-background\">\n\n\n\n<h2 class=\"wp-block-heading\">More on Quandl&#8217;s background<\/h2>\n\n\n\n<p>According to Quandl, they have over 400,000 users. These ranges from the world\u2019s top hedge funds to investment banks and various asset managers.<\/p>\n\n\n\n<p>Quandl\u2019s specialization is in the field of data that gets collected over time and is categorized as economic, social and financial data &#8211; this includes things like: stock prices, crime rates, unemployment rates, various populations, etc.<\/p>\n\n\n\n<p>They manage to do this by indexing millions of numerical datasets from around the internet. For example, if you click on a specific dataset that is indexed in Quandl, it will go to its original dataset source, extract the newest version of it, clean it, and give it back to you in whatever form you want.<\/p>\n\n\n\n<p>Quandl is striving for the democratization of data and making it easier to find and use for all its users. Their goal is to provide their service to various types of users and professions.<\/p>\n\n\n\n<p>Can you believe that they even offer data pertained to some basic sport statistics?!<\/p>\n\n\n\n<p>Ok Igor, that all sounds sweet, but how does Quandl acquire data?<\/p>\n\n\n\n<p>Well, Quandl acquires its data by having various human curators that point their bots at specific datasets. Recently, they\u2019ve been looking for more curators that are similar to Wikipedia\u2019s volunteer editors.<\/p>\n\n\n\n<p>You can also become a vendor and sell your data to Quandl. For this, the technical requirements aren\u2019t strict but you need to create, document and maintain the data yourself with a \u201cprofessional standard of quality\u201d.<\/p>\n\n\n\n<p>The good thing is that the listing of your data to Quandl doesn\u2019t come with any fees. You also get support from the Quandl team for free and your data is viewed as your intellectual property.<\/p>\n\n\n\n<p>As a Quandl vendor, you have full transparency of who\u2019s buying\/accessing your data. You are also provided with a vendor dashboard that shows you all the sales, subscribers, revenues and other information in real-time.<\/p>\n\n\n\n<a name=\"download-code-quandl-guide\">\n\n\n\n<h2 class=\"wp-block-heading\">Download Code<\/h2>\n\n\n\n<p>Download the Python code used: <a href=\"https:\/\/github.com\/Lucas170\/Quandl-Guide-AlgoTrading101\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/Lucas170\/Quandl-Guide-AlgoTrading101<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5196\" class=\"pvc_stats total_only  \" data-element-id=\"5196\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/algotrading101.com\/learn\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p>Table of Contents What is Quandl? What is Quandl&#8217;s Data Structure? What are the Pros and Cons of Quandl? Is Quandl Free? Free VS Premium Products What are the types of Free Data in Quandl? What are the types of Paid Data in Quandl? How to create an account in Quandl? How to access Quandl [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":5974,"comment_status":"closed","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"no","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[2],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Quandl: A Step-by-Step Guide - AlgoTrading101 Blog<\/title>\n<meta name=\"description\" content=\"Quandl is a platform that provides its users with economic, financial and alternative datasets. The data can be accessed using Excel, Python, R, MATLAB, Ruby and more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/algotrading101.com\/learn\/quandl-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Quandl: A Step-by-Step Guide - AlgoTrading101 Blog\" \/>\n<meta property=\"og:description\" content=\"Quandl is a platform that provides its users with economic, financial and alternative datasets. The data can be accessed using Excel, Python, R, MATLAB, Ruby and more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/algotrading101.com\/learn\/quandl-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Quantitative Trading Ideas and Guides - AlgoTrading101 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-29T18:00:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-14T13:23:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/quandl-guide.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Igor Radovanovic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Igor Radovanovic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Quandl: A Step-by-Step Guide - AlgoTrading101 Blog","description":"Quandl is a platform that provides its users with economic, financial and alternative datasets. The data can be accessed using Excel, Python, R, MATLAB, Ruby and more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/algotrading101.com\/learn\/quandl-guide\/","og_locale":"en_US","og_type":"article","og_title":"Quandl: A Step-by-Step Guide - AlgoTrading101 Blog","og_description":"Quandl is a platform that provides its users with economic, financial and alternative datasets. The data can be accessed using Excel, Python, R, MATLAB, Ruby and more.","og_url":"https:\/\/algotrading101.com\/learn\/quandl-guide\/","og_site_name":"Quantitative Trading Ideas and Guides - AlgoTrading101 Blog","article_published_time":"2020-10-29T18:00:36+00:00","article_modified_time":"2021-05-14T13:23:27+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/09\/quandl-guide.png","type":"image\/png"}],"author":"Igor Radovanovic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Igor Radovanovic","Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/algotrading101.com\/learn\/quandl-guide\/#article","isPartOf":{"@id":"https:\/\/algotrading101.com\/learn\/quandl-guide\/"},"author":{"name":"Igor Radovanovic","@id":"https:\/\/algotrading101.com\/learn\/#\/schema\/person\/a7ae60c112a73b7c3fe14ac56726a0ae"},"headline":"Quandl: A Step-by-Step Guide","datePublished":"2020-10-29T18:00:36+00:00","dateModified":"2021-05-14T13:23:27+00:00","mainEntityOfPage":{"@id":"https:\/\/algotrading101.com\/learn\/quandl-guide\/"},"wordCount":3229,"publisher":{"@id":"https:\/\/algotrading101.com\/learn\/#organization"},"articleSection":["Trading"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/algotrading101.com\/learn\/quandl-guide\/","url":"https:\/\/algotrading101.com\/learn\/quandl-guide\/","name":"Quandl: A Step-by-Step Guide - AlgoTrading101 Blog","isPartOf":{"@id":"https:\/\/algotrading101.com\/learn\/#website"},"datePublished":"2020-10-29T18:00:36+00:00","dateModified":"2021-05-14T13:23:27+00:00","description":"Quandl is a platform that provides its users with economic, financial and alternative datasets. The data can be accessed using Excel, Python, R, MATLAB, Ruby and more.","breadcrumb":{"@id":"https:\/\/algotrading101.com\/learn\/quandl-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/algotrading101.com\/learn\/quandl-guide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/algotrading101.com\/learn\/quandl-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/algotrading101.com\/learn\/"},{"@type":"ListItem","position":2,"name":"Quandl: A Step-by-Step Guide"}]},{"@type":"WebSite","@id":"https:\/\/algotrading101.com\/learn\/#website","url":"https:\/\/algotrading101.com\/learn\/","name":"Quantitative Trading Ideas and Guides - AlgoTrading101 Blog","description":"Authentic Stories about Algorithmic trading, coding and life.","publisher":{"@id":"https:\/\/algotrading101.com\/learn\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/algotrading101.com\/learn\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/algotrading101.com\/learn\/#organization","name":"AlgoTrading101","url":"https:\/\/algotrading101.com\/learn\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/algotrading101.com\/learn\/#\/schema\/logo\/image\/","url":"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/11\/AlgoTrading101-Lucas-Liew.jpg","contentUrl":"https:\/\/algotrading101.com\/learn\/wp-content\/uploads\/2020\/11\/AlgoTrading101-Lucas-Liew.jpg","width":1200,"height":627,"caption":"AlgoTrading101"},"image":{"@id":"https:\/\/algotrading101.com\/learn\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/algotrading101.com\/learn\/#\/schema\/person\/a7ae60c112a73b7c3fe14ac56726a0ae","name":"Igor Radovanovic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/algotrading101.com\/learn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d46175c509b3ee240a1e2bbe735a4d1e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d46175c509b3ee240a1e2bbe735a4d1e?s=96&d=mm&r=g","caption":"Igor Radovanovic"},"sameAs":["https:\/\/igorradovanovic.com","https:\/\/www.linkedin.com\/in\/igor-radovanovic-profile"],"url":"https:\/\/algotrading101.com\/learn\/author\/igor\/"}]}},"modified_by":"Lucas Liew","_links":{"self":[{"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/posts\/5196"}],"collection":[{"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/comments?post=5196"}],"version-history":[{"count":30,"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/posts\/5196\/revisions"}],"predecessor-version":[{"id":9360,"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/posts\/5196\/revisions\/9360"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/media\/5974"}],"wp:attachment":[{"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/media?parent=5196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/categories?post=5196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/algotrading101.com\/learn\/wp-json\/wp\/v2\/tags?post=5196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}