Activity
Mon
Wed
Fri
Sun
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More
Memberships
Pokemon Card Investing
465 members • Free
1 contribution to Pokemon Card Investing
Sep '24 •
Price Tracker customization
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.
0 likes • Sep '24
=ROUND(AVERAGE(VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E12; "//*[@id='table']/div/div/div/div/div/div[1]/div/span"); 1); " €"; "");","; ",")); VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E12; "//*[@id='table']/div/div/div/div/div/div[1]/div/span"); 2); " €"; "");","; ",")); VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E12; "//*[@id='table']/div/div/div/div/div/div[1]/div/span"); 3); " €"; "");","; ",")); VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E12; "//*[@id='table']/div/div/div/div/div/div[1]/div/span"); 4); " €"; "");","; ",")); VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E12; "//*[@id='table']/div/div/div/div/div/div[1]/div/span"); 5); " €"; "");","; ","))); 2)
0 likes • Feb '25
@Robyn de Roode Thanks for the update, i'll adapt my formula. But unfortunatly since few days, i have the same issue with the sheet not loading data ...
1-1 of 1
Active 157d ago
Joined Sep 24, 2024
Powered by