Why do some functions give me NA or N/A instead of a value?

Seeing NA or N/A in your cells can be frustrating. Here's why it happens and how to fix it.

Common Reasons for NA Values

1. Data Not Available

Some data simply doesn't exist for certain securities:

• Penny stocks may not have analyst estimates
• ETFs won't have P/E ratios (use fund-specific metrics instead)
• New IPOs may lack historical data
• International stocks may have limited coverage

2. Invalid Ticker Symbol

• Check that you're using the correct ticker symbol
• US stocks should not include exchange suffixes (use "AAPL", not "AAPL.US")
• Make sure there are no extra spaces in the ticker

3. Delisted or Changed Symbols

• Companies may change their ticker symbol
• Stocks that are delisted will return NA
• Check if the company has merged or been acquired

4. Market Hours

Some real-time data is only available during market hours:

• Pre-market: 4:00 AM - 9:30 AM ET
• Regular hours: 9:30 AM - 4:00 PM ET
• After-hours: 4:00 PM - 8:00 PM ET

5. Function Not Applicable

Certain functions only work with specific security types:

• Options Greeks functions need option symbols
• ETF functions need ETF tickers
• Mutual fund functions need fund symbols

How to Troubleshoot

Verify the Ticker

=QM_LAST_PRICE("AAPL")

If this returns a value, the ticker is valid.

Check Function Syntax

Make sure you're using the correct function for your data type:

• For stocks: QM_LAST_PRICE()
• For options: QM_OPTION_LAST()
• For ETFs: QM_ETF_NAV()

Use IFERROR

Wrap your functions to handle NA gracefully:

=IFERROR(QM_PE_RATIO("AAPL"), "Data not available")

Need Help?

If you believe data should be available but you're getting NA:

• Email us at support@marketxls.com
• Include the ticker symbol and function you're using