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. :)

3 comments

Pokemon Card Investing

skool.com/pokemon

Pokemon Card Investing Community. Helps you collect cards that you love ❤️, increase in value 📈 and make you money 💰. European collectors only 🇪🇺!

Skool app for iOS

Skool app for Android

Leaderboard (30-day)