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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Googledocs and average volume
Author
Previous Topic Next Topic
Barrak
The Painted Ones
#1 - 2015-07-08 22:23:10 UTC  |  Edited by: Barrak
Hi,

Complete amateur here I'll point out from the start.

I've watched a few youtube videos and have created a spread sheet that pulls min/max prices from eve-central. I then use this to compare prices between stations.

It seems to be working as intended however it is taking me forever to look at trades as I am only doing 50 at a time.

I have an idea around volume and was wondering if there is a way to call average volume traded over a period into the spread sheet?

Can this be done through eve-central?

I'm not a programer and have no idea about CREST. I just mashed this document together from watching a few videos (not even that good at excel - learnt the funcition 'lookup' in the processUgh).

Regards

Barrak
Barrak
The Painted Ones
#2 - 2015-07-10 08:46:24 UTC
Hi,

Anyone able to offer any assistance?