Intrinio's mission is to make financial data affordable and accessible so developers and 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.
It is 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?
Intrinio has 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
- 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
- CSV Download: You can download data in bulk and import into excel
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:
If you paste that into your browser, then enter your API keys, which you can copy and paste from your account page, you would see this:
Rest API JSON response- no good unless you are a developer
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:
A file download of Intrinio data to CSV- super for analysts using Excel
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 here, 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.
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.