Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Any suggestion appreciated
>
Reply to Thread
Message:
<p>[QUOTE="rlm's cents, post: 211563, member: 7957"]Not sure how familiar you are with Excel. I use a much smaller but similar spread sheet with PCGS (high grade) and Numismedia (lower grades) as my price guides. I merely copy the pages from the net and then use HLOOKUP function (or VLOOKUP) to get the right price for the coin. That way when I upgrade a coin, it automatically updates the price. Whenever I desire, I just copy the appropriate price guide into the spread sheet and it updates all the coins to the current prices. I do not believe that the Red Book prices are on line so this will not work for that price guide unless you want to type all of the prices in. However, you can use any online price guide you desire. If you are careful enough on the setup, you can even change between price guides either permanently or just to see the differences are.</p><p><br /></p><p>FYI: The HLOOKUP function can get very convoluted, but are extremely powerful once you figure out how to use them.[/QUOTE]</p><p><br /></p>
[QUOTE="rlm's cents, post: 211563, member: 7957"]Not sure how familiar you are with Excel. I use a much smaller but similar spread sheet with PCGS (high grade) and Numismedia (lower grades) as my price guides. I merely copy the pages from the net and then use HLOOKUP function (or VLOOKUP) to get the right price for the coin. That way when I upgrade a coin, it automatically updates the price. Whenever I desire, I just copy the appropriate price guide into the spread sheet and it updates all the coins to the current prices. I do not believe that the Red Book prices are on line so this will not work for that price guide unless you want to type all of the prices in. However, you can use any online price guide you desire. If you are careful enough on the setup, you can even change between price guides either permanently or just to see the differences are. FYI: The HLOOKUP function can get very convoluted, but are extremely powerful once you figure out how to use them.[/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
>
Any suggestion appreciated
>
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...