Ugh, this is easy to do and difficult to explain. But, I guess I’ll try. Anyway, here are instructions for excel.
- To make life easier, you’ll want to import a typeid list, which will give you two columns -one with the item type, and the other with the typeid. (I’ll let you search for an up to date typeid list).
-
In the cell to the right of that, paste the following formula. What this will do is to generate the web address that you’ll need by pulling the typeid from the appropriate cell and inserting it into the web address. Note that when you paste this text into a cell, it will automatically try to pull data from cell B19. So, you will have to manually change that to the desired cell. However, once you have that set up, you can copy and paste the cell (which is not the same as copy and pasting the text within the cell), and excell will automatically update the formula. For example, if I copy and pasted cell C19 into cell C20, it would automatically change the formula to pull data from cell B20. Note that the formual includes the equal sign and quotation marks.
=“http://api.evemarketer.com/ec/marketstat?typeid="&B19&"®ionlimit=10000043”
- Next, copy column C, and paste it into column D by using the Paste Values command. This will paste the actually web address, instead of the formula that was used to generate the web address. You should end up with a bunch of formulas that look like the one below (which pulls market data for Tritanium in Domain.
“http://api.evemarketer.com/ec/marketstat?typeid=34®ionlimit=10000043”
- Now comes the tedious part. You’ll need to manually set up a web query for each item that you want data for, using the addresses in column D. It will eventually ask you where you want to import the data, but you can make your life a little easier by select the first cell in the desired row first.
- It will then fill all the data into cells on that row. Which will look like this.
This is the what will get put into each column (columns H through U). Oh, and you can update your data at any time by pressing the “refresh all” button on the data tab. Just note that it can take like 10-15 minutes to finish if you have a bunch of them.
Hopefully, that made sense.