Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Valuing your collection (intrinsic Vs numismatic)
>
Reply to Thread
Message:
<p>[QUOTE="Phil Ham, post: 1353458, member: 5787"]I have my inventory in Excel and include a tab with the current intrinsic value by denomination. Currently, I only value US and Canadian coins using coinflation. In the spreadsheet with the coin list, I have three columns that list the coin by my estimate of value, current intrinsic value (coinflation x 0.9), and a third column that takes the maximum of those two columns. Since I have thousands of coins in the spreadsheet, I quickly get a feel for the value of the collection when silver goes from $20 to $40 to $30 an ounce. I also do the same thing with currency values versus US dollars using the currency converter on another tab. It is pretty easy to do this in Excel with the Vlookup function.[/QUOTE]</p><p><br /></p>
[QUOTE="Phil Ham, post: 1353458, member: 5787"]I have my inventory in Excel and include a tab with the current intrinsic value by denomination. Currently, I only value US and Canadian coins using coinflation. In the spreadsheet with the coin list, I have three columns that list the coin by my estimate of value, current intrinsic value (coinflation x 0.9), and a third column that takes the maximum of those two columns. Since I have thousands of coins in the spreadsheet, I quickly get a feel for the value of the collection when silver goes from $20 to $40 to $30 an ounce. I also do the same thing with currency values versus US dollars using the currency converter on another tab. It is pretty easy to do this in Excel with the Vlookup function.[/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
>
Coin Chat
>
Valuing your collection (intrinsic Vs numismatic)
>
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...