6

The IMPORTDATA() function has a latency of approximately 1 hour, as explained in this post on the Google Product Forum. You mentioned the fact that a script was being fired by a time based Google Apps Script trigger. I was thinking, if you're using a script in the first place, why not fetch the CSV file as well, like so: Code var url = 'url to public CSV ...


4

This is the easiest way to achieve the descending sort: =sort(importdata("http://www.tr4der.com/download/historical-prices/SPY/"),3,false)


4

Generating a direct download link, as described in this article seems to work fine with the =IMPORTDATA function. To summarize, you take the SITE_ID string from the sharing link you have: https://drive.google.com/file/d/FILE_ID/edit?usp=sharing Using this, you can generate the direct download link for use with the =IMPORTDATA function: https://drive....


3

It doesn't work with arrayformula - importdata, and importxml will not work it unfortunately.


3

Tl;Dr Using Chrome, Open the URL of the source data. Press F12 to open Chrome Developer Tools Press Control+Shift+P to open the Command Menu. Start typing javascript, select Disable JavaScript, and then press Enter to run the command. JavaScript is now disabled. JavaScript will remain disabled in this tab so long as you have DevTools open. Reload the ...


2

Across all the sheets you have created. I have run into this same issue before. this includes test sheets youve played with etc. anytime you have added those import functions and not removed them or left them in a state where they will not try to refresh on their own.


2

Short answer You are right, the import functions updates their result at certain intervals. Explanation From Change a spreadsheet's locale, time zone, recalculation, and language, a help article from the official documentation, Note: External data functions recalculate at the following intervals: ImportRange: 30 minutes ImportHtml, ImportFeed,...


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