These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Need Advice on EvE Marketeer API in Google Spreadsheets
Author
Previous Topic Next Topic
Florian Bao
Black Box Technologies
#1 - 2012-02-08 10:20:03 UTC  |  Edited by: Florian Bao
Hi,

can somebody please tell me how I have to build a spreadsheet that will do the following:

Page 1:

only a box called: "enter ITEM ID here"

Page 2:

graphs I made from Page 3:

Page 3:

5 collums with rows of raw data of 6 months worth of item history ( date, transactions, hi price , low price, average price )
of the item entered on page 1

What I suck at doing is writing the right =importXML for the item :( and displaying it in 5 collums for each market

Somebody have merci with a code noob?
Invictra Atreides
Toward the Terra
#2 - 2012-02-09 19:32:19 UTC
Quote:
=ImportXML(CONCATENATE(ʺhttp://www.evemarketeer.com/api/info/",A1,A2,A3,A4,ʺ/xml/10000002ʺ);ʺ//sell_lowest5ʺ)


This will look for the IDs in A1,A2,A3 and A4 cells.

use CONCATENATE(Text1,Text2,Text3) to modfy any part of the URL in importXML.

Blog | Tutorials | Youtube "I don’t know everything, I just know what I know."
roflcat
#3 - 2012-02-10 08:27:35 UTC  |  Edited by: roflcat
I suggest that u use "&" to concatenate strings as it makes your formula better to read and understand.

... as you need to concatenate a "_" in order to qry multiple typeids, l suggest the following to do so:
i am using sth like this to get all numbers from the column A, starting w/ row 3:
Quote:
=ImportXML(ʺhttp://www.evemarketeer.com/api/info/"&join("_";filter(A3:A;isNumber(A3:A)))&ʺ/xml/10000002ʺ;ʺ//sell_lowest5)

check out my bio to confirm my trustworthiness regarding trades

aka: my old signature did not met the length constraints because of huge urls pointing to my previous threads :facepalm:
Scrapyard Bob
EVE University
Ivy League
#4 - 2012-02-10 16:10:31 UTC
Confirming that I haven't had time to look at this yet...

"&" is definitely easier to read then the Concatenate() function.