EVE Technology Lab

Recently, Steve Ronuken kindly made a history grabber, showing total daily volume. https://github.com/fuzzysteve/eve-googledocs-script/blob/master/HistoryGrabber.gs

The loadAllVolumes function seems to return a "data is not defined" error. And the loadVolume function returns a reference error (however, it was working for me before).

Is this just me?

Also, does anyone know how I could change the code so that I get an average jita volume over the last 30 days, instead of just the volume from the previous day? Sorry, I am very bad with coding.

bah.

Turns out I pasted in an earlier version of the code, which didn't quite work right. two issues with it.

first: It didn't parse the data before trying to use it.

Second: it didn't zero pad numbers, for dates.

The version that's up now does both.

As for the last 30 days, that's a wee bit harder than it sounds. Mostly because the order of the data is undetermined.


I've added a new function called loadThirtyDayVolume(), which you can hand to average() to get the average for it.

=average(loadThirtyDayVolume(36))


The new function converts the date to the number of milliseconds since 1/1/1970 (Common way to represent dates), then subtracts 2.592e+9 from it (That's 30 days in milliseconds). When it runs through the data set, it converts each date to the same representation, then sees if it's equal or greater than today-2.592e+9, if so, it returns it.

Amazing.