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.
 

Market Import - Solved

Author
Reileen Kawahara
Bio-Tech Research
#1 - 2015-12-29 15:03:39 UTC  |  Edited by: Reileen Kawahara
Hi all, I posted this in the Tech forum but has fallen on deaf ears, can anyone in here help?

It has been some time since I used my Excel SS but it seems it no longer works as it should.

Can someone point me in the direction of how to get market prices etc. from Crest.

Any help will be greatly appreciated.

Thanks

P.S I am willing to pay for a built SS that works.
Rykker Bow
Center for Advanced Studies
#2 - 2015-12-29 15:19:53 UTC
While I personally cannot help you out, there is a guy in sell forums that specializes in spreadsheets and offers customization.

Spreadsheet thread

The Mjolnir Bloc - Lowsec PvP for the sophisticated - The Mjolnir Bloc Killboards

Reileen Kawahara
Bio-Tech Research
#3 - 2015-12-29 17:44:42 UTC
Thanks for the heads up but I would prefer help in compiling my own so I can customize the way I want.

I don't mind paying for a starter sheet that I can add items etc to as I am ok using V lookup etc.
Rhivre
TarNec
Invisible Exchequer
#4 - 2015-12-30 02:20:53 UTC
Eve-Central has an api you can bring directly into your sheet via web query.

Excel 2016 can be used with CREST (which is JSON) using Power Query, but that is more tricky.
Reileen Kawahara
Bio-Tech Research
#5 - 2015-12-30 14:35:27 UTC
I am using the below query to pull prices into Excel but there are a lot of items with 0 cost, despite the market showing sales.

http://api.eve-marketdata.com/api/item_prices2.xml?char_name=demo&buysell=s&minmax=min&station_ids=60003760

Am I missing something obvious?

Any help would be appreciated.
Rhivre
TarNec
Invisible Exchequer
#6 - 2015-12-30 16:42:16 UTC
Eve market data often has holes in the data, Eve Central is better, but you cant pull the entire market like you can with eve marketdata, you need to put each type ID in individually to the URL

https://eve-central.com/home/develop.html

Reileen Kawahara
Bio-Tech Research
#7 - 2015-12-30 17:12:56 UTC
Does anyone know what the crest import is, I can import the JSON into google docs if someone can point me in the right direction.
Oriella Trikassi
Trikassi Enterprises
#8 - 2015-12-30 18:52:16 UTC
The Eve Central Query for Tritanium at Jita is

=FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=34),"/evec_api/marketstat/type/buy/max")

It's pretty reliable at the moment and much faster than it used to be. I've never felt the need to dig directly into CREST when all I need are daily Buy and Sell prices.

The Eve Marketdata dump does indeed sometimes report zero when it shouldn't - their bug not yours.
Reileen Kawahara
Bio-Tech Research
#9 - 2015-12-31 19:51:02 UTC
Yes but as I understand it, Crest is the way to go and I would appreciate any help in the right direction.
Rhivre
TarNec
Invisible Exchequer
#10 - 2015-12-31 22:03:25 UTC
Reileen Kawahara
Bio-Tech Research
#11 - 2016-01-01 00:27:54 UTC  |  Edited by: Reileen Kawahara
Rhivre wrote:
https://github.com/nuadi/googlecrestscript


You are a star, thankyou very much.

I now have the prices coming in as they should, brilliant.

BTW if you want access to the sheet when finished you are welcome to it.
Buzz Orti
State War Academy
Caldari State
#12 - 2016-01-01 01:00:31 UTC
Reileen Kawahara wrote:
Rhivre wrote:
https://github.com/nuadi/googlecrestscript


You are a star, thankyou very much.

I now have the prices coming in as they should, brilliant.

BTW if you want access to the sheet when finished you are welcome top it.

idk but I am working on that and could pay you.

Builds ship in empty Quafe bottle.

Reileen Kawahara
Bio-Tech Research
#13 - 2016-01-01 01:27:19 UTC
Buzz Orti wrote:
Reileen Kawahara wrote:
Rhivre wrote:
https://github.com/nuadi/googlecrestscript


You are a star, thankyou very much.

I now have the prices coming in as they should, brilliant.

BTW if you want access to the sheet when finished you are welcome top it.

idk but I am working on that and could pay you.


Shoot me a mail of what you need and I can make a custom sheet.
Reileen Kawahara
Bio-Tech Research
#14 - 2016-01-02 11:06:14 UTC
Thanks to all who helped with this.

I now have Crest working and pulling in current prices, averages, region trades, volumes etc and it is so much more accurate than eve-market.
Buzz Orti
State War Academy
Caldari State
#15 - 2016-01-02 14:24:14 UTC
Reileen Kawahara wrote:


Shoot me a mail of what you need and I can make a custom sheet.

Perhaps you found that I do have other goals than using custom sheets.

However, I could use custom sheets samples to build (info) systems from.

Builds ship in empty Quafe bottle.