Values listed on your sets...............

DIMEMAN

Does anyone else think it would be nice to be able to see the value of the coins in your set and a total for the set. This would, of course, only be available to the owner of the set.

A button come come on the screen when viewed by the owner. Click on it a the values would be pulled from the PCGS coin prices for each coin in your set. And a total at the bottom.

I think it would be great. And as a programmer, I know it could be done very easy.


Any thoughts????

Jon

LindeDad

I like the idea but would like to see it being two colums of figures. PCGS price guide for one and your actual for the other.
With a trusted agent working to get the PCGS price guide adjusted as members add new coins to their sets. But most would not be willing to trust putting that infor on a WEB site that might be hacked. JMO

DIMEMAN

Putting your value out there would require a database change creating a new field. This would be more work and I'm sure PCGS would balk at that. Becides I don't see what relevance (sp) your value would be since it would be your opinion only.

I'm not sure I understand your other concern about hacking. Anyone can see your grade and look it up anyway. This would just put it there for you and would always be up to date, because it would be the latest from the price guide.

Jon

joeyuk

I think LindeDad was refering to the price you paid not your current opinion of value.
That info would be best kept private.

LindeDad

<< <i>That info would be best kept private >>



What I am thinking of is a private field only visable to the owner and the trusted agent at PCGS that would use the info to update the price guide. The owner could use it as a set inventory.

DIMEMAN

I'm confused. Are saying you want to be able to change the price guide?

What I'm talking about is using something that is already there (price guide) to show you the value of your coins. Nothing would be changed OR stored. It would be retrieved new each time (read only) from price guide and not stored.

badger

If I knew how many $ were in a complete set, I'm not sure I would have started.


Determining pricing or value would be tough on some sets. Would you use auction or known sales data? OR grey sheet?

Badger

DIMEMAN

It would use the PCGS price guide.

LindeDad

<< <i>It would use the PCGS price guide. >>



The problen I am trying to point out is that the PCGS price guide has to be corrected. It shows values of coins that are less than grading fee's on the low end. And some coins you can't touch if you bid double the price guide at auction.

Steve

Folks, this is the old story of "what's my coins worth". PCGS could probably price out the current value based on their numbers. No need to keep it private. I do it on an ongoing basis with my registries. Bottom line is I KNOW my coins are worth only what someone else is willing to pay me for them after seeing them in hand. But, knowing the number gives you a ballpark retail value of your collection and then you can go from there. Steve

BAJJERFAN

That feature is available at MyCollection over ta the Heritage site but it gives numismedia wholesale as a quoted price and of course a space for YOUR cost.

NGC has a column for numismedia which I think is the retail price.

Parkekal

I think it has some use for the owner. I would like it as a means to give to my insurance fellow. Are the prices perfect... absolutely not. Does it help an insurance agent have an idea of what they are insuring... I think so.

DIMEMAN

I just think it would be nice to see a "ballpark" figure on the values of my coins without having to go to the price guide.

Does anyone think I should request this?

Jon

slipgate

Just do it yourself... Here is how I do it with Morgan Dollars:

Copy this to notepad and save is as "MorganValue.iqy"

copy between the "****" but no including the "****"

****
WEB
1
http://www.pcgs.com/prices/frame.chtml?type=date&filename=morgan_regular

Selection=14
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
****

When you run the above file, it will open an excel spreadsheet and load the current PCGS coin values for that series. Make sure you save the resulting spreadsheet with the same name every time (MorganValue.xls) (that is, every time you want to update your collection worth). Before I run and save a new value, I save the old one under the date as a file name so that I can trend my investment over time.

FYI: Occasionally PCGS will change the location of the start of the value chart. This is the "Selection=14" option in the above inquiry. You just need to play around with this number. Make it 12, or 13, or 15 for that matter. You can tell from what is generated on the spreadsheet what field in the web page it is reading. It is currently 14 for Morgan dollars.

If you want to track other coins like washington quarters or mercury dimes, it is a simple matter to modify the Excel inquiry.

***Next***

Create an Excel "inventory" spreadsheet with your collection
Make a column for "current PCGS value"
link the contents of this cell to the appropriate cell in the sheet generated when you run the above Excel inquiry. The easiest way to do this is to click the "=" sign in the formula bar, then click on the value spreadsheet (the one generated when you "double-click" the MorganValue.iqy file that you created above), then click the appropriate value cell for type, grade and year.

Once the spreadsheet is set up, it will not need to be setup again unless PCGS changes the format of their website.

FYI: With the way Excel works, you can add and remove coins, removing and adding rows or columns to the inventory spreadsheet, and Excel will update the formulas to reflect the new cell location so that your spreadsheet still "works" and pulls the correct value from the PCGS spreadsheet.

I tried to upload the files but the system would not allow me to upload any files - PM me and I'll email you the files you need, you can then modify them as needed.

DIMEMAN

Slipgate,

I don't want to have to do anything. I just want what is already there displayed on the screen for the coins in my set. Not saved anywhere, so the next time it will be current if any changes where made. I know these prices in the PCGS price guide are just ballpark, but that's all I want. A coin is only worth what you can get for it.

It would just be a neat feature to be able to click on a button and see all your coins (in the set you have up) and there approx. value.



Jon

headsplitter2

Dimeman and Steve are right on target.
Retail pricing with a paid membership.
Heritage BLOW'S with their wholesale prices!(generally you need to add 20-30% more)

slipgate

I agree they should provide this service. From a programming perspective, this is a SIMPLE matter. A competent web programmer could do this in a couple of days. They'd simply add a table column to your registry entries for current PCGS value. That column would pull from their published lists. All the coins have a key - (PCGS No.).

Hell, I could probably write a web site that is totally independant from PCGS that goes and grabs the values. I would set up an input screen where you put the link to your collection, click the "ok" button, and viola! out comes a page that lists your collection along with the current PCGS listed values.

hmmm....

garsmith

<<Does anyone else think it would be nice to be able to see the value of the coins in your set and a total for the set. This would, of course, only be available to the owner of the set.

A button come come on the screen when viewed by the owner. Click on it a the values would be pulled from the PCGS coin prices for each coin in your set. And a total at the bottom.

I think it would be great. And as a programmer, I know it could be done very easy.


Any thoughts????>>

____________________________________________________________________________________________________________________________

You can do this on http://coins.heritagegalleries.com/ if you are registered (registration is free); it is under "My Heritage" - "My Collection" this does basicaly everything you listed above but much more.

You can list your entire collection as one set or you can break it up by coin type. Let me give you a little example of one of my sets "Gold Dollars"

When I open my gold dollar set in the top left corner it has:

Gold Dollarrs
Total for this view $X,XXX.XX (based on the "Numismedia Wholesale Ask' estimate)

Than is has a spead sheet that shows the individual coins that have been entered into the collection, the main information of the spread sheet is:

Coin Description - a description of the coin which includes year, type, grade, grading service, population in that grade and population graded higher
Coin No. - this is a referencing number assigned to the coin type by Heritage
Auction Prices Realized - This link shows you the hammer price for that coin type from all past Heritage auctions
Numismedia Wholesale Ask - Shows the coins current value based on Numismedia Wholesale
Purchase Price - Shows the amount you paid for the coin
Wantlist Demand - Shows how many Heritage members have this coin type listed in their wantlist
Add'l Data -

Below this on the right it has:

Total Purchase Price: $X,XXX.XX

Clicking on the individual coin under "Coin Description" or "Add'l Data" takes you to that coins listing page.

On this page it again shows you the coin description with year, type, grade, grading service, population in that grade and population graded higher
than there is a price guide chart that shows the current value of one grade lower, your coins grade and one grade higher. The values shown come from
Coin World (trends)
Numismedia Wholesale
Mumismedia NGC (nmn)
Munismedia PCGS (nmp)
Coin Universe

Below this are the criteria listing for the coin which include:
Grading Service
Grade
Catagory
Quantity
your ref #
CertID
Source
Date Purchased
Amount Paid
Minimum Selling Price

Than ther are two picture link windows
An area for "Coin Notes:" and an area for "Mics. Notes:"

You can fill in all the information manually or if the coin is one you purchase in a Heritage auction the coin goes into a folder called "Coins from Heritage" you can move the coin from there to your collection and all information from the purchase is automatically added to the set; including the original coin description from the Heritage auction listing.


It takes a couple of tries to get used to the site (I deleted my first couple of attempts) but after you get the hang of it; it is a very helpful and powerful resource. I have all my certified coins listed there by type I also have my uncertified mint and proof sets listed there.

Give it a try if you have some spare time.

G. Smith

I tried to do a link to show you what I listed above, but didn't work because each set is password protected by the person that created the set. (and no I won't give you my password )

slipgate

Thanks! That's awesome! Why reinvent the wheel? Heritage's site is everything you'd ever want in an online inventory. I just set up my account. I like the fact that I can barcode scan PCGS coins!