OpenNumismat / open-numismat

OpenNumismat, is intended primarily for registering a collection of coins. But it is also suitable for other types of collectibles - stamps, postcards, badges and more exotic things.
http://opennumismat.github.io/
GNU General Public License v3.0
95 stars 28 forks source link

[Feature Request] Adding historical prices of a coin by years #157

Open NEKolev opened 10 months ago

NEKolev commented 10 months ago

Every year catalogs come out with the new prices of the coins and collectors follow this information. I think it would be very useful to add:

  1. Adding historical prices of a coin by years for different conditions UNC/XF/FV/Fine.

  2. Adding a chart - the prices by years for the specific condition of the coin we have and the price we bought it for. It would be useful to see all prices of identical coins if we have one coin bought at different prices.

  3. Adding a report (can also be seen on the chart from point 2, if possible), which provides the following information: average purchase price, highest purchase price, lowest purchase price, average sale price, highest sale price, lowest sale price. If we have/had several identical coins.

image

NEKolev commented 8 months ago

After thinking about it, I think it would be better to add a completely new nomenclature screen where the file can be exported/imported. The idea is that once the prices for a given country are entered, the catalogue price can be distributed among different people. I’ve thrown out some ideas See the attached Excel file and image. Since there are at least two main price catalogues in Bulgaria, I’ve set it up to enter both prices. For condition, it’s best to have both the European and American markings, because it’s probably different for different countries. I really like the visualisation from the site https://coinstrail.com/catalog/france/louis-xvi/gold-2-louisdor/616ebe932bcbed2eebfee9f3.

Сondition Price.xlsx

prices

The numbers of the coins in the different catalogues will be entered in Classification and thus a check will be made with the prices. image

For investment gold/silver/platinum, it would be good if the prices are not according to the catalogue, but historically according to the daily exchange rate.

@kecskes if you have suggestions or questions, write.

NortonJack commented 7 months ago

Classification, catalog numbers of coins and banknotes are given in various catalogues, so they can be related to prices. Typically, their prices refer to the first 3 or 4 states of preservation. In Poland, the most famous catalogs are Fischer and Parchimowicz coins, Fischer, Miłczak and Lucow banknotes. There are also in other countries, but I am not interested in them so I don't know, catalogs of ancient coins also exist, so it can be done. How to take into account behavioral states. There are also other catalogues, e.g. supply cards or lottery tickets, and they are also catalogued. It would be great if this could be achieved, but collectors also enter transaction prices themselves, which may differ from the catalog prices. It would be necessary to create such ticks, a filter, or the price on the chart or table should be catalog, auction - transactional or average, of course, in a given state of preservation. If it was not to be local but global, the price list is exposed to fake prices, errors and dishonest people. How to verify this? Is it possible to link the price with a link to the archive from where it is taken or given? When it comes to coins and banknotes graded by well-known companies, it is simple because there is something similar on their websites and there is a company that digitizes them and the matter is simpler because we have a catalog number and a specific state of preservation. Everything is described. It would be nice if the charts and tables were more advanced in terms of price analysis, but this could be handled in the future by having prices and inserting several patterns where the program would insert an additional chart. For these digs, you would need to provide some source (link from the auction, etc.) The analysis of coin prices must take into account various descriptions of the states of preservation, in particular the US scales (UNC, AU, EF, etc.) and Europe or Poland (I,1, - mint, I-,1 - around mint, etc.). The idea is brilliant.

NEKolev commented 7 months ago

@NortonJack I was also thinking about the auction prices, the only problem is that the catalogue prices are usually for a given year, and in this year there can be n number of auctions and it can get a little confusing. In the screen where the catalogue/auction price will be entered, there could be a source field where a link can be placed.

NortonJack commented 7 months ago

One more functionality can be added. We have the ability to print collation and collections, so we can add printing labels to various types of labels, or under labels, envelopes, stickers for holders, etc.