Intrinio's mission is to make financial data affordable and accessible so investors can save money and make time to build something meaningful. We have been hard at work on the "affordable" part of our mission, adding new data feeds to the marketplace so our users can access more data types in our pay-for-use model.
Now, we are excited to announce some serious progress on the "accessible" part of our mission. It is 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 four 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.
- Google Sheets add-on: A tool that inhances the functionality of Google Sheets allowing users to pull stock prices, finance statement data, and collaborate in the cloud
- REST API: A method for developers to access data for use in their applications and automated analyses
- 3rd Party Apps: These are web apps built with the REST API that make it easy for investors to access data and analysis to make investment decisions
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 REST API, but also the ability to analyze that data in Excel, a feature of the Excel add-in.
These are individuals who aren't serious computer programmers, meaning the JSON responses that the REST API provides are gibberish:
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 REST API. Don't be scared- some examples will make it clear how this method works.
Here is an API call that returns the price history for Apple:
This output is great if you can write computer code to parse it, but its not good if you aren't a developer. Instead, just add .csv to the call like this:
If you paste that into your browser, you will see a .csv file downloaded to your computer. If you open it in Excel, it looks like this:
That output is static, unlike the Excel add-in, but also easy for non-developers to download in bulk, unlike the REST API. If you are unfamiliar with how to build the syntax to download a CSV, you can find some examples in this article, as well as in the API documentation or via the file download tutorial. Just remember to add a ".csv" before the "?" in the syntax.
If that sounded like non-sense, just message our team- we will help you learn the syntax to download the data you need to csv.Chat with Us If You Have Questions
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.
We have been learning a valuable lesson about financial data at Intrinio. Financial data has been so expensive and hard to access for so long that most people don't think they can use it. We've taught thousands of users what an Excel add-in is and how to use it to do financial research. Now, we will happily teach thousands more how to download the data they need via an API call.
It sounds ridiculous, but we believe all investors should be able to use these tools, not just those that can afford to pay thousands of dollars a month for an expensive subscription.