Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Using an Algorithm
>
Reply to Thread
Message:
<p>[QUOTE="Phil Ham, post: 1845893, member: 5787"]I've created simple algorithm using Excel. One tab includes the updated melt value of US coins, US proof and mint sets, and Canadian coins using Coinflation to update the values. I link these prices to another tab, which includes all the coins in my collection. One column includes face value, another column is instrinsic value, another column is the upcharge or collectors value over instrinsic value (if any). Another column adds the collectors upcharge to the instrinsic value and compares it to the face value. It reports the highest of the two values using the IF function. I use ebay (sorted by sold items) to update the collector's upcharge.[/QUOTE]</p><p><br /></p>
[QUOTE="Phil Ham, post: 1845893, member: 5787"]I've created simple algorithm using Excel. One tab includes the updated melt value of US coins, US proof and mint sets, and Canadian coins using Coinflation to update the values. I link these prices to another tab, which includes all the coins in my collection. One column includes face value, another column is instrinsic value, another column is the upcharge or collectors value over instrinsic value (if any). Another column adds the collectors upcharge to the instrinsic value and compares it to the face value. It reports the highest of the two values using the IF function. I use ebay (sorted by sold items) to update the collector's upcharge.[/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
>
Using an Algorithm
>
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...