Market RTD Troubleshooting

Microsoft Excel Shows #N/A Values

The #N/A error indicates that the data is "Not available." Possible reasons include:

1. Formula Error: Check that you are using the correct value: market.rtd.
2. Argument Error: Verify the provider, symbol, and data field you are using.
3. Invalid Ticker: Ensure the ticker is correct by checking it at Yahoo Finance.
4. Data Unavailability: Some data points, such as Open, DaysHigh, and DaysLow, may be unavailable during non-trading hours.

Data Is Not Being Refreshed

To monitor the data status, add the following formulas: rtd_LastUpdate, rtd_LastError, and rtd_RefreshInterval.
Refer to the description in Application Fields.