If your spreadsheet or API call is suddenly returning NAs or NMs instead of data, here are some potential causes and solutions.
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 products to access different kinds of data. Each product has different plans with specific limits. These data limits are measured by API calls.
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 products where you hit the limit. It is possible to hit the limit of some products 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 working in the sandbox, or a plan with higher data limits.
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 by speaking with our sales 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: Troubleshoot 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 troubleshooting approaches for fixing NAs.
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.