Activity
Mon
Wed
Fri
Sun
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
What is this?
Less
More

Memberships

Pokemon Card Investing

466 members • Free

1 contribution to Pokemon Card Investing
How to change prices from 7days avg to best offert
Hi everyone, I'm creating this post for those who want to get the price of the lowest first offer instead of the average price. To do this, you need to replace the line: =IMPORTXML(E7; "//*[@id='tabContent-info']/div/div[1]/div/div[2]/dl/dd[10]/span") with this: =IMPORTXML(E9; "//section[@id='table']/div[@class='table article-table table-striped']/div[@class='table-body']/div[1]/div[@class='col-offer col-auto']//span[@class='color-primary small text-end text-nowrap fw-bold ']") The /div[1] parameter indicates which row to select, so if you don't want to get the first price for any reason, you can change it to the row number you prefer. :)
0 likes • Mar 6
Thanks!
1-1 of 1
Stefano Mestroni
1
5points to level up
@stefano-mestroni-5968
Sealed Pokémon Collector

Active 5h ago
Joined Jan 2, 2025
Powered by