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.
 

Spreadsheet help
Author
Previous Topic Next Topic
Lady Sasha
Federal Navy Academy
Gallente Federation
#1 - 2012-05-09 07:17:20 UTC
Hey guys, apologies in advance for my lack of excel expertise.

I've been using eve marketeer for my spreadsheets to assign ISK values to all kinds of things. Normally I just hit the "Data" tab on the Excel menu and then "From text", input something like "http://www.evemarketeer.com/api/info/2393_2396_3779/csv/10000043/sell_lowest5" and set it to semicolon delimited. This produces a nice table for Bacteria, Biofuel and Biomass with isk value for the lowest 5% of sales so I can make a low ball estimate of it's worth.

Recently eve marketeer has sorta died and even though it's up now, the values are incorrect. What I would like to know is if there's a way to pull up this data from Eve Central or maybe even a better way of getting this information into a spreadsheet so I don't have to manually update the prices of a hundred different PI resources.
Wukulo
Brutor Tribe
Minmatar Republic
#2 - 2012-05-09 07:36:14 UTC
Google docs has a great XML import feature as well as HTML. Excel does this well but I recommend google docs. Eve central has some documentation that can help you get started.

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

Posted on main because I'm not a coward like the rest of you.
Lady Sasha
Federal Navy Academy
Gallente Federation
#3 - 2012-05-09 07:51:14 UTC
Interesting, the Eve-Central request calls up a tree of information. http://api.eve-central.com/api/marketstat?typeid=2393&usesystem=30000142

How do I import this into excel or google docs in a way that would create an easily readable table like my Eve Marketeer one did?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-05-09 09:35:32 UTC
try, in excel, importing from web. That should do the conversion from xml to a table for you.

in google docs, try =importxml('http://api.eve-central.com/api/marketstat?typeid=2393&usesystem=30000142','//type')

You'll probably have to play around a little with the google docs import option. Try a search on the tech lab forum. There's likely something there.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Insanity Happens
Ministry of War
Amarr Empire
#5 - 2012-05-09 09:41:30 UTC  |  Edited by: Insanity Happens
excel function similar to google docs:

Quote:
Public Function xmlQuery(xmlUrl As String, xmlPath As String) As String

Dim xmlHttp
Set xmlHttp = CreateObject("Microsoft.XMLHTTP")
Call xmlHttp.Open("POST", xmlUrl, False)
Call xmlHttp.setRequestHeader("Content-Type", "text/xml")
Call xmlHttp.send

Dim xmlDoc
Set xmlDoc = CreateObject("Microsoft.XMLDOM")
xmlDoc.async = "false"
xmlDoc.LoadXML xmlHttp.responsetext
xmlDoc.setProperty "SelectionLanguage", "XPath"

Set ndOutput = xmlDoc.DocumentElement.SelectSingleNode(xmlPath)
xmlQuery = ndOutput.Text

End Function


and usage

Quote:
=queryXML("http://api.eve-central.com/api/marketstat?regionlimit=10000002&hours=60&typeid="&C2&"","/evec_api/marketstat/type/buy/max")



this used to work a while ago, might need to modify it now .. but i think it's still alright
Kandreath
De Re Metallica
#6 - 2012-05-09 10:24:41 UTC
I use Open Office calc to pull Jita PI data from Eve Central.

You just need an xml import filter and it will open it directly.

This is another option for you. Open office development is stalled at the moment so you may not want to get into it now.
Rengerel en Distel
#7 - 2012-05-09 12:28:21 UTC
https://docs.google.com/spreadsheet/ccc?key=0Ar_YTOcXpvb9dGFIdHJlb0VmYXBORWRrcXFkeHNjcWc#gid=10

the show all formulas will help you see the formatting.

With the increase in shiptoasting, the Report timer needs to be shortened.