RealTimeToExcel Frequently Asked Questions

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 may use our product SaveToDB, a Microsoft Excel add-in, for getting web data into Microsoft Excel.
You may load web data in HTML, XML, JSON, and CSV formats. Yahoo! Finance and Google Finance publish historical prices for free.
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.