HTML Provider
Usage
Excel formula:
=RTD("gartle.rtd",,"html",<URL>,<Column>,<Row>)
Examples:
=RTD("gartle.rtd",,"html","https://www.barchart.com//stocks/indices.php",2,"$SPX")
=RTD("gartle.rtd",,"html","https://www.barchart.com//stocks/sp500.php?_dtp1=0",2,"AAPL")
=RTD("gartle.rtd",,"html","https://www.finanzen.net//bilanz_guv/Deutsche_Bank",7,"Dividende je Aktie")
This provider parses HTML tables of the specified web page.
You can copy row names to formulas from the web pages directly.
See several examples, for BarChart and FinanzenNet, in the downloaded package.
Data Provider Settings
The data provider is configured to loading data every 12 hours when the Excel workbook is open.
You can change this setting. However, do not request websites frequently. Otherwise, your IP can be banned.
| Parameter | Value |
|---|---|
| RefreshInterval | 12:00:00, 12 hours |
| NextRequestDelay | 1000, one second |
| DataStartTime | 00:00:00 -05:00 |
| DataEndTime | 24:00:00 -05:00 |
| LoadEndTime | 24:00:00 -05:00 |
| LoadOnSaturday | 1, loading Friday's data once. |
| LoadOnSunday | 1, loading Friday's data once. |
Data Source
The provider parses Google Finance Financials web pages.
All reports are loaded as a single page.
Contents