| Author |
 Replies: 21 / Views: 3,253 |
|
Pillar of the Community
United States
1119 Posts |
With the recent rise in silver price my hoard has returned to being worth more than I paid for it. I made this Excel document to keep track of my purchaces. I type in the quantity of pieces, face value of junk or ozs of bullion,desciption, place and date of purchase, spot at time of purchase, and price I paid. I also have to type in the current value, there are ways for this to automatically update but I dont know how and not sure if I want auto update. With maual update of spot price I can see the change all at once as oppossed to gradually while I am not watching. I made formulas to calculate ozs in face value of 35%, 40%, 90% junk, and dollars. I based 90% junk on .71 ozs in a buck and dollrs on .77 oz in a buck. I also use a formula to calculate the current spot by item line and the totals at the bottom of the columns. It helps me keep track of what I buy and how much I paid for each item. If anybody wants a blank copy of the excel document message me and I'll email the blank for with formulas. Edited by Steele
08/25/2012 09:13 am
|
|
|
|
Pillar of the Community
 United States
1119 Posts |
wierd it wouldnt let me upload an image. ill try when I get back
|
|
Pillar of the Community
Canada
1723 Posts |
Its always nice to know that your stack is actually wrth "Market value" again! Good on ya! I'm not quite there yet, I may be wrong but with my higer ticket items included...i think I'm just under $32oz thanks to all the junk silver I had accumilated at 2-3X under spot.
|
|
Pillar of the Community
United States
2764 Posts |
Steele, your email/PM option is not turn on. I would like to have a copy of your excel. Please email/PM me. Thanks.
|
|
Pillar of the Community
United States
1119 Posts |
Here is a sample of what it can look like.  |
|
Pillar of the Community
1283 Posts |
Wow, I don't even know how many ounces I have lol, no really I don't. I know I crossed over the 2k mark over the summer but have been adding every week since then. I know when I buy I usually do at or a little under spot so I can't be doing bad. In 50 years when my kids sell this stuff who will care what it cost. That being said that is a pretty cool spreadsheet. I wish I had the patients to do something like that.
|
|
Pillar of the Community
United States
863 Posts |
Awesome. If silver shoots up due to a QE3 it might be worth it to sell and wait for it to fall again :) than your will be able to purchase and own more :)
|
|
Pillar of the Community
United States
3184 Posts |
Cool Excel list, I've done something similar.
|
|
Pillar of the Community
United States
4008 Posts |
Quote:
I know I crossed over the 2k mark over the summer but have been adding every week since then. Wow, TBK! That is a VERY respectable silver hoard! Excellent stacking job there.  My hoard is about 2/3 of that size at about 1350 oz. It is still in the red but I do not care. Most of what I have are BU and AU quality US 90% silver coins plus newly minted ASEs and Maples. Beautiful stuff but it costs a little more than circulated coins. Still, my average price is in the area of $34 per oz. Not all that bad, IMHO. I still think that there will come a time when having silver or gold could very well mean the difference of getting through a depression vs. not getting through it. If that ever happens, no one will care what they paid for PMs. All they will care about is whether or not they have any. Got phyzz? |
|
Pillar of the Community
Canada
1723 Posts |
Wait I'm confused....i think he means2k in fiat spent and has 107oz of ag. :-)
|
|
Valued Member
United States
381 Posts |
I also keep track of my Silver with Excel Spreadsheets. I have separate sheets for CRH, purchases, and sales. I have all the spreadsheets linked. All I need to do is enter the current spot price in the first sheet and it will automatically update the rest of the sheets. I know there is probably a way to have it update on its own. I just haven't figured it out yet. I am not in the black yet. I purchased the complete set of Franklin halves in BU along with all of the 90% 1992 through 2012 Kennedy halves. I'm glad I'm not the only one that keeps track of this. Thanks for sharing Steele. |
|
Pillar of the Community
United States
4008 Posts |
Quote:
I don't even know how many ounces I have lol, no really I don't. I know I crossed over the 2k mark over the summer but have been adding every week since then. I dunno, Sam. In the same breath he says that he doesn't know how many ozs. he has and then says that that he has over 2,000. I took that to be ozs. since he was talking about ozs. If not, then he can clarify it in a follow-up message. |
|
Pillar of the Community
1283 Posts |
  Good or bad I am heavily invested in the silver stuff. |
|
Pillar of the Community
Canada
1723 Posts |
you know what you may be right there....I'm looking at his sample sheet there where it says 107 oz....lol  Oh dear , that's embarrassing. hehehe. Edited by samsnate
08/26/2012 10:13 pm
|
|
Pillar of the Community
United States
5855 Posts |
I recently put together a similar Excel spreadsheet to track my PMs, except that I don't include price paid. Basically, it lets me keep track of how many ounces of PM I currently have and what the current spot value is. In general, I'm just tracking spot value and don't include numismatic premiums for things like BU Morgans. The exception is the five 25th anniversary ASE sets that I own which I've just put a hard-coded value of $600 per set. If silver ever gets above $120 per ounce, I'll change their values to track the spot price as well. It's nice to know my collection of PMs is likely worth a lot more than what is listed in my spreadsheet, but this gives me a nice "bare minimum" value when planning out my long-term investment strategy. Plus, it's just nice to know many ounces of PM I actually own! |
|
Valued Member
United States
456 Posts |
Quote:
All I need to do is enter the current spot price in the first sheet and it will automatically update the rest of the sheets. I know there is probably a way to have it update on its own. I just haven't figured it out yet. It's actually fairly easy. To do it in Excel 2010: Go to 'Data' Tab Click on 'From Web' A 'New Web Query' browser page opens up. Go to a site that tracks PM prices. (I used coininfo.com) Click on the yellow and black arrow by the table which selects it. Click 'Import' at the bottom of the browser page. Select the cell you want to start the table on and select 'Ok' on the 'Import Data' pop-up. That should import the same table from the web page. To update the price, go to the 'Data' tab and select 'Refresh All'. |
| |
Replies: 21 / Views: 3,253 |
Posted 08/24/2012 10:24 pm
