# Remove thread **URL:** \ **Category:** Market Discussions\ **Created:** [May 26, 2020, 11:52pm UTC](https://forums.eveonline.com/t/remove-thread/244310 "2020-05-26T23:52:03Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Failed\_businessman](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/failed_businessman/32/208531_2.png) [@Failed\_businessman](https://forums.eveonline.com/u/Failed_businessman)\ **Post date:** [May 26, 2020, 11:52pm UTC](https://forums.eveonline.com/t/remove-thread/244310/1 "2020-05-26T23:52:03Z")
Not sure where I was supposed to post this btw, sry if it’s the wrong forum. I’m building a basic google spreadsheet to pull some prices from evemarketer for industry and I can’t get it to work. I’m a complete noob at both spreadsheets and coding in general. So basically, I want to pull Jita buy and sell 5% from evemarketer, with a concatenate function to read the typeiD. I can get it to work as long as I don’t specify any system: =importxml(CONCATENATE(“[https://api.evemarketer.com/ec/marketstat?typeid=](https://api.evemarketer.com/ec/marketstat?typeid=)”, V7,), “//sell/percentile”) But then I don’t know where I’m supposed to put the system ID. I’ve tried multiple things, and so far the only one that doesn’t give me an error is: =importxml(CONCATENATE(“[https://api.evemarketer.com/ec/marketstat?typeid=](https://api.evemarketer.com/ec/marketstat?typeid=)”, V7, “&usesystem30000142”), “//sell/percentile”) But, it doesn’t pull Jita data at all, instead it pulls all regions, just like the first one. So yeah, if someone could please explain to me how I’m supposed to structure this and why, it would be much appreciated. ---
**Author:** ![Runa\_Yamaguchi](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/runa_yamaguchi/32/197532_2.png) [@Runa\_Yamaguchi](https://forums.eveonline.com/u/Runa_Yamaguchi)\ **Post date:** [May 27, 2020, 12:01am UTC](https://forums.eveonline.com/t/remove-thread/244310/2 "2020-05-27T00:01:25Z")
You are basically asking your competition to help you… All the info is out there already… ---
**Author:** ![Failed\_businessman](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/failed_businessman/32/208531_2.png) [@Failed\_businessman](https://forums.eveonline.com/u/Failed_businessman)\ **Post date:** [May 27, 2020, 12:11am UTC](https://forums.eveonline.com/t/remove-thread/244310/3 "2020-05-27T00:11:45Z")
Plenty of people help their “competition”. Literally every industry tools and public spreadsheet are made by people who also play this game. I’m just kindly asking for someone to help me understand how importXML works, can you please take your cynicism elsewhere? lol. ---
**Author:** ![Failed\_businessman](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/failed_businessman/32/208531_2.png) [@Failed\_businessman](https://forums.eveonline.com/u/Failed_businessman)\ **Post date:** [May 27, 2020, 3:54am UTC](https://forums.eveonline.com/t/remove-thread/244310/4 "2020-05-27T03:54:18Z")
Whatever, I figured out an even better way of doing it. ---
**Author:** ![Runa\_Yamaguchi](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/runa_yamaguchi/32/197532_2.png) [@Runa\_Yamaguchi](https://forums.eveonline.com/u/Runa_Yamaguchi)\ **Post date:** [May 27, 2020, 4:03am UTC](https://forums.eveonline.com/t/remove-thread/244310/5 "2020-05-27T04:03:21Z")
Great! Good for you…can you share it here so everyone can benefit? ---
**Author:** ![Failed\_businessman](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/failed_businessman/32/208531_2.png) [@Failed\_businessman](https://forums.eveonline.com/u/Failed_businessman)\ **Post date:** [May 27, 2020, 6:39am UTC](https://forums.eveonline.com/t/remove-thread/244310/6 "2020-05-27T06:39:31Z")
Sure… I used the name range and data validation functions to create drop down cells, linked to another cell, on a second sheet, with an =IF command: =IF(buy\_dropdown=“jita buy %”, jita, IF(buy\_dropdown=“amarr buy %”, amarr, IF(buy\_dropdown=“rens buy %”, rens, IF(buy\_dropdown=“dodixie buy %”, dodixie)))) The =IF command pulls the address that corresponds with the system name in the drop down, into the cell with the =IF command, which in this case has the name range: “buy\_swap”. This allows me to swap which system I’m pulling prices from on the fly! So for example, if the drop down cell uses the name range: “buy\_dropdown” and the drop down option: “jita buy %”, then the “buy\_swap” cell will pull the address for jita (which is located inside a cell, on the second sheet, with the name range: “jita”): [https://api.evemarketer.com/ec/marketstat?usesystem=30000142](https://api.evemarketer.com/ec/marketstat?usesystem=30000142) I then use the following command in the cell I want to pull a price data to: =IMPORTXML(CONCATENATE(buy\_swap,typeid&JOIN(typeid,O7)), “//buy/percentile”) So basically, it pulls the address from the “buy\_swap” cell, then the: “typeid&JOIN(typeid,O7)” command pulls the typeID from the corresponding cell: (O7). Finally, “//buy/percentile” is added at the end, in order to get the 5% buy prices from eve marketer. I hope it makes sense… As I said, I’m a noob at this, still trying to figure ■■■■ out by reverse-engineering what other people are doing lol. ---
**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\ **Post date:** [August 25, 2020, 6:39am UTC](https://forums.eveonline.com/t/remove-thread/244310/7 "2020-08-25T06:39:33Z")
Closed on August 25, 2020, 6:39am UTC This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.