AFIN Web Service GETDATATEXT
GetDataText form
This is the same as:
1. In any web browser (url):
http://afin.net/ws/getdatatext.php?key={MyKey}&url={MyUrl}&rpl1={MyRpl1}&rgx={MyRgx}&rpl2={MyRpl2}&inx={MyInx}
2. In Microsoft Excel (v.2013+) worksheet formula:
=WEBSERVICE("http://afin.net/ws/getdatatext.php?key={MyKey}&url={MyUrl}&rpl1={MyRpl1}&rgx={MyRgx}&rpl2={MyRpl2}&inx={MyInx}")
3. In Google Sheets worksheet formula:
=IMPORTDATA("http://afin.net/ws/getdatatext.php?key={MyKey}&url={MyUrl}&rpl1={MyRpl1}&rgx={MyRgx}&rpl2={MyRpl2}&inx={MyInx}")