Dynamic Market Price in Spreadsheet?

Collecting
1

Does anyone have a method that is not overly technical (this is subjective, I suppose) to pull the current market price of individual cards, from TCGplayer or similar, into Google Sheets or Excel that updates automatically?

I’m not trying to track price changes, just the current market price at any given time.

Thanks

1 Like
2

I’ve built something in google sheets over the last two years. But I would say it is overly technical and I do this kind of thing for a living. I can see if I can create a watered down version over the next few days and let you know!

4 Likes
3

If it’s too much work, please don’t sweat it.

I’ve worked something out by using the =IMPORTHTML function in Sheets to pull a table of a particular set from pricecharting and then VLOOKUP to pull the prices into another tab but it’s kinda clunky and still figuring out how scale it how I want to

1 Like
4

What I’ve found is having too many IMPORTHTMLs causes the pulls to time out. So I had to write app script to cycle through my list overnight and reset the formulas each time 5 or so at a time so it doesn’t time out.

1 Like
5

Yeah that’s above my pay grade lol

2 Likes
6

Like I said, overly technical haha

1 Like
7

Ha ha agreed I was thinking the same thing
Appreciate the detail though I get the gist now

1 Like
8

Same here way more detail than I need.
I trust the summary version