Here is a question about maintaining a personal ledger in an SQL database. It seems to have been closed because it was about programming.

In my opinion, this is a valid question about personal bookkeeping, not programming. The core question is: which data should the asker "write down" in his ledger in order to account for changing exchange rates?

The fact that it's an SQL database is merely background information. The exact same question would also apply to a pen-and-paper ledger.

But the question is closed, and apparently, I'm "delusional" (see comments) for thinking this is an accounting question rather than a programming question.

Should this have been closed?

1 Answer 1


Maybe you could salvage the question by stripping out all the business about designing the DB. If the question really is about managing your finances it shouldn't be necessary to ask your question. Your question really seems to be about data modeling and algorithms more than finance the way it is written.

If that is not your intent try removing all the extraneous bit about SQL tables and cursors.

  • 1
    Would the question be off-topic if the DB concepts were replaced by equivalent paper concepts? "I have ruled paper with these columns: timestamp_for_when_it_was_inserted_into_database timestamp_for_when_the_transaction_happened amount currency_code amount_in_EUR_when_it_happened..."
    – user253751
    Dec 15, 2020 at 14:41
  • Probably. the question is a little unfocused.
    – JohnFx Mod
    Dec 15, 2020 at 23:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .