Junk Silver & Bullion Tracker On Excel - Let Me Know If You Try It

To participate in the forum you must log in or register.

Author	Replies: 3 / Views: 2,753
JobIII Valued Member United States 366 Posts	Posted 11/21/2016 10:00 pm Hi All, I've created a tracker using excel...Yes the noob software normal people who cannot understand MS Access use... It was designed to track your collection as you buy U.S. Junk Silver & Bullion. It is in no way as complex as it could be. But it's version 1.0. Here is the Youtube tutorial on the spreadsheet: Gbp-y4mWl4Y Here is the link to my blog post with the screenshots and link (towards the bottom) to download from DropBox: Bullion & Junk Silver Tracker Tutorial and Excel Spreadsheet I have left the document unlocked so users that download it may edit it as they see fit. This is my first attempt at creating something like this, and I would love to hear any comments if you use it. Best ~JobIII Report this Post to the Staff

jbuck Moderator United States 188770 Posts	Posted 11/22/2016 11:33 am Nothing wrong with Excel (spreadsheets). I prefer them myself. Coin Collector Since 1978 Avatar Old Avatar 7070 Eisenhower Australia Canada World CCF Members on eBay CCF eBay Search Engine Report this Post to the Staff
ErrorCoins222 Pillar of the Community United States 1699 Posts	Posted 11/22/2016 2:21 pm Have you thought about using the "Get External Data" tool to scrape the current spot price from the web? This would allow you to calculate the value of each line item (and a sum of all line items) at the current spot price without having to enter it every time you enter the file. Edited by ErrorCoins222 11/22/2016 2:29 pm Report this Post to the Staff
JobIII Valued Member United States 366 Posts	Posted 11/22/2016 6:49 pm Errorcoins222, Great suggestion. However I'm wondering if that would require the file to be saved online somewhere like a sharepoint folder. I will look this up. Thanks again for suggesting this! Report this Post to the Staff
	Replies: 3 / Views: 2,753

To participate in the forum you must log in or register.

All Forums Category: General Numismatic Forums Forum: Main Coin Forum

Silver Gold Bull US is the United States leading bullion dealer. We deliver gold coins, gold bars, silver coins, silver bars and precious metals to your door. Order today!

The First Dollar, your premier source for bullion and rare coins. See our bullion list on the site and the coin inventory on ebay.

View Last 100 New Topics

View Last 100 Active Topics

Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Coin Community assumes no liability for errors. Copyright 2005 - 2026 Coin Community Family- all rights reserved worldwide. Use of any images or content on this website without prior written permission of Coin Community or the original lender is strictly prohibited.
Contact Us | Advertise Here | Privacy Policy / Terms of Use

Coin Community Forum

It took 0.21 seconds to rattle this change.