Financial Modeling with Free Intrinio Data in Excel and API

If you think financial modeling is buying expensive clothes to impress your friends, this article isn't for you. If you think financial modeling requires data entry to constantly update your calculations, you are in for a treat. This article shows how to calculate a discounted cash flow (DCF), weighted average cost of capital, or quantitative model in Excel or via API automatically, without data entry.

Read More

Sector/Industry API – [Instant Access via SIC Code]

Accessing Intrinio data for individual US equities is affordable, easy and extremely valuable when analyzing investments. What can be even more powerful at times, is accessing that data on an industry-wide or sector-wide level. We developed a Sector/Industry API so investors and developers can instantly access data to generate lucrative insights for different segments of the market. You can check out the data feed here.

Read More

Stock Valuation – Valuing Stocks With Intrinio’s Free Tools

Stock Valuation - The Art and the Science

Warren Buffett is one of the most famous investors of our time and is a stock valuation pro. He learned most of what he knows from Benjamin Graham - the KING of Value Investing.

"Long ago, Ben Graham taught me that price is what you pay, and value is what you get. Whether we're talking about socks or stocks, I like buying quality merchandise when it is marked down." - Warren Buffett

Stock valuation involves analyzing a company from many different angles to determine an intrinsic value. This intrinsic value will either be above or below the current stock price. If the value you arrive at is above the stock price - buy it! It's cheap. If the value is below the stock price- sell it! It's expensive.

Not everyone is a fan of value investing; it's more of a long term approach. Hundreds of thousands of traders around the world pay little attention to the value of a stock, instead raking in big bucks betting on fluctuations in the price of the stock. Day trading, however, is incredibly risky and very few make money at it in the long run. To make an informed investment decision it's wise to analyze the value of the stock before buying.

Stock valuation is as much an art as it is a science. Running a discounted cash flow is somewhat of a science. Deciding which assumptions to put into that model - that is an art. Looking back over historical earnings and performance is a science. Modeling future sales based on industry knowledge and macroeconomic forecasts - that is an art.

There are lots of tools publicly available to assist you in performing stock valuation. We've developed two free tools that take care of the science for you, allowing you to focus fully on the art.

Read More

FDIC Data for Banks [Call, UBPR & Y-9C Reports]

Intrinio was founded on the principle that making financial data affordable and accessible has the potential to ignite innovation in an archaic industry. First, we built our technology and used it to get full coverage of US equity data. Then we started looking for new data sets that needed to be freed from the shackles of oligopolistic pricing. We stumbled upon FDIC data, and what we built has become truly exciting. 

Because of our technology, we're able to serve this data up at a fraction of the cost of other providers. What was once a premium product reserved only for large organizations (who overpay as well) is now affordable and accessible. Eat your heart out.

FDIC Data - The Regulatory Filings

If you're a bank analyst, an investment banker, or the CFO of a bank, you are most likely intimate with the idea of FDIC data. Feel free to skip to the next section so you can get your hands dirty right away.

But for the rest of us, what exactly is FDIC data?

Read More

Stock Price API and Excel add-in. Real time and EOD prices

Intrinio's support team has chatted with thousands of users. One of the most common topics they ask us about about is adding new data types to the Intrinio Fintech Marketplace. They are fed up with data they get from other providers because it is hard to access and expensive. We use those requests to prioritize the data we add next because we know if our users are asking for it it means there aren't any good solutions out there. The first data we prioritized based on user requests was stock prices. Our stock price API is unprecedentedly affordable and easy to access in Excel or API format.

This article explains the ins and outs of the stock price API, how it is used in Excel, and what comes next from Intrinio for stock prices.

Read More

Stock Screener API From Intrinio For Free

We looked up the number of google searches for "Stock Screener API" and found out that only between 10-100 people search for it each month. Thats a tiny market, but if that is what you were looking for, you've come to the right place. This article explains what Intrinio's stock screener API is, how to get access for free, and provides example API calls.

Read More

Standardized XBRL Financial Data – [Why it matters and How We Fix It]

If you want to find out what Tesla's market capitalization was over the past ten years, and you want to access that data in Excel, it seems like it should be cheap and straightforward to do so. If you're a developer and you're looking to get the Oil Industry's performance charted on your website, it seems like accessing that data should be a no brainer. Thanks to a technology called XBRL, this has become easier over the past several years.

The truth is - there is a whole world operating behind the scenes of financial data feeds. There are professionals, companies, industries, governmental bodies and hundreds of thousands of employees working to deliver you your historical market cap.

Outside of the Intrinio Fintech Marketplace there aren't many options for accessing this data. The options that do exist are prohibitively expensive for two reasons.

  1. Financial data in its raw form requires normalization.
  2. Current normalization methods are manual and outdated

Read More

International Stock Prices From Exchange Data International

One of our most frequently requested data types is international stock prices. Exchange Data International (EDI) is a trusted source for EOD stock prices from around the globe as well as over the counter (OTC) and corporate actions data. We are pleased to announce that EDI data will now be available in the Intrinio Fintech Marketplace.

Pairing EDI's much sought after data types with Intrinio's platform will provide Intrinio's users with a crucial data source and make it easier than ever to access EDI data. We launched the marketplace to make financial data affordable and easy to access- partnering with EDI allows us to expand that vision.

This article explains which EDI data feeds will be available, how much they cost, and how to access them in Excel or API formats.

Read More

Analyst Estimates From Zacks In the Intrinio Fintech Marketplace

The Intrinio Fintech Marketplace was designed to make financial data affordable and easy to access. We are pleased to announce the expansion of that vision with the addition of a new data partner, Zacks, whose analyst estimates data will now be available in the marketplace.

Zacks forward and historical estimates of both EPS and revenue are a trusted source of information in the investment community. Intrinio's platform features disruptively affordable data feeds accessible for financial analysts in Excel and fintech developers via an API. Pairing Zacks analyst estimates with Intrinio's platform will provide Intrinio's users with a crucial data source and make it easier than ever to access Zacks data.

This article explains which Zacks data feeds will be available, how much they cost, and how to access them in Excel or API formats.


Read More

Trouble Shooting the Excel Add-In On PC

This article provides a step by step process for getting the Intrinio Excel add-in installed if you are experiencing problems on a PC. If you get stuck on a step or follow the process and still aren't able to get the add-in working, feel free to chat with our team.

Chat with Us

Trouble Shooting on PC

1. Did you follow the process in the Excel tutorial?

The Excel tutorial will walk you through the install steps. If you didn't follow the tutorial give it a try- it includes step by step instructions. If you followed the tutorial and are still having problems continue to step 2.

2. Is your Excel add-in working?

It is possible that you installed the add-in and it is working. This step can be used to check if your add-in is working.

Completely quit Excel. Make sure not to simply close the workbook you have open.

Restart Excel and type this into a cell on a blank Excel workbook on your computer:


If your add-in is installed you should see this:


If you do see this list of Intrinio user defined functions, type this and hit enter:

=intriniodatapoint("AAPL", "beta")

After a moment you should see the current beta for Apple appear in the cell. If you do, your add-in is installed and working properly.

If you don't see the list of user defined functions or don't see a number appear in the cell after typing the formula, continue to step 3 or the last step you completed.

3. Did you use your email instead of your API access code?

When you entered your API keys, a common mistake is to enter your email and the password you selected instead of your API username and API password.

If you entered the wrong API keys but installed the add-in properly you should see "Intrinio in the ribbon of your workbook. Click "Intrinio" and "API Keys":


Then use your email and password to login to your account at

In your account, you can copy your API username and then your password by clicking the clip board next to your keys:


Repeat step 2 using your correct API username and password. If you are still not able to get the add-in working, move on to step 4.

4. Are you on a supported version of Excel?

You need to be on Excel 2010, 2013, or 2016. If you are not on one of these versions you will need to install one of them to continue. If you are using a supported version, continue to step 5.

5. Do you have other add-ins installed?

If you have other add-ins installed they could be interfering with the Intrinio add-in. Remove or deactivate your other add-ins. Once you have, repeat step 2. If this is not successful or you have no other add-ins, continue to step 6.

6. Are you behind a firewall?

The Intrinio add-in uses the internet to pull data into Excel. If you have a firewall that blocks certain types of web traffic you may need to add the Excel add-in to your list of safe applications. Provide your IT department the following information:

*The destination of the macro is: port 80*

*There is no static IP address.*

Once you have added the Excel add-in to your list of safe applications, repeat step 2. If this is not successful or you don't have a firewall, continue to step 7.

7. Did you try uninstalling and reinstalling the add-in?


Frequently, uninstalling and reinstalling the Excel add-in solves any issues a user is facing. Navigate to "Programs and Features" from the Control Panel or by searching "remove programs" on your PC:


Double click the "Intrinio Excel Add-in" and click "Remove" to uninstall the add-in. Return to step 1 and reinstall the add-in before reattempting step 2. If this does not get the add-in working, continue to step

If reinstalling the add-in and repeating step 2 did not work, continue to step 8.

8. Are you in Europe?

If you are in Europe, you will use a semi-colon in your Excel formulas instead of a comma. Repeat step 2 but instead of this:

=intriniodatapoint("AAPL", "beta")

Use this:

=intriniodatapoint("AAPL"; "beta")

If this did not work, or you are not in Europe, continue to step 10.

 10. Did you restart your computer?

Try completely restarting your computer and returning to step 2. If restarting is unsuccessful, move on to step 11.

11. Did you test out a template?

Try opening the "OverviewReport" file from  "Intrinio Templates" in the ribbon:


Enter a T as the ticker symbol and hit "Update". Don't click anything after you hit update, it can take a minute or two to pull in all of the data in the template:

screen-shot-2016-12-27-at-11-51-12-amYou should be able to click through the template tabs and see data:


If you don't see any data, or see only errors, continue to step 12.

12. Is there weird formatting in your workbook?

Open up a blank workbook and make sure that there is no formatting in cell A1. If you have formatting in the cell it can interfere with the add-in. Then, copy and paste this syntax into the cell:

=intriniodatapoint("AAPL", "pricetoearnings")

Check the quotes you used. If you use a single quote or different type of double quotes the add-in will not work. Make sure the ticker you entered is in all capitals. aapl will not work but AAPL will. Make sure you didn't have a typo in intriniodatapoint and that you used () not [] or {}.

If everything is correct, message our team.

Chat with Us
1 2 3 4 7