Error codes are normal in Excel and are usually a quick fix. The below includes most of the error codes that you may see in Excel with solutions.
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. To Resolve:
- If the date is linked to another cell: Adjust the format of the cell that holds the date to a date instead of a string. You can reference this article to learn more.
- If unlinked or the date is typed in the formula: changing the date to a "YYYY-MM-DD" format.
ERR: INVALID ASSET
Excel returns this error when the ticker being referenced is blank or has extra characters. The issue can be resolved by either re-linking your cell to another ticker or by updating the ticker. Ensure that there are no spaces or punctuation marks before or after 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).
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 detects more than one computer 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 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.
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.
Excel returns this error when the formula generates an invalid number. Please check the arguments within the formula to resolve this issue.
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.
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. If a YCharts formula causes this issue, check to ensure the Excel add-in is installed properly and the YCharts tab is displayed at the top.
If you see an error like the below screenshot, try the following:
- Close all open workbooks in Excel.
- In your task manager (CTRL + ALT + Delete), confirm that Excel does not show. In addition, if you have a "Processes" tab, ensure "Excel.exe" is not in the list. If it is, click the end process button.
- Open a blank workbook in Excel. This clears all historical data in your spreadsheets.
- Open your YCharts workbook, the data should refresh now.