These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Average Sales per day column in Excel or Google Docs
Author
Previous Topic Next Topic
Dayv Lidente
The Frog Pond
Ribbit.
#1 - 2016-04-14 16:51:21 UTC
Hi all, I've created a basic spreadsheet to pull data using the instructions here:
https://github.com/nuadi/googlecrestscript#examples
There is an ability to pull sales history data there, but I'm looking for a quicker or more efficient way to calculate the average number of sales per item per day. Has anyone done this without having to manually look it up in-game?

The instructions have a way to pull up sales history, but it creates a 4 column array that can be of variable length, and kind of requires it's own separate tab for each item, so it would get pretty unwieldy with 70-80 items and tabs!
Magnu Stormhawk
#2 - 2016-04-15 07:32:56 UTC
eve-marketdata has a function for the average of the last 30 days sales in jita for any given item (for use in google docs). I use an xml import on that for sales data along with GCS for other data
Regnar Avastum
#3 - 2016-04-15 21:07:47 UTC
Magnu Stormhawk wrote:
eve-marketdata has a function for the average of the last 30 days sales in jita for any given item (for use in google docs). I use an xml import on that for sales data along with GCS for other data


Unfortunately eve-marketdata is dead when it comes to sales/day. They rely on the old market uploader that recently stopped working.

Anyway, check this out: https://github.com/lockefox/CriusDev/blob/master/gdoc_scripts.js

Lockefox made some pretty good scripts for pulling all sort of info

♔ ℜegnar's High-End Spreadsheets ♔™
Plleasure Hub
Municorn
#4 - 2016-04-16 17:20:29 UTC  |  Edited by: Plleasure Hub
Oops wrong thread.

"There's no meaningful difference between a real and a virtual world. It's pointless to ask anyone who they really are. All you can do is accept and believe in them, because whoever they are in your mind, is their true identity." — Kazuto Kirigaya