Regular Guy
Ideal_Rock
- Joined
- Jul 6, 2004
- Messages
- 5,962
Dear Friends,
Thanks for helping me understand the databases that make this world go round...
1) Regarding the big database, that is referenced at Dirt Cheap Diamonds and Abazias and White Flash, and by many of the internet vendors who we do have reference to, that includes 50 - 60,000 diamonds ...
a) who populates the data in the databases, gets diamonds into their inventory, and sets prices in them
b) is it clear that among the categories that are included in this big database, different grading categories are available to populate as well, and as a result, when White Flash and DCD has diamonds listed respectively as:
White Flash:
A) Ideal H&A
B) Ideal
C) Very Good
D) Good
Dirt Cheap Diamonds
B) Ideal
C) Premium
D) Average
...they are merely porting over data...whole...with very little manipulation of the information, just bringing over the categories as they find them populated originally.
c) Importantly, what criteria are used to differentiate these grading categories?
d) Although all vendors may be able to access the entire database, do some of them only advertise selectively from them, such that -- for example -- when the diamonds are visible on both the vendor''s databases, as well as Pricescope''s database, why are only even a couple of duplications noted, instead of multiple duplications, represented by each of the participating vendors?
2) Regarding the database of databases, recorded on the Pricescope website itself, it would seem that the data brought over from these distinct databases is massaged as well, although I assume these grading categories are dropped out
a) But, Pricescope then seems to implement it''s own system to massage data and create grading categories; is that right...
b) as for example, it appears that if the user was merely trying to differentiate those diamonds that were categorized as "AGS0," they would check the box at the top left. And that when doing so, the only screening of information that occurs (is this correct?) to differentiate these diamonds is the changing of percentages for both depth and table:
- Without seeking those diamonds specified as AGS0: Table 53 - 62, Depth 58 - 63
- Narrowing to only those that are AGS0, Table 53 - 58, Depth, 58.7 - 62.3
c) and relatedly, it is also likely that, for even those diamonds that appear in the table to begin with, both good/average diamonds may be screened out at the outset, based on the recording of depth and table data.
d) alternately, when H&A is checked, no additional screening of the data presented seems to occur.
3) Just how meaningful is depth and table data? It seems clear that as a validating measure, it is widely enough used, such that it is the only data one can reliably expect to come over and be reported on, from any and all of these databases, including Pricescope''s data.
a) can perhaps a majority of the story about a diamond''s cut be validated by this info, broadly?
b) Specifically, what validity should be given (as some of these databases seem to imply by their inclusion of this data alone) to the idea that is presented, in a plain spoken manner, and seen at Tradeshop.com:
"Various cutters have slightly varied definitions of the ideal cut, but if you keep the table size in the mid-fifties and depth between 58-63% you will have a fantastic diamond, and look...."
4) OK, I''m also interested in both seeing whether a strategy can be implemented to exploit the data to ones personal gain, and also, to explain the (relatively accidental) success I seem to have had in finding the diamond I purchased last month.
1) Regarding my diamond, I was attracted to it from DCD''s website, and presentation on it''s database, because of it''s basic characteristics: weight, color (G), clarity (VS2), and although I may have given passing notice to its depth, table, and culet measurements (62, 55, 0), it had been grouped among those diamonds that were classified as "ideal." both at the DCD site, and also on Pricescope''s database
2) But, when we did get the diamond "in-house," it could be seen because of the crown and pavilion angles (35.8, 40.1), it would otherwise be "classified" as an AGS2 stone, and likewise, it has been appraised accordingly.
3) Also, regarding the diamond''s pricing, to all appearances, it''s pricing had put it among those diamonds that were not specifically ideal (.9 carats, $3316). Jim Schultz had said it was just "well priced," but I had to wonder what process must have been used to set the price, after which it was placed into the larger "database," and made available to DCD and me.
4) Although I thought it might have strategically been placed among the "ideal" category, based on someone understanding it''s excellent cut (HCA = .9), I think it more likely that it was either mis-categorized, or more probably, categorized as ideal simply because of its table and depth measurements, at the outset, but I can only speculate. At least, I can only speculate, until I hear from you(!)
So, there''s a lot here, the last of which is personal, but most of which is quite general. For anyone in or out of the trade who would like to comment -- your feedback is appreciated.
Thanks!
Thanks for helping me understand the databases that make this world go round...
1) Regarding the big database, that is referenced at Dirt Cheap Diamonds and Abazias and White Flash, and by many of the internet vendors who we do have reference to, that includes 50 - 60,000 diamonds ...
a) who populates the data in the databases, gets diamonds into their inventory, and sets prices in them
b) is it clear that among the categories that are included in this big database, different grading categories are available to populate as well, and as a result, when White Flash and DCD has diamonds listed respectively as:
White Flash:
A) Ideal H&A
B) Ideal
C) Very Good
D) Good
Dirt Cheap Diamonds
B) Ideal
C) Premium
D) Average
...they are merely porting over data...whole...with very little manipulation of the information, just bringing over the categories as they find them populated originally.
c) Importantly, what criteria are used to differentiate these grading categories?
d) Although all vendors may be able to access the entire database, do some of them only advertise selectively from them, such that -- for example -- when the diamonds are visible on both the vendor''s databases, as well as Pricescope''s database, why are only even a couple of duplications noted, instead of multiple duplications, represented by each of the participating vendors?
2) Regarding the database of databases, recorded on the Pricescope website itself, it would seem that the data brought over from these distinct databases is massaged as well, although I assume these grading categories are dropped out
a) But, Pricescope then seems to implement it''s own system to massage data and create grading categories; is that right...
b) as for example, it appears that if the user was merely trying to differentiate those diamonds that were categorized as "AGS0," they would check the box at the top left. And that when doing so, the only screening of information that occurs (is this correct?) to differentiate these diamonds is the changing of percentages for both depth and table:
- Without seeking those diamonds specified as AGS0: Table 53 - 62, Depth 58 - 63
- Narrowing to only those that are AGS0, Table 53 - 58, Depth, 58.7 - 62.3
c) and relatedly, it is also likely that, for even those diamonds that appear in the table to begin with, both good/average diamonds may be screened out at the outset, based on the recording of depth and table data.
d) alternately, when H&A is checked, no additional screening of the data presented seems to occur.
3) Just how meaningful is depth and table data? It seems clear that as a validating measure, it is widely enough used, such that it is the only data one can reliably expect to come over and be reported on, from any and all of these databases, including Pricescope''s data.
a) can perhaps a majority of the story about a diamond''s cut be validated by this info, broadly?
b) Specifically, what validity should be given (as some of these databases seem to imply by their inclusion of this data alone) to the idea that is presented, in a plain spoken manner, and seen at Tradeshop.com:
"Various cutters have slightly varied definitions of the ideal cut, but if you keep the table size in the mid-fifties and depth between 58-63% you will have a fantastic diamond, and look...."
4) OK, I''m also interested in both seeing whether a strategy can be implemented to exploit the data to ones personal gain, and also, to explain the (relatively accidental) success I seem to have had in finding the diamond I purchased last month.
1) Regarding my diamond, I was attracted to it from DCD''s website, and presentation on it''s database, because of it''s basic characteristics: weight, color (G), clarity (VS2), and although I may have given passing notice to its depth, table, and culet measurements (62, 55, 0), it had been grouped among those diamonds that were classified as "ideal." both at the DCD site, and also on Pricescope''s database
2) But, when we did get the diamond "in-house," it could be seen because of the crown and pavilion angles (35.8, 40.1), it would otherwise be "classified" as an AGS2 stone, and likewise, it has been appraised accordingly.
3) Also, regarding the diamond''s pricing, to all appearances, it''s pricing had put it among those diamonds that were not specifically ideal (.9 carats, $3316). Jim Schultz had said it was just "well priced," but I had to wonder what process must have been used to set the price, after which it was placed into the larger "database," and made available to DCD and me.
4) Although I thought it might have strategically been placed among the "ideal" category, based on someone understanding it''s excellent cut (HCA = .9), I think it more likely that it was either mis-categorized, or more probably, categorized as ideal simply because of its table and depth measurements, at the outset, but I can only speculate. At least, I can only speculate, until I hear from you(!)
So, there''s a lot here, the last of which is personal, but most of which is quite general. For anyone in or out of the trade who would like to comment -- your feedback is appreciated.
Thanks!