I’ve never been able to get Evernus to work (import falls over). Are there any other tools for multi-regional price comparisons?
Thanks
Have you tried using/making a spreadsheet to check prices in different regions? I’m not saying that spreadsheets are better in anyway but they can do many things, like importing market data for regions and compare them.
This was my first port of call and spent quite a while working on it, but being the hamfisted Luddite that I am, couldn’t figure out how to pull the prices; either from the ESI or even Fuzzworks 
Figuring that out would probably be the best of both worlds.
I don’t know how the Fuzzworks API works but I can tell you what you need to pull from http://evemarketer.com:
- Part 1: https://api.evemarketer.com/ec/marketstat?
- Part 2: typeid= input a typeid, or typeids separated by a comma “,”
- Part 3: &usesystem= input systemid or regionid
- part 4: merge part 1-3 into a single string like this: http://api.evemarketer.com/ec/marketstat?typeid=34,35,36,37,38,39,40&usesystem=30000142
- lastly use an appropriate function to call it, like importXML() and you will have the result: importXML(“http://api.evemarketer.com/ec/marketstat?typeid=34,35,36,37,38,39,40&usesystem=30000142","//buy/max”) - this one will give you the maximum price for buy orders in Jita for Tritanium, Pyerite, Mexallon, Isogen, Nocxium, Zydrine and Megacyte, in a 7x1 array.
This is incredibly helpful, thank you.
I suppose I want to get to a point where I can download… (almost) everything, to identify the best possible routes. The stumbling point I’ve reached before is how to get this query to import at a much larger scale.
Cheers
try evetrade.space as well
Actually, in google docs, i can’t get this to work 
@ISD_Sakimura
Did you copy his? and then added the adjustments?
I have used the url from the example, pasting it to the importXML function, and using //buy/max as path. But i have a cryptic formula error
Do you have important data on your spreadsheet? if not could you make public and send me a link by PM?
Lol … it’s empty, i was literally trying it 
I’ll send the link.
Ok, how can i send private messages ? 
Click on my name > Send message.
Normally we ISD do not answer PMs. It’s just if you do not want the link to be publicly visible here.
Sure, but i can’t see the “Send message” option after clicking on your name 
Anyway: https://docs.google.com/spreadsheets/d/1CFEL-LCIiKloXzubXR5Jb6BKyQKiJhQa062TvFzrOok/edit?usp=sharing
In the share options, could you set so Anyone with Link can edit?
I think I know what the error is, you have “https” when it should only read “http” in the addresss.
Tried with http as well, also giving you edit permissions. Please try again.
Looking at the api result, we have 3 nodes:
/exec_api
/marketstat
/type
/buy|sell
- max
it looks to me that the xpath is wrong …
it works fine on my own spreadsheets, so I’m not so sure it’s a problem with the xpath.
…and in mine ?
Got it. The transpose of the array. Damn 
No, even worse: functions are CASE SENSITIVE !!!
yup, transpose() flips the array. some programs are case sensitive, like Google Sheets apparently. 
ArrayFormula() is also very usefull, like calculating the grand total of product between two arrays. it would go like this:
=ArrayFormula(SUM(Array1*Array2))
1 Like