Fuzzwork Market Data

Wheee! API.

Just a simple one at the moment. Global, Regions, Systems and 5 the hub stations only.

Yes, all systems now

Global - 0
Jita - 30000142
Perimeter - 30000144
Jita 4-4 CNAP - 60003760
Amarr VIII - 60008494
Dodixie - 60011866
Rens - 60004588
Hek - 60005686

Formatted one of these ways

https://market.fuzzwork.co.uk/aggregates/?region=10000002&types=34,35,36,37,38,39,40

https://market.fuzzwork.co.uk/aggregates/?station=60003760&types=34,35,36,37,38,39,40

(Due to how it works, you can give a station or a system as a region, and it will return correctly. These are all precalculated aggregates)

Returning a json dataset looking like (this is truncated) the following

{
  "34": {
    "buy": {
      "weightedAverage": "4.02878502065",
      "max": "5.95",
      "min": "0.01",
      "stddev": "1.62036217159",
      "median": "5.0",
      "volume": "10024734026.0",
      "orderCount": "52",
      "percentile": "5.50168617928"
    },
    "sell": {
      "weightedAverage": "6.60015441538",
      "max": "2201571.0",
      "min": "5.01",
      "stddev": "177420.733866",
      "median": "6.38",
      "volume": "25573930856.0",
      "orderCount": "179",
      "percentile": "5.92257900667"
    }
  },
  "35": {
    "buy": {
      "weightedAverage": "2.95108749592",
      "max": "9.32",
      "min": "0.01",
      "stddev": "2.33386568045",
      "median": "8.08",
      "volume": "3567567586.0",
      "orderCount": "43",
      "percentile": "8.93197172057"
    },
    "sell": {
      "weightedAverage": "11.8397717552",
      "max": "88.97",
      "min": "8.9",
      "stddev": "6.28077891535",
      "median": "10.49",
      "volume": "13983717157.0",
      "orderCount": "170",
      "percentile": "9.30539352676"
    }
  }
}

I highly recommend pulling all the aggregates into one sheet, and then using vlookup to retrieve them. It's more efficient for both you and me

An example function for use with Google Docs can be found on my github page. An example of it in use is shared from my google drive

No real example with Excel I'm afraid. I'd suggest using XLWings to pull out the bits you want. Alternatively use powerquery.

Power Query

If you have a recent version of Excel, you have powerquery available.

Open excel and go to a new worksheet
hit the 'New Query' button on the Data ribbon.
Go to 'from other sources', and pick from Web
Give it the url to get the aggregates you want. You'll need to do more research here to make it dynamic
Hit ok.
You'll get a list of the type ids, followed by record.
on the convert ribbon, hit 'into table'
Next to value, in the resultant table, you'll see two arrows pointing apart from each other. hit it, and leave the buy and sell ticked. untick 'use original column names as prefix'
You'll now have two more columns, called buy and sell. split those with that same icon. I'd suggest leaving the original name as a prefix this time.
Close and load. you're now done.
Just hit refresh all, when you want to update them. You can, through the connections button on the data ribbon, set the query up to refresh on open, or on a timer. just select it and go to the properties.

There's also the api https://market.fuzzwork.co.uk/api/orderset which returns the most recent orderset id. This may be of use if you're downloading the order book. Please don't do this every 30 minutes. Get the data youself, direct from CCP. It'll be fresher and more reliable.

If you're wanting all the aggregated market date, then you'll probably want to get https://market.fuzzwork.co.uk/aggregatecsv.csv.gz, which containst a full dump of the data. Though if an item isn't on the market, you'll get _nothing_ back for it. and it'll require a little manipulation to be easily usable. Unfortunately it's too big for google sheets. excel handles it.

Fuzzwork Market Data

Power Query

Files