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.
 

Spreadsheets - Unreliable import data

First post
Author
Previous Topic Next Topic
iamathome
Crimson Marauders
Shadow Ultimatum
#1 - 2016-07-26 21:38:16 UTC
As the title suggests I'm having a dilema.
I'm importing price data for small rigs using the following Google spread formula:

=ImportXML("http://api.eve-marketdata.com/api/importxml_prices2.xml?char_name=demo&buysell=s&type_ids="&JOIN(",",$B4:$B82), "/emd/price")


Some of the imports are spot on but some of them are so far out I'm beginning to think the end result will be so unreliable I won't be able to trust it.

For example;

Small Ancillary Current Router II (31364 ) importing in at 29,833,332 isk and Eve central price is 3,398,999 isk.

and this is only one example. Ugh

Fist off, am I doing something wrong that you can see?

Second, is there a better way (bearing in mind I'm not supergeeky, only slightly)?

Thanks for reading, more thanks for helping Smile
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2016-07-26 22:48:28 UTC
Have a quick look at

https://market.fuzzwork.co.uk/api/

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
iamathome
Crimson Marauders
Shadow Ultimatum
#3 - 2016-07-27 00:04:50 UTC
Wow! You just fired the supergeek cannon at me there. Shocked

At first just trying to get my head around what is going on was overwhelming as I've never dealt with javascript before.
With some help from one of my corpies I've managed to get my sheet working beautifully and I can manipulate it to my hearts desire without attempting to change your script.
and
I'm going to learn more about this. It's a much better way to do things.

Thanks Steve.
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#4 - 2016-07-27 06:12:51 UTC
The major issue is eve-marketdata.com. It seems to very often have some random/garbage data.
Thus best option is to use some alternative provider such as the mentioned endpoint.
iamathome
Crimson Marauders
Shadow Ultimatum
#5 - 2016-07-27 09:29:17 UTC
That's what I thought Zad. I got down to about the 6-7th rig and realised that eve-marketdata must be pulling in prices from somewhere unknown. Simply cannot be relied on.
The Fuzzwork method is proving to be bang on.
Oriella Trikassi
Trikassi Enterprises
#6 - 2016-07-31 16:48:40 UTC
Steve Ronuken wrote:
Have a quick look at

https://market.fuzzwork.co.uk/api/


Tried Powerquery in Excel 2013 - success! Thanks. Smile

The Eve Marketdata dump would be fine for me if it worked, as it is I've been doing individual cell calls to Eve Central which used to take a coffee break to download but are much better now.
CowRocket Void
Of Tears and ISK
ISK.Net
#7 - 2016-08-03 02:04:46 UTC
I use the crest endpoints for all my spreadsheet needs. Using a 10 day rolling average and trimmean to clip the low/hi. Id get the link but... phone

bleeding shadow darkness > did i just saw a red procurer? :P