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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

FilterXML / Spreadsheet for Trading / Production

First post
Author
Previous Topic Next Topic
DeLuca
Royal Horizon Industries
#1 - 2015-01-24 09:49:33 UTC  |  Edited by: DeLuca
Hello.

After 9 hours of work, ( I am amteur in these things) I figured out the most important stuff.

In short:

Excel 2013

This formula:

=NUMBERVALUE(FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&B4);"/evec_api/marketstat/type/sell/min");".")

FILTERXML and WEBSERVICE to extract my datas from Eve-Central.

NUMBERVALUE because of a problem with currency format. (Probably because of my German Windows)(In Germany we use numbers like "40.241,24" instead of the English on "40,241.24"

PROBLEM

Everything seems to work normal, except the Tritanium (36,281)and Pyerite(45,261) Prices are displayed wrong.

Any idea?
DeLuca
Royal Horizon Industries
#2 - 2015-01-25 21:20:08 UTC
At the moment I have the problem still just with Tritanium and Pyerite. So I update the prices by hand. But I still don't belieave there is no answer to this.
CJ Alland
CB Trading
#3 - 2015-01-30 23:10:54 UTC
I'm not sure how much help I'll be, but I can try to help. I used google sheets and have some added code to import all data for items in a system.

Example: https://docs.google.com/spreadsheets/d/15ZeNosF1RCkCznE1eqiIHEbSiPGgpKR0LrrN1s5PU2c/edit#gid=1536847687

I used to use singular API imports but I might need something visual to understand what you were saying.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-01-31 12:57:15 UTC
CJ Alland wrote:
I'm not sure how much help I'll be, but I can try to help. I used google sheets and have some added code to import all data for items in a system.

Example: https://docs.google.com/spreadsheets/d/15ZeNosF1RCkCznE1eqiIHEbSiPGgpKR0LrrN1s5PU2c/edit#gid=1536847687

I used to use singular API imports but I might need something visual to understand what you were saying.



Uh...

Why do you have three copies of the same function, just changing the default value for the system?

I specifically wrote the function so you could just pass the system id in as a parameter.

(long term you may wish to upgrade it too. https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs handles 'any' number of types now)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Tony Sunz
Doomheim
#5 - 2015-01-31 18:52:23 UTC
Hello,

I also use Excel 2013 for my spreadsheet needs. I think you are off on use of "&

=NUMBERVALUE(FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&B4);"/evec_api/marketstat/type/sell/min");".")

where is should be:

=NUMBERVALUE(FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&B4&"), "/evec_api/marketstat/type/sell/min");".")

On your sheet does the B4 show up in color? I use the same function without the NUMBERVALUE fxn.

Also, a suggestion, if your going to grab more than the MIN SELL price for trit, you should use 1 WEBSERVICE fxn to grab all the info in a cell, then use a FILTERXML to grab that info so it only pulls from Eve-Central 1 time.

Hide or put this is a cell off somewhere
=WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&B4&")

=NUMBERVALUE(FILTERXML($AA1, "//sell/min"), .)

That way you could also get the BUY/max if you wanted
=NUMBERVALUE(FILTERXML($AA1, "//buy/max"), .)

without having to call the api again. It will speed up your workbook a little. Good Luck!

Sunz