New answers tagged

1

Unless there is a standard way to export data from investing.com, you will need to write a scraper that pulls all of the data from the website that you want, and then use google sheets API (or some other method) to import it into your workbook. This scraper can then be scheduled to run automatically so that you don't need to update your workbook. Now, for ...


-1

Thanks for your reply. To reduce the the number of importhtml calls I would have make (ie 17 per stock, and create additional to tabs for stocks to stay under the 50 call limit, is it possible convert the html code for table to xml, then import the table data, with a Google sheet script, to enable the data to be imported, headers row 1 and data row 2. For ...


1

You are using IMPORTXML to extra data from a website and the results are being aggregated in a single cell. The reason for this is that the source is not an XML reference, it is HTML. The solution is to use IMPORTHTML. This returns the respective titles and values in adjacent columns. Helper Columns The table numbers for your site range from 1 to 17 ...


Top 50 recent answers are included