I'm using this to learn Django.

Be able to take info from my ledger file and provide performance information that can be slided and diced in many ways

It will be important to be able to tag transactions to see how transactions with different tags compare in performance. (e.g. index-based investing versus stock-picking etc). But, we'll have to decide how to deal with cash in those situations.

So individual transactions can't really be tagged like that. It has to be accounts which are tagged since accounts include both cash and positions.

Maybe we can make those virtual accounts in some way. OK, that will have to be decided later...

Keep track of my stock transactions and give me simple reports about their performance. Are they up or down and by how many percentage points?

Account

• user_id (assuming I have some user registration)
• name
• taxable? (boolean)

Securities

• symbol
• name
• type (stock/MF/ETF)
• exchange

Transactions

• timestamp
• action (BUY/SELL/DIV/INT/SS)
• security FK
• account FK
• shares
• price
• commission

Closing Prices

• security FK
• timestamp
• price