Latest Prices using Google Sheets importdata function


Hello dear nomicers,
First of all thanks a bunch for letting us to use your data over free plan.
I tried to use google sheets to retrieve data with importdata function and set timely-driven triggers using following api;

it seems to me that google sheets cache the retrieved results ?. for ex even at my local hour 10:39 pm, hour of the prices retrieved from api are from 10:09 pm.

when I use desktop ms office excel to retrieve data, it brings much fresher data.

do you know how to get fresher data on google sheets ?


@yuzarsif This is a limitation of Google Sheets unfortunately. Data from importdata will refresh every hour.