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 give an opinion of a person or company your full name needs to be in your post. Contact the moderator at leon@net54baseball.com should you have any questions or concerns. Enjoy!
Net54baseball.com
Net54baseball.com
ebay GSB

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, 10:29 AM
cardsnstuff cardsnstuff is offline
Member
 
Join Date: Apr 2016
Posts: 182
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, 01:18 PM
Sean1125 Sean1125 is offline
Member
 
Join Date: Jan 2011
Posts: 3,133
Default

vintagecardprices.com
__________________
sean DOT bassik AT gmail DOT com
Reply With Quote
  #3  
Old 02-16-2018, 02:43 PM
cardsnstuff cardsnstuff is offline
Member
 
Join Date: Apr 2016
Posts: 182
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, 08:48 PM
Tennis13 Tennis13 is offline
Scott ku.rtis
 
Join Date: Jan 2016
Location: Princeton, NJ
Posts: 159
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, 09:47 PM
cardsnstuff cardsnstuff is offline
Member
 
Join Date: Apr 2016
Posts: 182
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, 10:12 PM
BoyWonder089 BoyWonder089 is offline
member
 
Join Date: Nov 2014
Posts: 4
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-17-2018, 12:36 AM
The Cardfather's Avatar
The Cardfather The Cardfather is offline
Charles
Member
 
Join Date: Oct 2015
Location: New Jersey
Posts: 187
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 the stuff I have for sale...........
http://The-Cardfather.com
Reply With Quote
  #8  
Old 02-17-2018, 09:11 AM
Tennis13 Tennis13 is offline
Scott ku.rtis
 
Join Date: Jan 2016
Location: Princeton, NJ
Posts: 159
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, 09:55 AM
cardsnstuff cardsnstuff is offline
Member
 
Join Date: Apr 2016
Posts: 182
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 10:03 AM.
Reply With Quote
  #10  
Old 02-17-2018, 09:58 AM
cardsnstuff cardsnstuff is offline
Member
 
Join Date: Apr 2016
Posts: 182
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 09:59 AM.
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 04:02 PM
t206 Excel Doc? drazz5 Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 3 08-03-2014 11:24 PM
Loading Excel files Pat R Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 2 06-01-2012 10:00 AM
Excel list for 33 and 34 Goudeys Archive Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 6 09-03-2008 11:25 PM


All times are GMT -5. The time now is 02:03 AM.


ebay GSB