View holdings - Githubissues

andyblight / share-tracking-1

Share tracking app with a Tcl/TK GUI and SQLite database.

MIT License

0 stars 0 forks source link

View holdings #3

Closed andyblight closed 2 years ago

andyblight commented 2 years ago

At the end of this task, the user will be able to view all current holdings.

[x] Get securities and transactions to be shown on tabbed pages.
[x] Create holdings table class.
[x] Add menu options to update and show the holdings table.
[x] Show holdings table on another tab in the app. Switches to the holdings tab and presents the data.

andyblight commented 2 years ago

This is how to do a basic inner join. sqlite> select date, ticker, quantity from transactions inner join securities on securities.uid = transactions.security_id;

andyblight commented 2 years ago

Commit b36e34b2a79ae87e09c58f78040012103fdb1c59 Securities and transactions tabs work with single labels. Next job is to show and hide the treeview objects. 4hrs

andyblight commented 2 years ago

Commit f3f4066c37d8dfb0a19a7cc157d3513b55585c65 Sorted out tab operation for securities and transactions views. 1hr

andyblight commented 2 years ago

1h30 Commit 6302abc1271ef40a5244cfae275b8225c9f59c8d Added holdings DB wrapper. Not tested.

andyblight commented 2 years ago

2h00 Commit 459392fda3d72b203d0ca785b4d8a324bd76e261 Holdings treeview works with currency values correctly justified and shows correct number of decimals.

andyblight commented 2 years ago

This task is done. Total 8h30