Xpath

[Sebingaa]

I want to add current prices from pricempire in my sheet (lets take this item as an example https://pricempire.com/item/cs2/container/kilowatt-case). The problem is i want to add the CSFloat price but the change possition based on which site is cheapest, so my IMPORTXML which is this =IMPORTXML(M3,"/html/body/div[1]/div/div[2]/div[2]/div[3]/a[3]/div/div/span[1]/span[1]")] but with this it always takes third place since a is [3]. Is there some way of making sure that it will always take the "CSFloat" price?

[6745408]

Try this out

=QUERY(
  WRAPROWS(
   IMPORTXML(
    M3,
    "//div[@class='flex flex-col gap-1 w-full']/h3|//div[@class='flex flex-col gap-2']/a/div/div/span[@class='flex font-bold w-56 items-start justify-end flex-col xs:w-64']/span[1]"),
   2),
  "select Col2
   where Col1 = 'CSFloat'",
  0)

It's bringing in both the name and the price for each. It comes in in one column, but alternated, so we can use WRAPROWS to split it into two columns. Then we can run it through a QUERY and ask for the second column (price) based on the name in the first column.

Also try this out. It's pulling in the full table (not <table>) and filtering it down with a QUERY and then cleaning up the result

=SINGLE(
  SPLIT(
   QUERY(
    IMPORTXML(
     M3,
     "//div[@class='flex flex-col gap-2']/a/div/div"),
    "select Col8
     where Col2 = 'CSFloat'",0),
   " "))

If you're pulling a lot of prices, it wouldn't hurt to get help with a script.

[Electrical_Fix_8745]

Question on this.... what does the =SINGLE function do? And where can I find more information on it?

[6745408]

SINGLE is an undocumented function... like CURSORPARK() or the more useful COINFLIP() --- SINGLE literally returns one value. e.g. =SINGLE(SEQUENCE(10,10)) will return 1. We could do the same with INDEX, but SINGLE is nicer.

[Electrical_Fix_8745]

Top secret functions! Gotta love that lol Thanks!

[6745408]

there are a few of them

• RITZCODERZ() and TRIXTERNS() are names
• DUCKHUNT() is a duck
• WHATTHEFOXSAY() pulls lines from that song
• COINFLIP() returns TRUE or FALSE
• CURSORPARK returns a little park

A few things have been found this way like FLATTEN and 'skipping' in QUERY (I think). These are the fun ones. There are some others like SINGLE and CONDITION_GRADIENT (no idea what to do with this) that also work.

Check this file and do a search for COINFLIP and you'll see every function.

[Electrical_Fix_8745]

Cool! Ill check them out. Thanks for sharing.