#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.