NonSports Forum

Net54baseball.com
Welcome to Net54baseball.com. These forums are devoted to both Pre- and Post- war baseball cards and vintage memorabilia, as well as other sports. There is a separate section for Buying, Selling and Trading - the B/S/T area!! If you write anything concerning a person or company your full name needs to be in your post or obtainable from it. . Contact the moderator at leon@net54baseball.com should you have any questions or concerns. When you click on links to eBay on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network. Enjoy!
Net54baseball.com
Net54baseball.com
ebay GSB
T206s on eBay
Babe Ruth Cards on eBay
t206 Ty Cobb on eBay
Ty Cobb Cards on eBay
Lou Gehrig Cards on eBay
Baseball T201-T217 on eBay
Baseball E90-E107 on eBay
T205 Cards on eBay
Baseball Postcards on eBay
Goudey Cards on eBay
Baseball Memorabilia on eBay
Baseball Exhibit Cards on eBay
Baseball Strip Cards on eBay
Baseball Baking Cards on eBay
Sporting News Cards on eBay
Play Ball Cards on eBay
Joe DiMaggio Cards on eBay
Mickey Mantle Cards on eBay
Bowman 1951-1955 on eBay
Football Cards on eBay

Go Back   Net54baseball.com Forums > Net54baseball Main Forum - WWII & Older Baseball Cards > Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2018, 08:29 AM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 355
Default Anyone Familiar with Excel & VBA

I want to make a spreadsheet with excel with cards I have, need, etc; however, I want the spreadsheet to be able to read the title column and scrape the latest ebay price or the avg ebay price {preferably from sold listings} etc. I understand there may be flaws from different titles, best offers, etc; I don't need it to be 100% accurate but the higher the better obviously, as at least it gives me a starting point.

This way I can have an accurate value sheet for when I go to shows and trade or buy, or sell for that matter. And can update it whenever I want. I saw a you tube video, the guy did golf clubs using VBA; Which I have no idea how to use. Can anyone help? I would need step by step instructions; or PM me and I'll gladly pay you for your time in helping me make this idea a reality.

Not sure if this right board; if not feel free to move
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know.
.
Reply With Quote
  #2  
Old 02-16-2018, 11:18 AM
Sean1125 Sean1125 is offline
Member
 
Join Date: Jan 2011
Posts: 3,566
Default

vintagecardprices.com
Reply With Quote
  #3  
Old 02-16-2018, 12:43 PM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 355
Default

Quote:
Originally Posted by Sean1125 View Post
vintagecardprices.com
I am a gold member; I was hoping to do it for stuff from 99 on.
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know.
.
Reply With Quote
  #4  
Old 02-16-2018, 06:48 PM
Tennis13 Tennis13 is offline
Scott ku.rtis
 
Join Date: Jan 2016
Location: Princeton, NJ
Posts: 207
Default

Quote:
Originally Posted by cardsnstuff View Post
I want to make a spreadsheet with excel with cards I have, need, etc; however, I want the spreadsheet to be able to read the title column and scrape the latest ebay price or the avg ebay price {preferably from sold listings} etc. I understand there may be flaws from different titles, best offers, etc; I don't need it to be 100% accurate but the higher the better obviously, as at least it gives me a starting point.

This way I can have an accurate value sheet for when I go to shows and trade or buy, or sell for that matter. And can update it whenever I want. I saw a you tube video, the guy did golf clubs using VBA; Which I have no idea how to use. Can anyone help? I would need step by step instructions; or PM me and I'll gladly pay you for your time in helping me make this idea a reality.

Not sure if this right board; if not feel free to move
I am good enough to be dangerous but bad enough to need help. Do you have the golf club video? I would have thought he would need python for a web scraper, not vba. But if it can be done in vba, i am intrigued to possibly jump down the rabbit hole
Reply With Quote
  #5  
Old 02-16-2018, 07:47 PM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 355
Default

Quote:
Originally Posted by Tennis13 View Post
I am good enough to be dangerous but bad enough to need help. Do you have the golf club video? I would have thought he would need python for a web scraper, not vba. But if it can be done in vba, i am intrigued to possibly jump down the rabbit hole

Here's the video

https://www.youtube.com/watch?v=Q125hnZaRe0
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know.
.
Reply With Quote
  #6  
Old 02-16-2018, 08:12 PM
BoyWonder089 BoyWonder089 is offline
member
 
Join Date: Nov 2014
Posts: 12
Default

I use VBA almost daily at my job. I have tried to do something similar, but found it too challenging to figure out by myself. I'll take a look at the video and see what I can come up with.

Tennis13, maybe we can collaborate to some extent rather than duplicate work?
Reply With Quote
  #7  
Old 02-16-2018, 10:36 PM
The-Cardfather's Avatar
The-Cardfather The-Cardfather is offline
Charles
Cha.rles
 
Join Date: Oct 2015
Location: New Jersey (But born & raised in Brooklyn, NY)
Posts: 411
Default

Quote:
Originally Posted by Tennis13 View Post
I am good enough to be dangerous but bad enough to need help. Do you have the golf club video?
You mean that this wasn't the golf club video that Scott was referring to?


https://www.youtube.com/watch?v=HKFKSmU3Kb4
__________________
.

- Charles

Check out my collection..........
http://ImageEvent.com/The_Cardfather

Check out my stuff for sale.........
(Message me for Net54 members direct sale discount.)
https://www.ebay.com/str/thecardfathersstore
Reply With Quote
  #8  
Old 02-17-2018, 07:11 AM
Tennis13 Tennis13 is offline
Scott ku.rtis
 
Join Date: Jan 2016
Location: Princeton, NJ
Posts: 207
Default

Quote:
Originally Posted by cardsnstuff View Post

So, this is pretty easy. I didnt realize it was this easy. However, it's bad code because he hard codes in addresses. Its not smart enough to go crawling on its own. So its right inline with my experience of good enough to be dangerous to write bad code, but it can get you to where you want to be if you dont mind dropping in the link manuually. This is easy.
Reply With Quote
  #9  
Old 02-17-2018, 07:55 AM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 355
Default

Quote:
Originally Posted by Tennis13 View Post
So, this is pretty easy. I didnt realize it was this easy. However, it's bad code because he hard codes in addresses. Its not smart enough to go crawling on its own. So its right inline with my experience of good enough to be dangerous to write bad code, but it can get you to where you want to be if you dont mind dropping in the link manuually. This is easy.
Cool; and THANK YOU; but what does that mean; dropping link manually; Is there anyway to avoid that and do it automatically?; I envision a spreadsheet with thousands of items, eventually. But, hey any help is more than I can do. Thanks.
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know.
.

Last edited by cardsnstuff; 02-17-2018 at 08:03 AM.
Reply With Quote
  #10  
Old 02-17-2018, 07:58 AM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 355
Default

here's some sample items

2009-10 First Edition #192 Jrue Holiday PSA 10 GEM MINT RC Rookie MEM 76ers
2009-10 First Edition #186 Taj Gibson PSA 10 GEM MINT RC Rookie MEM Bulls
2009-10 48 #81 Dominique Wilkins PSA 10 GEM MINT Hawks
2009-10 48 #98 Clyde Drexler PSA 10 GEM MINT Blazers
2009-10 First Edition #181 Darren Collison PSA 10 GEM MINT RC Rookie MEM Hornets
2006-07 Topps #240B J.J. Redick PSA 10 GEM MINT RC Rookie Magic
2007-08 Finest #79 Nick Young PSA 10 GEM MINT RC Rookie Wizards
2013 Allen and Ginter Across the Years #CRJ Cal Ripken Jr. PSA 10 GEM MINT Orioles
2012 Chrome #45 Clayton Kershaw PSA 10 GEM MINT Dodgers
2013 Topps 1972 Topps Minis #TM-42 Willie Mays PSA 10 GEM MINT Giants
2008-09 Sunkist #3 Carey Price PSA 10 GEM MINT Canadiens
2014 Prizm Rookies #287 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Chrome Rookie Die Cuts #CRDC-JM Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Press Pass Gold #30 Johnny Manziel PSA 10 GEM MINT
2014 Finest #125 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Finest Refractor #125 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Prizm Believe the Hype #1 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know.
.

Last edited by cardsnstuff; 02-17-2018 at 07:59 AM.
Reply With Quote
  #11  
Old 02-17-2018, 09:08 AM
frankbmd's Avatar
frankbmd frankbmd is offline
Fr@nk Burke++
Member
 
Join Date: Nov 2011
Location: Between the 1st tee and the 19th hole
Posts: 7,231
Default

Quote:
Originally Posted by cardsnstuff View Post
here's some sample items

2009-10 First Edition #192 Jrue Holiday PSA 10 GEM MINT RC Rookie MEM 76ers
2009-10 First Edition #186 Taj Gibson PSA 10 GEM MINT RC Rookie MEM Bulls
2009-10 48 #81 Dominique Wilkins PSA 10 GEM MINT Hawks
2009-10 48 #98 Clyde Drexler PSA 10 GEM MINT Blazers
2009-10 First Edition #181 Darren Collison PSA 10 GEM MINT RC Rookie MEM Hornets
2006-07 Topps #240B J.J. Redick PSA 10 GEM MINT RC Rookie Magic
2007-08 Finest #79 Nick Young PSA 10 GEM MINT RC Rookie Wizards
2013 Allen and Ginter Across the Years #CRJ Cal Ripken Jr. PSA 10 GEM MINT Orioles
2012 Chrome #45 Clayton Kershaw PSA 10 GEM MINT Dodgers
2013 Topps 1972 Topps Minis #TM-42 Willie Mays PSA 10 GEM MINT Giants
2008-09 Sunkist #3 Carey Price PSA 10 GEM MINT Canadiens
2014 Prizm Rookies #287 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Chrome Rookie Die Cuts #CRDC-JM Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Press Pass Gold #30 Johnny Manziel PSA 10 GEM MINT
2014 Finest #125 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Finest Refractor #125 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Prizm Believe the Hype #1 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
If this is a prewar mainboard topic, where can I get a helmet and a foxhole. But then again I may just hide behind the water cooler.
__________________
FRANK:BUR:KETT - RAUCOUS SPORTS CARD FORUM MEMBER AND MONSTER NUMBER FATHER.

GOOD FOR THE HOBBY AND THE FORUM WITH A VAULT IN AN UNDISCLOSED LOCATION FILLED WITH NON-FUNGIBLES


274/1000 Monster Number


Nearly*1000* successful B/S/T transactions completed in 2012-24.
Over 680 sales with satisfied Board members served.
If you want fries with your order, just speak up.
Thank you all.



Now nearly PQ.
Reply With Quote
  #12  
Old 02-17-2018, 09:36 AM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 355
Default

Quote:
Originally Posted by frankbmd View Post
If this is a prewar mainboard topic, where can I get a helmet and a foxhole. But then again I may just hide behind the water cooler.
They were just recent samples I had, such a thing would be great for all ungraded cards too. For example: I could have provided a sample list of ungraded t206's with standard/various backs in VG
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know.
.
Reply With Quote
  #13  
Old 02-17-2018, 09:40 AM
frankbmd's Avatar
frankbmd frankbmd is offline
Fr@nk Burke++
Member
 
Join Date: Nov 2011
Location: Between the 1st tee and the 19th hole
Posts: 7,231
Default

Quote:
Originally Posted by cardsnstuff View Post
I am a gold member; I was hoping to do it for stuff from 99 on.
Wasn’t this your post?

I assumed you meant 1999 and not 1899, which VCP has covered.
__________________
FRANK:BUR:KETT - RAUCOUS SPORTS CARD FORUM MEMBER AND MONSTER NUMBER FATHER.

GOOD FOR THE HOBBY AND THE FORUM WITH A VAULT IN AN UNDISCLOSED LOCATION FILLED WITH NON-FUNGIBLES


274/1000 Monster Number


Nearly*1000* successful B/S/T transactions completed in 2012-24.
Over 680 sales with satisfied Board members served.
If you want fries with your order, just speak up.
Thank you all.



Now nearly PQ.
Reply With Quote
  #14  
Old 02-17-2018, 09:52 AM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 355
Default

It was my post; yes; Initially I was thinking simple post war graded cards. But as I have been thinking about it more; Imagine the possibilities. You come up with virtually any list and scrape or least try to scrape recent market prices. Including ungraded ones that VCP, SMR, etc don't cover. And we all know Beckett price guide is a joke.

Personally, I am excited about the people that are willing to help and may try to figure it out.

I do understand your concerns; and I did say in opening thread if I posted in wrong section to please move it.
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know.
.
Reply With Quote
  #15  
Old 02-17-2018, 10:17 AM
Tennis13 Tennis13 is offline
Scott ku.rtis
 
Join Date: Jan 2016
Location: Princeton, NJ
Posts: 207
Default

Quote:
Originally Posted by cardsnstuff View Post
Cool; and THANK YOU; but what does that mean; dropping link manually; Is there anyway to avoid that and do it automatically?; I envision a spreadsheet with thousands of items, eventually. But, hey any help is more than I can do. Thanks.
Dropping the link manually: If you see on his video, he is hard-coding that ebay link and pulling data from that. Ebay has very obvious links, so you can write a loop that replaces it programatically and maybe goes through every link -- like he changed some letter in the link, you could just say "find, replace" in the code and do that. In addition, it's my hunch that while ebay caps you at 200, you could probably go into that link and change the 200 to 3000. MAYBE.

You will want to migrate from a spreadsheet to a database eventually -- again, out of my area of expertise, but NOT THAT HARD and I'd bet the other guy that works in VBA probably has some views on this.

I think what you'd ideally like is to build a python webscraper, write it to a database rather than excel, and then build basic SQL queries to pull down attributes. The SQL is easy, the writing to a database is pretty easy, too. The python web scraper, i have failed building a few times, but I'm sure we could collectively stumble through it to create it.
Reply With Quote
  #16  
Old 02-19-2018, 04:23 PM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 355
Default

I want to give a big THANK YOU to Richard, for his work, we have a working {although, it has issues} version. Once completed I will happy to share with everyone; it will be a tremendous time saver and a tool that anyone who has cards that are not in VCP database {such as raw or modern} or items {such as balls, bats, jersey's, etc} for that matter will appreciate. Can anyone continue on this working model and help us fine tune it? If you can help, please PM me.
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know.
.

Last edited by cardsnstuff; 02-19-2018 at 04:47 PM.
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Spreadsheets for Collection ruth-gehrig WaterCooler Talk- Off Topics 6 09-02-2014 02:02 PM
t206 Excel Doc? drazz5 Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 3 08-03-2014 09:24 PM
Loading Excel files Pat R Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 2 06-01-2012 08:00 AM
Excel list for 33 and 34 Goudeys Archive Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 6 09-03-2008 09:25 PM


All times are GMT -6. The time now is 04:46 AM.


ebay GSB