Options
A How to Guide for Importing the PCGS Price Guide to Microsoft Excel
commoncents05
Posts: 10,096 ✭✭✭
This is a How-to Guide for Importing the PCGS Price Guide Data into a Microsoft Excel Spreadsheet.
Step #1
Open Microsoft Excel and start a new worksheet.
Step #2
On the Menu Bar, Click on Data, then Import External Data, then New Web Query.
Step #3
Go to PCGS's website and then to the Price Guide of the Series you want to import.
Step #4
Click on the arrow in the upper left corner of the sheet (See picture). The yellow arrow should turn in to a Green Check Mark.
Step #5
Click 'Import' in the lower right corner.
Step #6
Click OK.
Step #7
This is what it should look like after importing.
Step #8
Enjoy your prices! You can customize the spreadsheet and dress it up a little nicer.
Note: You can do the same with the Population Report!!
-Paul
Step #1
Open Microsoft Excel and start a new worksheet.
Step #2
On the Menu Bar, Click on Data, then Import External Data, then New Web Query.
Step #3
Go to PCGS's website and then to the Price Guide of the Series you want to import.
Step #4
Click on the arrow in the upper left corner of the sheet (See picture). The yellow arrow should turn in to a Green Check Mark.
Step #5
Click 'Import' in the lower right corner.
Step #6
Click OK.
Step #7
This is what it should look like after importing.
Step #8
Enjoy your prices! You can customize the spreadsheet and dress it up a little nicer.
Note: You can do the same with the Population Report!!
-Paul
Many Quality coins for sale at http://www.CommonCentsRareCoins.com
0
Comments
Awesome step by step instructions.
Millertime
Complete Dime Set
No Way Out: Stimulus and Money Printing Are the Only Path Left
<< <i>Why would i go through all that when I can just view the latest on-line? >>
I import the price guide into Excel then use the Bold and Fill formats for the coins I currently have in my Registry Set. In columns to the right I have the purchase info so with a single spreadsheet I can track what I have (and all the buying info such as seller, dates, costs) and the PCGS prices of what I need.
I also did one on the page that shows all my Registry Sets so that I can glance at an Excel spreadsheet and see where I stand.
Millertime
Complete Dime Set
<< <i>Why would i go through all that when I can just view the latest on-line? >>
1. It can sometimes be faster accessing a local file than accessing the net.
2. You can annotate the excel file, or delete coins (rows) you're not interested in.
3. It can be useful on the coin show floor with a laptop, where you might not have
an internet connection.
Thanks,
Mark
Discover all unpredictable errors before they occur.
Recipient of the coveted "You Suck" award, April 2009 for cherrypicking a 1833 CBHD LM-5, and April 2022 for a 1835 LM-12, and again in Aug 2012 for picking off a 1952 FS-902.
<< <i>Why would i go through all that when I can just view the latest on-line? >>
History sometimes doesn't repeat itself. This could be a good tool for keeping a history of valuations.
``https://ebay.us/m/KxolR5
K