MARKET.RTD Troubleshooting
Special offer: 50% discount ($1440) for ODataDB Enterprise until May 31, 2024

MARKET.RTD Troubleshooting

Microsoft Excel shows #N/A values
#N/A means that the data is "Not available."
Possible reasons are
1. An error server in the formula. Check the correct value: "market.rtd".
2. An error in arguments. Check the provider, symbol, and data field.
3. A bad ticker. Check the ticker at
4. Data absent in a data source. For example, Open, DaysHigh, and DaysLow can be unavailable during non-trading hours.
The data are not being refreshed
Add formulas to monitor data status: rtd_LastUpdate, rtd_LastError, rtd_RefreshInterval.
See the description in Application Fields.