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?

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?

I have a google spreadsheet fetching stock exchange data and it fetches the data using an ImportHTML function as follows and then I publish it to a json which updates on every change

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

This function however updates every minute. How do I set it to update on intervals of 5mins?

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?