Troubleshooting Excel

< Browse all Support Topics

ERR: Issues

ERR: NO DATA - Excel returns this error when the data point is absent. The issue can be resolved using the Fill Null field located at the bottom of the YCP or YCS formula boxes. *To see an example of how to use the Fill Null Field, please click here.

ERR: REQUEST FAILED - Excel returns this error when the connection from the excel add-in has been interrupted. This issue can most often be resolved by closing out of excel completely and re-opening the excel worksheet(s), which resets the connection.

ERR: INVALID CALC - Excel returns this error when the particular metric being pulled doesn't apply to the security. For example, you will see this error when trying to pull a P/E ratio for a mutual fund. To fix this issue, please confirm the metric is available for the corresponding asset class by checking against our website or our complete reference.

ERR: INVALID DATE - Excel returns this error when the date format can not be understood or processed. The issue can be resolved by either: If linked to another cell: Adjusting the format to a date instead of a string If unlinked: changing the date to a "YYYY-MM-DD" format.

ERR: INVALID ASSET - Excel returns this error when the ticker being referenced is blank or begins with a punctuation mark. The issue can be resolved by either re-linking your cell to another ticker or by updating the ticker.

ERR: INVALID COMPANY - Excel returns this error when the ticker does not exist or is formatted incorrectly. If you are building your own spreadsheet, please ensure the ticker is typed correctly, including adding an "M:" in front of mutual funds tickers, and a caret (^) in front of index tickers (i.e. AAPL, M:FBIOX and ^SPXTR).

Account Issues:

ERR: EXCEEDED QUOTA - Excel returns this error when you have surpassed your monthly quota. To fix this issue, please contact your account manager.*

ERR: MULTIPLE LOGINS DETECTED - Excel returns this error when our API has detected more than one computer connection logged in with the same access key. To fix this issue, please re-paste your key and hit login or contact your account manager to expand the number of connections.*

Excel Issues:

#VALUE! - Excel returns this error when the formula does not recognize one or more of the input components. This issue can be resolved by reviewing the individual arguments and specifically looking for spaces, text, or other characters that would create an error.

#DIV/0! - Excel returns this error when the formula tries to divide by 0 or an empty cell. Please review the denominator argument to resolve this issue.

#NUM! - Excel returns this error when the formula generates an invalid number. Please check the arguments within the formula to resolve this issue.

#NULL! - Excel returns this issue when the formula does not detect an intersection between two arrays. This issue can be resolved by changing your inputs to ensure they intersect.

#Name? - Excel returns this error when the formula used in the spreadsheet is not recognized. Please take a look at the formula being used in order to resolve this issue.

*A fee may apply

Are you an investing professional?

Click here to request a live demo of YCharts Professional, our premium suite of tools and data.
Learn more about our professional products. Call (866) 965-7552 or email sales@ycharts.com.

{{root.upsell.info.feature_headline}}.

{{root.upsell.info.feature_description}}

Please note that this feature is only available as an add-on to YCharts subscriptions.


Please note that this feature requires full activation of your account and is not permitted during the free trial period.

Start My Free Trial {{root.upsell.info.call_to_action}} No credit card required.

Already a subscriber? Sign in.