John Hyatt
Jul 24, 2017 · 1 min read

Regarding forcing an update, I added the term ,A1 after the currency term. I leave cell A1 blank, and periodically change the number in that cell.

Eg: =CRYPTOFINANCE(“BTCUSD”,A1)

Not sure if you listed a RAND function in your script, but these seems to allow me to force an update at least every few minutes, at least faster than the caching of google typically allows.

Sorry if my use of the terms is off. I’m not a coder, so just bungling with the syntax until something returns the value I want. :)

    John Hyatt

    Written by

    Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
    Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
    Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade