Does anyone collect or deal in Silver American Eagle Bullion? How to post an Excel spreadsheet.
TopographicOceans
Posts: 6,535 ✭✭✭✭
I bought a US Mint tube of twenty 2017 SAE's on eBay for $397, after sorting the price low to high on eBay.
The price of silver fluctuates and it's a commodity, but does anyone collect it like a coin series?
I was looking at US Mint tubes by dates 2000-2017 sold on eBay.
In 2003 silver was around $5.00 an ounce and hit a peak of $46.68 in 2011.
If you bought low and sold high you made money and if you bought high and sold low then you lost money.
But I did learn something useful about posting an spreadsheet.
If you create an Excel file on your PC and then select and copy data from it, and then post it is a message box here it will first post the data in text mode and then an image with the Excel file, like below:
Year Low $ High $ Avg $
2000 $425 $500 $463
2003 $418 $456 $437
2005 $415 $415 $415
2006 $425 $481 $453
2008 $435 $435 $435
2009 $406 $421 $413
2010 $390 $445 $417
2011 $390 $506 $448
2012 $417 $430 $424
2013 $395 $433 $414
2014 $375 $440 $408
2015 $397 $435 $416
2016 $359 $435 $397
2017 $397 $435 $416
Comments
Why are 2003 and 2011 highlighted? Interesting data if collecting or stacking rolls of ASE's. Cheers, RickO
I do. I started buying bullion eagles for the silver, but after a couple of years I started cherry picking the best examples from a year/roll and started a collection of 'em. When silver went stupid expensive in the early 2010's, I stopped buying them as silver, and bought a roll to get a pick a couple for my collection. There's a sickness in there someplace...
Just went through my 2017 roll. Picked out an exceptional 2 coins for my collection, 13 other perfect looking strikes, and 5 with some sort of flaw. Those 5 will probably be gifts at some point...
So that's how it works!
I've bought low and high, Loved SAE's at $5-6 in the early 2000's, hated paying 30+ in 2011 and 2012. $20/coin today is still painful.
(snip)
Simple HTML tables are pretty easy to learn and produce, if you don't want to duplicate the data. I actually maintain the HTML tables I post here in Excel. I can post an example if you're interested.
Unfortunately, I've looked at the HTML code Excel produces when you do a save as, and it's really ugly code...
I loved the 2000's also. 100oz silver bars at $400
100% Positive BST transactions
I buy them strictly as a bullion play. Date is unimportant to me.
No Way Out: Stimulus and Money Printing Are the Only Path Left
I would export it as tab separated, then use the
feature in Markdown
Hit quote to show syntax
Interesting rice data at a glance, thanks
Successful transactions with : MICHAELDIXON, Manorcourtman, Bochiman, bolivarshagnasty, AUandAG, onlyroosies, chumley, Weiss, jdimmick, BAJJERFAN, gene1978, TJM965, Smittys, GRANDAM, JTHawaii, mainejoe, softparade, derryb, Ricko
Bad transactions with : nobody to date
2003 had a low of under $5.00 an ounce.
2011 had a high of $46+ an ounce.
Glad to see Broadroadjunkie is cherry-picking SAE's by date.
Careful. eBay will may cancel your Ad as you are displaying prices for non-graded coins.
Select the data cells, copy and save as an image. Then just drag the image to your post.