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.
Until now, Intrinio had two primary access methods:
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.
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.