Quicklook import help

[A34T Z2]

I have all my marketstat stuff pretty much set up and it's pulling the data as I need. Now I'm trying to pull market history to see the buy/sell orders in a selected system but am having #N/A when I try to pull the data in to my sheet...

Here is a link to my sheet to see whats going on.

https://docs.google.com/spreadsheets/d/1BoRfTwSO6eosY3Pc3kT3Ihuo2k18cLSvQhTdMqkYyLM/edit?usp=sharing

Any help would be appreciated!

[Zed Ahri]

Quickly looking your concatenate is creating wrong url.

Easy way to test, take out the concat part to another shell and have =Concat....

Click the link created to see if contains errors

[A34T Z2]

Yes I'm finding it almost impossible to get info on the market history... I have checked the URL several times against how they say it should be formatted and cannot see why it wouldn't work... I've tried Eve Central and Eve-market for pulling the history and neither work... I also pulled all the marketstat using the exact same method and have no issues with it at all...

I've switched over to crest now so I can get the info from there faster and easier.

[Zed Ahri]

What I meant is that if you look at the error code it says:

'Could not fetch url: Jita Buy Orders&typeid=2073&typeid=....'

There is no url Jita Buy Orders&.

you want the url to be  http://api.eve-central.com/etc..etc...&typeid=2073&typeid=....'

[Zed Ahri]

Oh and another thing that affects, importxml itself may be buggy sometimes.

Many people use importxml2 as a replacment.