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.
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.