Hot answers tagged

3

Based on Normal Human's answer, I've created a Google sheets script that will parse and email IFTTT based on a price threshold. Google sheet cells won't update ImportXml() or other external site data more than once every hour or so, even using workarounds. However, accessing external sites via the script works. Use the following script and set up a ...


1

add this add-on to your spreadsheet - https://chrome.google.com/webstore/detail/ open your spreadsheet you want to export go to Add-ons select Export Sheet Data select format XML and other settings click on Export button click on the download button


1

IMPORTXML only is able to access public web resources but he URL in the formula requires user and password so it couldn't be reached.


1

Short answer The problem is the xPath, specifically the /tbody part as it's not present in the source code. Explanation The source html code of the page doesn't include the tbody tag. It's added by the browser when it is missed to create a DOM hierarchy but the algorithm behind IMPORTXML doesn't do the same, it requires the xPath for the original source ...


1

EDIT: So If your interested in trying google apps script, here is short simple script that grabs the piece you want: function getOpenInterest(url) { var found, html, content = ''; var response = UrlFetchApp.fetch(url); if (response) { html = response.getContentText(); if (html) content = html.match(/OPEN INT:<BR><FONT size=1 color='#...


Only top voted, non community-wiki answers of a minimum length are eligible