Revisions to ImportHTML spreadsheet function to update every 5 mins

edited body

Source Link

edited Jun 4, 2014 at 16:51

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

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

to

& E1A1,

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

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

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

to

& E1,

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

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.

Post Undeleted by pnuts

occurred Jun 4, 2014 at 16:19

added 68 characters in body

Source Link

edited Jun 4, 2014 at 16:19

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

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

to

&hour(now())/12& E1,

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

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

& hour(now()) & MINUTE()

to

&hour(now())/12

may be worth trying.

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

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

to

& E1,

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

Post Deleted by pnuts

occurred Jun 4, 2014 at 14:11

Source Link

created Jun 4, 2014 at 13:59

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

& hour(now()) & MINUTE()

to

&hour(now())/12

may be worth trying.

Return to Answer