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

Use this Google sheet to track the value of your single/sealed Pokemon collection automatically based on live Cardmarket prices. It's 100% free, easy to use, works for any product on Cardmarket, and saves a ton of time. 👉 How to set up your own sheet in 5 minutes: 1. Join the PokeCard Investing community (it's free). 2. Go to the classroom of this community, follow the video instructions. 3. Track your collection effortlessly from now on 👌. I spent a TON of time building this sheet for myself and I'm now sharing it with you guys. Let me know what you think and if you have any questions or suggestions on how to improve it!

Hello everyone, I figured out a way to prevent the prices from not loading. I tried to explain all the steps required to make it work in your own spreadsheet. It's probably not foolproof but i hope it helps at least one person :)

Hello. Im new here. I tried following the tutorial and everything worked perfectly for a couple hours but then some errors started to pop up, like the one I've attached. Is there any fix for it or should I just wait? Thank you!

Hey guys I've been using the price tracker for sealed product for a while now and I have to say it's amazing. Saves me so much time when I wanna get an update on the collection. However I don't really like the 7-day average as I find it quite inaccurate when gauging prices. Does anyone know how to change the code so it gives the From (lowest price) instead? I did notice with some products there are fake sellers at a much lower price than market price and that would mess that up. I guess the only way around that would be taking an X amount of lowest prices and averaging them out but that sounds like quite a hustle so not sure if that would be possible.