i got gifted a five ounce silver national parks quarter that came from the mint and recorded it with the mint price, this way my son will know when an where i got it from and its value when i got it..
Excel sheets, but I would like to connect to the data base where they list prices, so I can keep up with the value of what I have.
I heard there is a feature, if the primary database is compatible, you can link from 1 database (such as a silver spot price) to your spread sheet and if any values change, it is autochanged on your sheet. Any know about this?
This would actually be a great idea for the TPGs to implement. A table in your account where you could enter the serial numbers of the coins in your collection, and then have the values tracked and totaled. People would be checking that page like they check their stock portfolio (Nice, my collection went up today! ) It wouldn't be terribly accurate, as any database accessible price guide is typically extremely inflated (dealer prices), but it would give a sense of relative change. It would also garner increased interest in their holders, which would garner more business.
I, on the other hand, record next to nothing...I recognize it as a moral fault and that my kids will curse my name when they see the mass of (primarily) useless round metal pieces they have fallen heir to. I do have hopes to do better in the future...honestly, cross my heart
I don't know about it as a service or software package. But you could write a visual basic macro that could access a html/database interface and fetch the values, but that would be clunky and overly difficult. The better way to do it would be using a Python script to generate a text file that could be imported into excel.
Actually, both of those methods would probably not be worth the time. Both would require html interface, so it would only work for specific screen resolutions. Plus, if they ever changed the table rendering format in even the slightest way, you'd have to completely rewrite all of the code. One time I actually created a VB script to collect football score results from a website to plug into a bet analysis macro in Excel. Every time they changed the web page, everything got screwed up. The best way would be if they could supply a direct user interface with the database, then you could use a Visual Basic macro to generate SQL query scripts based on the data in Excel and run the script in something like Microsoft Access. Doubt they would bother doing something like this though, there'd be security concerns that they wouldn't want to deal with.
There is a function in Excel that will pull data from online resources (it's called a web query or something). It's actually relatively easy to set-up. I used to use this feature to collect data for online poker. Unfortunately I found, unless you have a super fast computer with super fast internet connection, it very quickly becomes a huge resource hog- lagging everything else down.
I use Coin Manage 2017 pretty good software. easy to use keeps up to date and produces about any kind of report that I need. I recommend it.
Everyone does it differently. Mine is organized in tables by coin type...and each tab is a different denomination. So, on the Dollars tab there is a Morgan table, Peace table, ect. Within each table, I have a column for date/MM, mintage, grade, date purchased, price paid, dealer purchased from, and a notes section.
I just use PCGS registry. I'm not trying to win registry awards it's just a great organizer tool in my opinion and the trueviews auto-populate. I also only have ~30 total coins to track though. If I had way more I'd use excel as well.
Yes, it's called a web query. You can also set up how often it updates. I have my spreadsheet pull the information from coininfo.com. Updates spot prices on gold and silver every thirty minutes if the spreadsheet is open.
