1

I have a Google Spreadsheet fetching stock exchange data using an ImportHTML function:

=ImportHtml("http://www.xxxx.xx.xx/xxxxxxxx/livefeedfull.aspx/?"& year(now()) & month(now()) & day(now()) & hour(now()) & MINUTE(),"table",0)  

that I then publish to a JSON which updates on every change. This function however updates every minute.

How do I set it to update at intervals of five minutes?

0

1 Answer 1

1

UNTESTED (because for example the Nairobi Stock Exchange is closed at present) but

& year(now()) & month(now()) & day(now()) & hour(now()) & MINUTE(),  

to

& A1,

with =int(minute(now())/5) in A1 may be worth trying.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.