I modified a spreadsheet I found a while back to do this and posted it a couple months ago. You might find it useful.
One thing I've been frustrated with the last couple of days is I keep getting this error:
An array value could not be found.
Have you been getting this error lately on your spreadsheet also? I wonder if the cryptocompare API is starting to rate limit people or something.
Yup. I just checked today and Litecoin and Steem are getting array value errors. Not sure why as I checked last week and everything was fine.
Thanks. Glad to know it's not just me.