If you are using an application like Excel or Intrinio's Web API, and suddenly stop receiving data, it could be for a variety of reasons. 

Here are a few of the most common causes and their solutions:

Cause: You hit the data limit for your plan

Intrinio has a subscription model where you can sign up for different data feeds to access different kinds of data. Each data feed has different plans that allow different amounts of data. 

Individual plans allow lower data limits than startup and enterprise plans (Plans with more data cost more). These data limits are measured in API calls- check out this article to see what an API call is and how they are counted. 

If you have hit the data limit for your plan, you will stop receiving data and will see an error message or an NA for all or some of the data you try to pull. This article explains how to check your usage

Remember that you will only receive NAs for data from data feeds where you hit the limit. It is possible to hit the limit of some data feeds without hitting the limit on others.

Solution: Wait until data is reset or subscribe to a plan with more data

Your data usage will reset at around 12 a.m. Eastern Standard Time. You can also upgrade to a paid plan if you are on a free trial, or a plan with higher data limits (e.g. move from an individual plan to a professional plan). 

If you upgrade your plan, you will be able to start using more data right away- just remember that you may need to re-start Excel to have the change take effect. 

You can upgrade your plan from the data feed page or chat directly with our team.

Cause: You are not properly connected to Intrinio's database

Intrinio's Excel add-in authenticates with Intrinio's database using the API. Similarly, Intrinio's developer customers need to form their URL and headers properly to receive data.

If you are not properly connecting, you will receive NAs or other errors. This can happen for a variety of reasons including a spotty internet connection, a firewall, or problems with Excel.

Solution: Trouble shoot your connection

If you are using Excel, follow this guide to troubleshoot on PC and this one to troubleshoot on Mac. Quitting, restarting, and uninstall/reinstalling Excel will often times be the simplest trouble shooting approaches for fixing NAs. 

For API users, check the error code you are receiving (429 is the error for hitting a limit). If you are not properly formatting your API requests, check the docs or an SDK for an example. 

Cause: Incorrect syntax

It is very common for users to make a typo, either in their Excel formula or in their API call. This will usually not result in the sudden appearance of NAs, but it is possible if you drag a formula down or loop through some code with incorrect URLs for the API.

Solution: Use Correct Syntax

Check some examples or use the API Explorer, which will build and test your Excel/API syntax for you so you know its right. 

The Meaning of "nm"

NM means not meaningful and commonly results from negative data. For example, a negative earnings number could result in a negative price to earnings ratio, which is considered not meaningful.

Still stumped?

If none of these solutions worked for you, chat with our team. We have some experienced, nice folks that will help you get it working. 

Did this answer your question?