RealTimeToExcel Frequently Asked Questions

Microsoft Excel shows #N/A values. What to do?

#N/A means that the data is "Not available."
Possible reasons are
1. An error server in the formula. Check the correct value: "gartle.rtd" (lowercase is correct too).
2. An error in arguments. Check the provider, symbol, and the data field.
3. A bad ticker. Check the ticker at https://finance.yahoo.com/.
4. Data absent in a data source. For example, Open, DaysHigh, and DaysLow can be not available during non-trading hours.

The data are not refreshing. What to do?

Add formulas to monitor data status: rtd_LastUpdate, rtd_LastError, rtd_InQueue, rtd_RefreshInterval.
See complete description in RealTimeToExcel Fields.
If you work with non-US exchanges, check Data provider settings. Possibly, the DataStartTime is incorrect in your case.

Can you add another data source?

Yes, definitely.
Please write us a request.

Can we add another data source?

Yes, definitely.
Please write us a request. We will send you data provider source.

How to get historical prices into Microsoft Excel table for a particular period at once?

You can use our product SaveToDB, a Microsoft Excel add-in, for getting web data into Microsoft Excel.
You can load web data in HTML, XML, JSON, and CSV formats. Yahoo! Finance and Google Finance publish historical prices for free.