"Value" & multiple currencies
Posted: Sun Jun 26, 2016 2:49 pm
Though I live in the US and purchase most of my books with American currency, my book collection (> 5K volumes) includes many books purchased overseas or from vendors overseas, which are priced in other currencies. I've found Bookpedia (5.4.2) generally to be the best solution for cataloging my collection – and I've tried just about every other such application for Mac OS – but where it badly stumbles for me is its inability to handle more than one currency in tracking the purchase price of books. The current "Value" calculation is of little use to me, as it conflates all currencies. I don't need anything so complex as real-time currency conversion (someone on this forum requested that a few years ago), but a simple tracking of "Value" in different denominations, something other book cataloging apps can handle, would be a big help and not too tricky to implement, I believe.
I think a good way to do this would be to have a preference setting for a default currency, to which all entries in the "Price" field would default. Thus, a book that costs $29.95 could be entered as "29.95" and when the record is updated, "$" would be appended to the field = "$29.95". But when the field is filled with a different currency abbreviation, that would override the auto-appending of the default abbreviation, for example, "€29.95" When "Value" is calculated, Bookpedia could tally the subtotals for the different denominations, something like: "Value: $50,500 + €15,500 + £500". The user can, if she wishes figure out what all that adds up to in her currency of choice.
I think a good way to do this would be to have a preference setting for a default currency, to which all entries in the "Price" field would default. Thus, a book that costs $29.95 could be entered as "29.95" and when the record is updated, "$" would be appended to the field = "$29.95". But when the field is filled with a different currency abbreviation, that would override the auto-appending of the default abbreviation, for example, "€29.95" When "Value" is calculated, Bookpedia could tally the subtotals for the different denominations, something like: "Value: $50,500 + €15,500 + £500". The user can, if she wishes figure out what all that adds up to in her currency of choice.