Market Discussions

I'm a returning player from a few years ago. When I was trading back then I made a kick ass spreadsheet in google docs to help my station trading. (Obviously using the importXml feature) Well now I guess google has changed the spreadsheets making it just craptastic now and it doesn't hardly work.

I'm not a computer programmer and I'm not that familiar with VB code or excel. I have been looking around at online resources trying to see what I need to do, but some of it seems a little complicated and I'm not quite following if there is a good way to do what I need or not.

Basically, can anyone help me out, or point me towards a CLEAR & EASY TO FOLLOW guide to making a trade spreadsheet like the one I have in google docs. There was nothing to advanced there, just using importXML in ranges of 100 to bring in buy/sell prices and market volume.

Do I have to change the url information in some way for this? Just taking the api url from my google sheet doesn't seem to be working.

Might be able to answer my own question after I get something working, but can you use cell references in this section in excel? For example, this is one of the pulls from google docs.

=importXml("http://api.eve-central.com/api/marketstat?&hours=24&typeid="&JOIN("&typeid=",$B2:$B100)&"&usesystem=30000142&minQ=1","//sell/min")



Tried using this in power query with no luck

http://api.eve-central.com/api/marketstat?&hours=24&typeid=34&usesystem=30000142&minQ=1,"//sell/min"

I'm just posting as I go along, since I'm researching all this as I go along. I also came across:

https://www.fuzzwork.co.uk/2016/01/12/using-crest-with-excel-crest-strikes-back/

Getting ready to try setting this up right now, I noticed in the example that you also get the 5% average sell price. I have also played with evernus since I have returned and noticed in the market analyzer it also pulls 5% average buy and sell prices. Is there anyway to just pull min sell and max buy anymore? Anyone to change that in evernus to see those instead of the 5% average?

You can use power query to pull from eve central as well. yes, you need to change the url.

You _can_ get the full order data from CREST and import that, but, tbh, it's not that much use. Because you get every order, and have to manipulate it to get the max/min etc. It's how sites like mine and eve central work, but it's a bit of a pain to do in a spreadsheet.

As for movement, that's somewhat harder (assuming you're meaning on how the price moves.) Because you have to retain history.

People tend to go with the 5% prices, because it is a lot harder to manipulate.