database
database copied to clipboard
Consolidate stocks with checking accounts
Idea
- Treat all currencies, crypto-currencies and stock shares as a single entity used to describe transaction/account value.
- Reuse checking accounts for both investment and share accounts and store stock purchase/selling transactions as transfers with AMOUNT and TOAMOUNT values.
- Reuse currency history table for storing stock history too.
Benefits
- Model simplification, model code reuse
- Database simplification - consolidate similar entities, enabler for foreign keys implementation #23
- Possibility to reuse generic GUI panels, dialogs etc. moneymanagerex/moneymanagerex#1751
- No need to implement missing GUI elements for shares/investments accounts moneymanagerex/moneymanagerex#1752
- Eliminate separate implementation for commision and use the same implementation for both commision and payment of the dividend (and fee for transfers beetwen normal accounts)
- Ability to report foreign currency or cypto-currency buying as investments moneymanagerex/moneymanagerex#1834
- Eliminate current errors in investment/share implementations moneymanagerex/moneymanagerex#1691 moneymanagerex/moneymanagerex#1679
- Ability to define BILLDEPOSITS for shares and use to implement regular contributions to a pension scheme