EVE Technology Lab

I'm trying to setup a spreadsheet than can pull market data from eve central.

I managed to work out (google found me) how to import single items into google docs with
=importxml("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=16633","/evec_api/marketstat/type/buy/max")

etc

The only trouble is this limits me to 50 items per sheet.

I found this old forum post
http://community.eveonline.com/ingameboard.asp?a=topic&threadID=1190856

and followed it through but when I run the macro it sits there and then does nothing.

I've found multiple other posts that either contain spreadsheets that no longer work or contain locked ones that hide pages etc protecting their magic.

So,
Is it possible to have a single sheet that imports all the market data for best buy\best sell in a jita and then lets me work from there?

and how would I go about doing that?
Help or pointers in the right direction would be hugely apprecieated

Actually, scratch that, I still don't quite get it

If I use
=ImportXML("http://eve-marketdata.com/api/item_prices_jita.xml?type_ids="&JOIN(",",A2:A15), "/eve/price")

It steps through each of the typeid's in A2 to A15 and gives a number but it's out.

If I use
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&JOIN("&type id=",$A2:$A15), "/evec_api/marketstat/type/sell/min")

It gives me the correct min sell but doesn't step through and do the same for cells A3 to A15

I'm guessing the numbers being out is a difference between eve-marketdata.com and eve-central.com

Eve central has always been more accurate so I'd love to know how to do the first import but to EC instead of EMD

Is that possible?
How?