Market Discussions

Hi!

I recently returned. I updated my documents with new typeIDs and all that stuff.

I had a (static) list containing how much of an item was moving through the market (=how much was sold) in 30 days. This list is super outdated. (really bad numbers, doesnt contain new items, and still has old items in it)
I think I got those numbers through some very wierd way wich took me hours to gather the data, I dont even remember exactly.

So what I need is just some static list to get some avg value how much of an item moves per day in a region (only need 2 regions actually) . (I dont want just ONE day as one day is not representative for a longer period)

I am working with excel2013, can work with google docs/sheets too. The only way I see is from eve-marketdata (wich I dont know how to use properly in this case since I can only gather daily volume values) or from the public crest wich i find super hard to use.[i tried already] (idk how json is implemented in excel2013)

regards

__________________________________________________________________
Edit, to get more specific: heres the result i get from EMD: http://api.eve-marketdata.com/api/item_history2.xml?char_name=somecoolname&region_ids=10000032&type_ids=13988

As you can see theres not the last 30 days / zero entries are left out.

Idk how to handle a set of data. For single values the xpath is just emd/val (for the sell/buy orders for example, they are single numbers)

LIKE THIS:

=NUMBERVALUE(FILTERXML(WEBSERVICE("http://api.eve-marketdata.com/api/type_volume.xml?char_name=coolname&v="&B13); "/emd/val");".")

Id like this endresult, a list of all the items(could even be static, non updateable):

Name(optional) ::::::::::::::::::::::::::::::::::::::::: TypeID :::::::: Volume(30days)

Domination armor explosive hardener :::::: 13988 :::::::: 11
someother item:::::::::::::::::::::::::::::::::::::::::: sometypeid: 51251?
etc

Hi!
Eve market can be a bit hard to read in beginning. But it gives an idea of how volumes of stuff are sold.
But if you are aiming at regional volumes outside Jita. Evemarkets.net is can be misleading, both price and volume.

You can see 90 days back in history tab. Volume, sell price, buy price and median.
These prices are average of orders actually being "activated".

GL Fly safe!