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.
 

Help with Market Spreadsheet
Author
Previous Topic Next Topic
Zeff Allu
The Eye of Thera
#1 - 2014-07-18 19:11:21 UTC
Hello EVE-Community,

I have a very strange problem with my spreadsheet in Microsoft Office 2013. I want to pull market data from eve-central with the function:

=NUMBERVALUE(FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?typeid=11399&usesystem=30002187&hours=10");"//type/sell/min"); ".";

This works fine for all the items except Tritanium (TypeID: 34) and Pyerite (TypeID: 35) where the returned values are just plain wrong. And the crazy part is that the XML which is pullid via WEBSERVICE() has the correct values but the FILTERXML displays values that are completely made up. I would appreciate any help.

Cheers
Zeff

P.S. I was not sure where to post this, I hope this was the right place.
Wafflehead
Garoun Investment Bank
Gallente Federation
#2 - 2014-07-18 19:21:18 UTC
Zeff Allu wrote:
Hello EVE-Community,

I have a very strange problem with my spreadsheet in Microsoft Office 2013. I want to pull market data from eve-central with the function:

=NUMBERVALUE(FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?typeid=11399&usesystem=30002187&hours=10");"//type/sell/min"); ".";

This works fine for all the items except Tritanium (TypeID: 34) and Pyerite (TypeID: 35) where the returned values are just plain wrong. And the crazy part is that the XML which is pullid via WEBSERVICE() has the correct values but the FILTERXML displays values that are completely made up. I would appreciate any help.

Cheers
Zeff

P.S. I was not sure where to post this, I hope this was the right place.


Wrong place, this belongs in the EVE Technology forum

https://www.fuzzwork.co.uk/2013/06/22/importing-price-data-into-spreadsheets/
https://forums.eveonline.com/default.aspx?g=posts&t=331808