Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Bullion Investing
>
Spreadsheet for Tracking Bullion
>
Reply to Thread
Message:
<p>[QUOTE="doug444, post: 2642435, member: 38849"]Let's see if we can at least come up with column headings.</p><p><br /></p><p>First, going down the page, you'd have sections for dimes, quarters, halves, dollars, rounds, bars, foreign, intact proof sets, and misc., such as 40% Kennedy and war nickels.</p><p><br /></p><p>You would need to add rows as you acquire mixed lots of various denominations; that's easy to do.</p><p><br /></p><p>For columns, reading across "A" to perhaps "M," etc., you could start a draft with:</p><p>A - date</p><p>B - spot price that day</p><p>C - quantity </p><p>D - BxC (spot for what you bought)</p><p>E - price you actually paid</p><p>F - payment type (cash, check, credit card, trade)</p><p>G - ?</p><p><br /></p><p>That's as far as I could draft without knowing more about what you want to accomplish, or what you want to know. Is this a start, or are we on the wrong track? There's no column for face value because you have foreign and sets mixed in, but with what we have already, you can total your entire purchases and know the spot (say, 79.82 Troy ounces) and the total you paid from Day One.</p><p><br /></p><p>There is an implicit assumption in this format that you will buy "all" kinds of silver if the price is right,</p><p><br /></p><p>How experienced are you with Excel?</p><p><br /></p><p>Why don't you enter the row and column headings as per above and save that spreadsheet as a draft, i.e., not enter any transactions yet? You must have headings first, or you cause yourself a ton of work when you change your mind.</p><p><br /></p><p>Other CT-er's can come up with more columns (or rows). Don't let the fear of your spreadsheet getting too complicated slow you down. You can delete in a flash, but adding a new and essential category is a nightmare.[/QUOTE]</p><p><br /></p>
[QUOTE="doug444, post: 2642435, member: 38849"]Let's see if we can at least come up with column headings. First, going down the page, you'd have sections for dimes, quarters, halves, dollars, rounds, bars, foreign, intact proof sets, and misc., such as 40% Kennedy and war nickels. You would need to add rows as you acquire mixed lots of various denominations; that's easy to do. For columns, reading across "A" to perhaps "M," etc., you could start a draft with: A - date B - spot price that day C - quantity D - BxC (spot for what you bought) E - price you actually paid F - payment type (cash, check, credit card, trade) G - ? That's as far as I could draft without knowing more about what you want to accomplish, or what you want to know. Is this a start, or are we on the wrong track? There's no column for face value because you have foreign and sets mixed in, but with what we have already, you can total your entire purchases and know the spot (say, 79.82 Troy ounces) and the total you paid from Day One. There is an implicit assumption in this format that you will buy "all" kinds of silver if the price is right, How experienced are you with Excel? Why don't you enter the row and column headings as per above and save that spreadsheet as a draft, i.e., not enter any transactions yet? You must have headings first, or you cause yourself a ton of work when you change your mind. Other CT-er's can come up with more columns (or rows). Don't let the fear of your spreadsheet getting too complicated slow you down. You can delete in a flash, but adding a new and essential category is a nightmare.[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Bullion Investing
>
Spreadsheet for Tracking Bullion
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...