Skip to content

import broker csv into database to calculate earnings for tax

Notifications You must be signed in to change notification settings

synsi23b/stocksdb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

stocksdb

  1. enter MONGOCON in .env file to connect to mongodb of choice
  2. run import_jpy_rate.py to download exchange rate and fill DB
  3. download Depotumsaetze.csv from flatex -> depotumsaetze -> zeitraum start .. heute -> export csv
  4. run import_depot.py to sanitize the data and fill DB. Running multiple times is no problem, not creating double entries

dbk / credit to freeeee accounting

  1. enter MONGOCON in .env file to connect to mongodb of choice
  2. run import_jpy_rate.py to download exchange rate and fill DB
  3. download dkb statements up to the final rate of a certain quartal
  4. run import dkb_giro & import_dkb_cc
  5. run export_trans_dkb_giro && export_trans_dkb_cc

TODO

  1. build_current_depot -> read transactions add / remove stock to build a readable history. Especially, create Sale history with date / exchange rate bought at. Considering "FIFO" of stocks when buying / selling partials

About

import broker csv into database to calculate earnings for tax

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages