Home› PCGS Set Registry Forum

PCGS POPs and Excel Spreadsheets...HELP!!!

NumisMeNumisMe Posts: 841 ✭✭
in PCGS Set Registry Forum
I am trying to find a way to pull LIVE Data from the PCGS Online POP Reports and place that data into cells in an Excel spreadsheet...

I realize you can Cut and Paste, but I need a way to do it LIVE, and keep it updated.

Can this be done?
Can it be automatically updated, or even updated on command?
If this is possible, are there any legal concerns I need to know about?

If you want to see what I am trying to do, send me your email address and I will send you a copy of the manual for my spreadsheet.


Thanks in advance!!!

Comments

  • DMWJRDMWJR Posts: 6,008 ✭✭✭✭✭
    I think it is called a spider, and you will have to write it. I'm sure someone more literate with writing programs could explain it to you.
    Doug
  • ChuckCChuckC Posts: 1,600
    see post in BST forum
  • cointimecointime Posts: 2,013 ✭✭✭✭✭
    Ernie,
    Chucks step by step worked for me image

    Thanks ChuckC!
    Ken

    My Washington Type B/C Set

  • gripgrip Posts: 9,962 ✭✭✭✭✭
    One possibility is to contact PCGS; they may have a way of doing this (for a fee?).

    Al
  • NumisMeNumisMe Posts: 841 ✭✭
    Thanks to all of you for your help!

    It does not look like I have a very good chance of doing what I set out to do, here.


    ChuckC, your instructions were great, and in fact, will help me to accomplish another project I am working on, but as Brian pointed out on the other thread, the data on the PCGS website is locked and I cannot use your method for that. image


    Thanks Ken, see above. image

    Al, I will give that a try! It is, after all, my last hope. image


    For all of you who have emailed me, I have been on a job and will get a copy of the manual out to you later tonight.

    You might also want to check out my reply on the BST board. image

Sign In or Register to comment.