Import transaction records from exported data.

andyblight / share-tracking-1

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

MIT License

0 stars 0 forks source link

Import transaction records from exported data. #6

Closed andyblight closed 2 years ago

andyblight commented 2 years ago

The trading platform can export buy and sell data in XLSX format. It would useful to be able to import the data from those files.

andyblight commented 2 years ago

0845 Commit caf5a4e34b5f92dcc36f3d41d0d291e82b94b2a4 Added file open dialog.

andyblight commented 2 years ago

0915 Commit 78d6ad8d26195b31ca8fd2df482c39bf4c492a74 Prints a selected CSV file.

andyblight commented 2 years ago

1000 1h30 Reads and prints XLSX spreadsheet from SIPP provider.

andyblight commented 2 years ago

3h00 Transform the XLSX data frame into row data for database. Mostly done but the ticker symbol look up is a problem. Issue created to deal with it later.

andyblight commented 2 years ago

1h30 commit f24081871808d7f4df5007d81ac293e1b539fcb7 Can import all transactions from XLSX file with no security relationship.

andyblight commented 2 years ago

1h15 7h15 Commit ac553c8ba09b8099cd21404c59398456228331ea Can now import all securities. Just need to hook the two tables up for transaction imports.

andyblight commented 2 years ago

2h00 9h15 commit b06a13c271c1fd0bb6b3c1a3e16ea764e0c411ee Importing transactions now auto selects securities where there is only one match. Added select security dialog for selecting security from list where more than one security is found. Not working yet.

andyblight commented 2 years ago

1h00 10h15 Fixed installation after upgrading laptop to Ubuntu 22.04, Python 3.10. Found problem when adding transactions, Blackrock fund is treated as a share. Either need to stop select security dialog being shown by identifying Blackrock correctly as a fund or add button to dialog say this is a fund.

andyblight commented 2 years ago

3h00 13h15 Improved method of matching securities in database to values from imported spreadsheet. Single and double click selection works. Not found option works. Added add security dialog for adding funds.

Description from spreadsheet should be populated in the stock name entry box but it isn't.

andyblight commented 2 years ago

Add funds is not so important right now. Add that to another sprint. Only need to get stocks working for now.

andyblight commented 2 years ago

2h45 16h00 Imports most of the data OK. Security is -1 when selected from select security dialog. See #8 Done enough on this one for now.