Latest Prices using Google Sheets importdata function


#1

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;
https://api.nomics.com/v1/exchange-markets/prices?key=xxx&currency=BTC&exchange=binance&format=csv

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 ?


#3

@yuzarsif This is a limitation of Google Sheets unfortunately. Data from importdata will refresh every hour. https://support.google.com/docs/answer/58515?hl=en