Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
iamathome
Bastion's Gates Perfect Dark
0
|
Posted - 2016.07.26 21:38:16 -
[1] - Quote
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.
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
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6118
|
Posted - 2016.07.26 22:48:28 -
[2] - Quote
Have a quick look at
https://market.fuzzwork.co.uk/api/
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
iamathome
Bastion's Gates Perfect Dark
0
|
Posted - 2016.07.27 00:04:50 -
[3] - Quote
Wow! You just fired the supergeek cannon at me there.
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
35
|
Posted - 2016.07.27 06:12:51 -
[4] - Quote
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
Bastion's Gates Perfect Dark
1
|
Posted - 2016.07.27 09:29:17 -
[5] - Quote
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
4
|
Posted - 2016.07.31 16:48:40 -
[6] - Quote
Tried Powerquery in Excel 2013 - success! Thanks.
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
Angelus.Mortis Fidelas Constans
27
|
Posted - 2016.08.03 02:04:46 -
[7] - Quote
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
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |