Anyone have a Split-Grade calculator / spreadsheet?

JZrarities

One of my local dealers has an Excel Spreadsheet that calculates Split-Grades for him.

Say, you have an MS-62, and the guide you're using only has MS-60 and MS-63; the spreadsheet does the math. It looks professional and calculates all split grades.

Has anyone built an Excel Spreadsheet for this yet (before I try to make my own)?

VR, Jeff

STONE

Are we talking exponential growth on a curve for the values between 60 and 63 or is it linear and an approximately equal growth?

I would think it would be some sort of exponential growth since values can change considerably between these grades.

JZrarities

I think the one he has is just simple Linear.

STONE

All you have to do is split the difference and divide by 3 if it's 60 to 63.


Ex. MS60= $100 and MS63= $500

$500 - 100 = $400, 400 / 3 = 133

Therefore MS61= $233 and MS62= $366

JZrarities

I'm looking for a comprehensive spreadsheet to do this for all the split grades.

Difference and divide by three works for the 60-63 range. But, VF-20 to VF-35 is four ranges.

It was neat to see his spreadsheet do this...just plug the two prices.

SilverEagles92

Why don't you ask him? He might even be willing to save a copy of it for you to disk.

JZrarities

<< <i>Why don't you ask him? He might even be willing to save a copy of it for you to disk. >>



I think I might do that...

LindeDad

The "What If" function of the PCGS regisrty does that very well based on the PCGS Price Guide info.

jessewvu

It usually isn't linear. Interpolation or your "line fit" method isn't going to be acurate is it?

savoyspecial

there are certain coins this just will not work for......as discussed earlier the jump in price between grades is not linear.......1901 and 1886-O Morgans come to mind

greg

savoyspecial

one further thought: in most series MS65 still holds a hallowed spot in the mind of the collector base.......because of this the 64/65 jump is typically one of the most extreme

greg

JZrarities

IMHO there is no 'right' answer to the pricing. If you plot a pricing curve for a coin, it sure isn't linear, nor is it exactly pure exponential.

For some lower grades it will be more linear, but plot prices from 64 to 65 to 66 on a graph, and they probably won't fit an exponential curve either.

I just need a simple spreadsheet, to bring to a show, that quickly answers the VF-35, AU-53 and MS-62 split grades. Linear would do.

Coin pricing is SO far from an exact science, even with an established holder grade.

Julian

IMHO, there are no formulas possible for pricing.

Each coin must be evaluated on its own, with the possible exception of some generic items like common date BU Morgans, Saints, Walkers, etc.