Introducing CSV Downloads for Intrinio Financial Data

Andrew Carpenter
March 6, 2017

It's now possible to query the Intrinio financial database via API and receive responses in CSV format. In other words, you can download Intrinio data in bulk to CSV and open it in Excel for further analysis.

This article explains why you might want this functionality and how you can use it.

Why would I want to download to CSV?

Until now, Intrinio had two primary access methods:

  • Excel add-in: A tool to pull data into Excel - when you refresh the sheet, the data updates automatically, saving time on data entry.
  • Web API: A method for developers to access data for use in their applications and automated analyses.

These tools work for most Intrinio users, but we have received more and more requests from users who want the ability to download a lot of data, a feature of the Web API, but also the ability to analyze that data in Excel, a feature of the Excel add-in.

Our solution for these users was to create a new access method, a file download that quickly outputs a CSV of the required data for analysis in Excel, R, or other tools meant to help analysts digest data with rows and columns.

The Excel add-in is a great tool for setting up analyses that refresh with new data, and the API is a great tool for building apps, but if you need to export a large amount of data to CSV for a static analysis, the file download functionality is just what the data doctor ordered.

How can I download to CSV?

The tutorial for the File Download access method shows how to use the CSV export functionality. This method is slightly more technical than just using the Excel add-in but significantly less technical than using the Web API. Here are some examples that will make it clear how this method works.

Here is an API call that returns the price history for Apple:

NOTE: The example below is for v1 of the Intrinio API. If you’re using API v2, follow the v2 documentation instead.

https://api.intrinio.com/prices?ticker=AAPL

Just add .csv to the call and you'll see a .csv file downloaded to your computer. That output is static, unlike the Excel add-in, but also easy for non-developers to download in bulk, unlike the Web API. If you're unfamiliar with how to build the syntax to download a CSV, you can find some examples in this article or via the file download tutorial. Just remember to add a ".csv" before the "?" in the syntax.

The basic idea is that you can paste a single piece of syntax, just like a formula in Excel, into your browser to get the data you need in a bulk download that you can open in Excel.

If you're new to Intrinio, request a consultation with our team to design your custom data solution.

Sorry, we no longer support Internet Explorer as a web browser.

Please download one of these alternatives and return for the full Intrinio Experience.

Google Chrome web browser icon
Chrome
Mozilla Firefox web browser icon
Firefox
Safari web browser icon
Safari
Microsoft Edge web browser icon
Microsoft Edge