ChrisRBe
commented
2 years ago hey @pedrojvaz,
do you have a sample file that I could test this locally?
Closed pedrojvaz closed 2 years ago
ChrisRBe
commented
2 years ago hey @pedrojvaz,
do you have a sample file that I could test this locally?
pedrojvaz
commented
2 years ago Sure !
The input file: 20220313-account-statement.csv
and the output: portfolio_performance__mintos.csv
Note the weir numbers on the output file
Thanks
ChrisRBe
commented
2 years ago Could you please use the branch from PR https://github.com/ChrisRBe/PP-P2P-Parser/pull/516 to generate the output again? Could you please run the script with the --debug flag and copy and paste me from the console output the relevant parts from the beginning?
You should find something like this in your console:
2022-03-13 16:44:23,784 src.p2p_config INFO Config done.
2022-03-13 16:44:23,784 src.p2p_statement_parser INFO Loading account statement
2022-03-13 16:44:23,787 src.p2p_statement_parser DEBUG entry type is Einlage. new entry date is 2019-10-30. value of entry: 750.0
2022-03-13 16:44:23,787 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-10-30. value of entry: 0.002916667
2022-03-13 16:44:23,789 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-10-31. value of entry: 0.005277778
2022-03-13 16:44:23,789 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-01. value of entry: 0.029626667Sorry @ChrisRBe , you need to guide me here, please. How do I get the #516 in my system?
ChrisRBe
commented
2 years ago Ah. Sorry. How did you run the script before? How did you download it?
pedrojvaz
commented
2 years ago I have a linux box and ran the git clone command. I just don't know how to move to a different version :-)
ChrisRBe
commented
2 years ago Okay. Not a problem.
git pull
git checkout -t origin/feature/debug-issue-515This should land you on the new branch. Using the -t option if I update anything, you should simply be able to do a git pull and have it locally as well.
pedrojvaz
commented
2 years ago Thanks, i was also reading about it but had not been able yet to do it.
Update:
@ ➜ PP-P2P-Parser git:(master) ✗ git pull
hint: Pulling without specifying how to reconcile divergent branches is
hint: discouraged. You can squelch this message by running one of the following
hint: commands sometime before your next pull:
hint:
hint: git config pull.rebase false # merge (the default strategy)
hint: git config pull.rebase true # rebase
hint: git config pull.ff only # fast-forward only
hint:
hint: You can replace "git config" with "git config --global" to set a default
hint: preference for all repositories. You can also pass --rebase, --no-rebase,
hint: or --ff-only on the command line to override the configured default per
hint: invocation.
remote: Enumerating objects: 4, done.
remote: Counting objects: 100% (4/4), done.
remote: Total 4 (delta 3), reused 4 (delta 3), pack-reused 0
Unpacking objects: 100% (4/4), 504 bytes | 126.00 KiB/s, done.
From https://github.com/ChrisRBe/PP-P2P-Parser
* [new branch] feature/debug-issue-515 -> origin/feature/debug-issue-515
Already up to date.
@ ➜ PP-P2P-Parser git:(master) ✗ git checkout -t origin/feature/debug-issue-515
Branch 'feature/debug-issue-515' set up to track remote branch 'feature/debug-issue-515' from 'origin'.
Switched to a new branch 'feature/debug-issue-515'
@ ➜ PP-P2P-Parser git:(feature/debug-issue-515) ✗And the output:
python3 parse-account-statements.py 20220313-account-statement.csv --type mintos --aggregate daily --debug
2022-03-13 17:32:37,887 parse-account-statements INFO Parsing peer to peer lending site account statements with the following options:
2022-03-13 17:32:37,887 parse-account-statements INFO Account statement file: 20220313-account-statement.csv
2022-03-13 17:32:37,887 parse-account-statements INFO Peer to peer platform: MINTOS
2022-03-13 17:32:37,887 parse-account-statements INFO Aggregation type: DAILY
2022-03-13 17:32:37,887 parse-account-statements INFO Loading config for mintos
2022-03-13 17:32:37,888 src.p2p_statement_parser INFO Aggregating data on a daily basis
2022-03-13 17:32:37,891 src.p2p_config INFO Setup config for statement parser. Run with --debug to see config values
2022-03-13 17:32:37,891 src.p2p_config DEBUG Config settings: {'type_regex': {'deposit': '(Deposits)|(^Incoming client.*)|(^Incoming currency exchange.*)|(^Affiliate partner bonus$)', 'withdraw': '(^Withdraw application.*)|(Outgoing currency.*)|(Withdrawal)', 'interest': '(^Delayed interest.*)|(^Late payment.*)|(^Interest income.*)|(^Cashback.*)|(^.*[Ii]nterest received.*)|(^.*late fees received$)', 'fee': '(^FX commission.*)|(.*secondary market fee$)', 'ignorable_entry': '.*investment in loan.*|.*[Pp]rincipal received.*|.*secondary market transaction.*', 'special_entry': '(.*discount/premium.*)'}, 'csv_fieldnames': {'booking_date': 'Date', 'booking_date_format': '%Y-%m-%d %H:%M:%S', 'booking_details': 'Details', 'booking_id': 'Transaction ID:', 'booking_type': 'Details', 'booking_value': 'Turnover', 'booking_currency': 'Currency'}}
2022-03-13 17:32:37,894 src.p2p_config INFO Config done.
2022-03-13 17:32:37,894 src.p2p_statement_parser INFO Loading account statement
2022-03-13 17:32:37,899 src.p2p_statement_parser DEBUG entry type is Einlage. new entry date is 2019-10-30. value of entry: 750.0
2022-03-13 17:32:37,899 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-10-30. value of entry: 0.002916667
2022-03-13 17:32:37,902 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-10-31. value of entry: 0.005277778
2022-03-13 17:32:37,902 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-01. value of entry: 0.029626667
2022-03-13 17:32:37,902 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.002222222
2022-03-13 17:32:37,903 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.005555556
2022-03-13 17:32:37,903 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,903 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.010555556
2022-03-13 17:32:37,903 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,903 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.008703333
2022-03-13 17:32:37,904 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,904 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.0083475
2022-03-13 17:32:37,904 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.024444444
2022-03-13 17:32:37,904 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,904 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.007222222
2022-03-13 17:32:37,905 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,905 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.005555556
2022-03-13 17:32:37,905 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,905 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.012777778
2022-03-13 17:32:37,905 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,906 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.00245
2022-03-13 17:32:37,906 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,906 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.000333333
2022-03-13 17:32:37,906 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,906 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-04. value of entry: 0.000666667
2022-03-13 17:32:37,906 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-05. value of entry: 0.034785833
2022-03-13 17:32:37,907 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-05. value of entry: 0.00297
2022-03-13 17:32:37,907 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,907 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-07. value of entry: 0.02
2022-03-13 17:32:37,907 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-08. value of entry: 0.027777778
2022-03-13 17:32:37,907 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-08. value of entry: 0.0458
2022-03-13 17:32:37,907 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,908 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-09. value of entry: 0.014953919
2022-03-13 17:32:37,908 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-09. value of entry: 0.0275
2022-03-13 17:32:37,908 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,908 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.035138889
2022-03-13 17:32:37,909 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.004047361
2022-03-13 17:32:37,909 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,909 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.00274
2022-03-13 17:32:37,909 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,909 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-11. value of entry: 0.003025
2022-03-13 17:32:37,910 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-12. value of entry: 0.05502
2022-03-13 17:32:37,910 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.0225
2022-03-13 17:32:37,910 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.026388889
2022-03-13 17:32:37,910 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,910 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.001981171
2022-03-13 17:32:37,910 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,911 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.02369
2022-03-13 17:32:37,911 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,911 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.033055556
2022-03-13 17:32:37,911 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,911 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-14. value of entry: 0.048888889
2022-03-13 17:32:37,911 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-15. value of entry: 0.007982917
2022-03-13 17:32:37,912 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.108611111
2022-03-13 17:32:37,912 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.013869167
2022-03-13 17:32:37,912 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,912 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.014677004
2022-03-13 17:32:37,912 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,912 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.045255
2022-03-13 17:32:37,912 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,913 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-17. value of entry: 0.039583333
2022-03-13 17:32:37,913 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.014119444
2022-03-13 17:32:37,913 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.061111111
2022-03-13 17:32:37,913 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,914 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.014033333
2022-03-13 17:32:37,914 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,914 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.004722222
2022-03-13 17:32:37,914 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,914 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.104561111
2022-03-13 17:32:37,914 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.016666667
2022-03-13 17:32:37,914 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,915 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.004666667
2022-03-13 17:32:37,915 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,915 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.013261111
2022-03-13 17:32:37,915 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,915 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.025006667
2022-03-13 17:32:37,915 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,915 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.0057475
2022-03-13 17:32:37,916 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,916 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.048888889
2022-03-13 17:32:37,916 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,916 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.012777778
2022-03-13 17:32:37,916 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.054305556
2022-03-13 17:32:37,916 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,916 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.055416667
2022-03-13 17:32:37,917 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,917 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.033135972
2022-03-13 17:32:37,917 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,917 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.002215614
2022-03-13 17:32:37,917 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,917 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.052416667
2022-03-13 17:32:37,918 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,918 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.000257535
2022-03-13 17:32:37,918 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,918 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.1662325
2022-03-13 17:32:37,918 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.013235
2022-03-13 17:32:37,918 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,919 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.153333333
2022-03-13 17:32:37,919 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,919 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.067083333
2022-03-13 17:32:37,919 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,919 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.237966667
2022-03-13 17:32:37,920 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.01440009
2022-03-13 17:32:37,920 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,920 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.029746667
2022-03-13 17:32:37,920 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,920 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.083333333
2022-03-13 17:32:37,920 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,921 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.052777778
2022-03-13 17:32:37,921 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.057166885
2022-03-13 17:32:37,921 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,921 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.008888889
2022-03-13 17:32:37,921 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,921 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.02375
2022-03-13 17:32:37,921 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,922 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.072222222
2022-03-13 17:32:37,922 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,922 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.083055556
2022-03-13 17:32:37,922 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,922 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.083055556
2022-03-13 17:32:37,922 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.077906111
2022-03-13 17:32:37,923 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,923 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.004722222
2022-03-13 17:32:37,923 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,923 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.014590278
2022-03-13 17:32:37,923 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,923 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.067222222
2022-03-13 17:32:37,923 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,924 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.011613333
2022-03-13 17:32:37,924 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,924 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.000623267
2022-03-13 17:32:37,924 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,924 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.057777778
2022-03-13 17:32:37,924 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,924 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.07044
2022-03-13 17:32:37,925 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,925 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.160954444
2022-03-13 17:32:37,925 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,925 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.343994444
2022-03-13 17:32:37,925 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,925 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.201709444
2022-03-13 17:32:37,925 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,926 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.080689185
2022-03-13 17:32:37,926 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.014054444
2022-03-13 17:32:37,926 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,926 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.073333333
2022-03-13 17:32:37,926 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,926 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.085555556
2022-03-13 17:32:37,927 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,927 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.06
2022-03-13 17:32:37,927 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.085555556
2022-03-13 17:32:37,927 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,927 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.033350089
2022-03-13 17:32:37,927 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,928 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.081666667
2022-03-13 17:32:37,928 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,928 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.0084
2022-03-13 17:32:37,928 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.056666667
2022-03-13 17:32:37,928 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,928 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.00476
2022-03-13 17:32:37,929 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,929 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.008377115
2022-03-13 17:32:37,929 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,929 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.001534722
2022-03-13 17:32:37,929 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,929 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.083333333
2022-03-13 17:32:37,930 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.026444444
2022-03-13 17:32:37,930 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,930 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.0030825
2022-03-13 17:32:37,930 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,930 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-30. value of entry: 0.014123175
2022-03-13 17:32:37,931 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-30. value of entry: 0.0225
2022-03-13 17:32:37,931 src.p2p_statement_parser DEBUG add to existing entry
2022-03-13 17:32:37,931 parse-account-statements INFO Account statement parsing finished. Found (and aggregated) 31 transactions
2022-03-13 17:32:37,931 parse-account-statements INFO Writing Portfolio Performance compatible CSV file.
2022-03-13 17:32:37,931 src.portfolio_writer DEBUG Datum,Wert,Buchungswährung,Typ,Notiz
2019-10-30,"750,00000000",EUR,Einlage,Tageszusammenfassung
2019-10-30,"0,00291667",EUR,Zinsen,Tageszusammenfassung
2019-10-31,"0,00527778",EUR,Zinsen,Tageszusammenfassung
2019-11-01,"0,02962667",EUR,Zinsen,Tageszusammenfassung
2019-11-02,"0,02703667",EUR,Zinsen,Tageszusammenfassung
2019-11-03,"0,06113083",EUR,Zinsen,Tageszusammenfassung
2019-11-04,"0,00066667",EUR,Zinsen,Tageszusammenfassung
2019-11-05,"0,03775583",EUR,Zinsen,Tageszusammenfassung
2019-11-07,"0,02000000",EUR,Zinsen,Tageszusammenfassung
2019-11-08,"0,07357778",EUR,Zinsen,Tageszusammenfassung
2019-11-09,"0,04245392",EUR,Zinsen,Tageszusammenfassung
2019-11-10,"0,04192625",EUR,Zinsen,Tageszusammenfassung
2019-11-11,"0,00302500",EUR,Zinsen,Tageszusammenfassung
2019-11-12,"0,05502000",EUR,Zinsen,Tageszusammenfassung
2019-11-13,"0,10761562",EUR,Zinsen,Tageszusammenfassung
2019-11-14,"0,04888889",EUR,Zinsen,Tageszusammenfassung
2019-11-15,"0,00798292",EUR,Zinsen,Tageszusammenfassung
2019-11-16,"0,18241228",EUR,Zinsen,Tageszusammenfassung
2019-11-17,"0,03958333",EUR,Zinsen,Tageszusammenfassung
2019-11-19,"0,09398611",EUR,Zinsen,Tageszusammenfassung
2019-11-20,"0,21879861",EUR,Zinsen,Tageszusammenfassung
2019-11-21,"0,21052579",EUR,Zinsen,Tageszusammenfassung
2019-11-22,"0,39988417",EUR,Zinsen,Tageszusammenfassung
2019-11-23,"0,36544676",EUR,Zinsen,Tageszusammenfassung
2019-11-24,"0,29786133",EUR,Zinsen,Tageszusammenfassung
2019-11-25,"1,09460910",EUR,Zinsen,Tageszusammenfassung
2019-11-26,"0,25363252",EUR,Zinsen,Tageszusammenfassung
2019-11-27,"0,26057231",EUR,Zinsen,Tageszusammenfassung
2019-11-28,"0,07973850",EUR,Zinsen,Tageszusammenfassung
2019-11-29,"0,11286028",EUR,Zinsen,Tageszusammenfassung
2019-11-30,"0,03662318",EUR,Zinsen,TageszusammenfassungAnd the file... portfolio_performance__mintos.csv
ChrisRBe
commented
2 years ago hmm.. I think I have an idea why this is a problem in you case... Before writing the data into the csv file I am doing a decimal replace here:
For testing purposes.. .Could you remove the replace locally?
I need to add some logic that the script should be locale aware... good luck me. I guess in that pass I could also look at replacing the built-in csv handler with pandas... maybe that would make my life easier here? I don't know.
Will try to have a look next weekend maybe.
pedrojvaz
commented
2 years ago I've changed line 53 and now it seems to work just fine! Sorry for the delay
python3 parse-account-statements.py 20220313-account-statement.csv --type mintos --aggregate daily --debug
2022-03-25 21:58:19,058 parse-account-statements INFO Parsing peer to peer lending site account statements with the following options:
2022-03-25 21:58:19,058 parse-account-statements INFO Account statement file: 20220313-account-statement.csv
2022-03-25 21:58:19,058 parse-account-statements INFO Peer to peer platform: MINTOS
2022-03-25 21:58:19,058 parse-account-statements INFO Aggregation type: DAILY
2022-03-25 21:58:19,058 parse-account-statements INFO Loading config for mintos
2022-03-25 21:58:19,059 src.p2p_statement_parser INFO Aggregating data on a daily basis
2022-03-25 21:58:19,063 src.p2p_config INFO Setup config for statement parser. Run with --debug to see config values
2022-03-25 21:58:19,063 src.p2p_config DEBUG Config settings: {'type_regex': {'deposit': '(Deposits)|(^Incoming client.*)|(^Incoming currency exchange.*)|(^Affiliate partner bonus$)', 'withdraw': '(^Withdraw application.*)|(Outgoing currency.*)|(Withdrawal)', 'interest': '(^Delayed interest.*)|(^Late payment.*)|(^Interest income.*)|(^Cashback.*)|(^.*[Ii]nterest received.*)|(^.*late fees received$)', 'fee': '(^FX commission.*)|(.*secondary market fee$)', 'ignorable_entry': '.*investment in loan.*|.*[Pp]rincipal received.*|.*secondary market transaction.*', 'special_entry': '(.*discount/premium.*)'}, 'csv_fieldnames': {'booking_date': 'Date', 'booking_date_format': '%Y-%m-%d %H:%M:%S', 'booking_details': 'Details', 'booking_id': 'Transaction ID:', 'booking_type': 'Details', 'booking_value': 'Turnover', 'booking_currency': 'Currency'}}
2022-03-25 21:58:19,065 src.p2p_config INFO Config done.
2022-03-25 21:58:19,065 src.p2p_statement_parser INFO Loading account statement
2022-03-25 21:58:19,071 src.p2p_statement_parser DEBUG entry type is Einlage. new entry date is 2019-10-30. value of entry: 750.0
2022-03-25 21:58:19,072 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-10-30. value of entry: 0.002916667
2022-03-25 21:58:19,074 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-10-31. value of entry: 0.005277778
2022-03-25 21:58:19,075 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-01. value of entry: 0.029626667
2022-03-25 21:58:19,075 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.002222222
2022-03-25 21:58:19,075 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.005555556
2022-03-25 21:58:19,075 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,076 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.010555556
2022-03-25 21:58:19,076 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,076 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.008703333
2022-03-25 21:58:19,076 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,076 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.0083475
2022-03-25 21:58:19,077 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.024444444
2022-03-25 21:58:19,077 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,077 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.007222222
2022-03-25 21:58:19,077 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,077 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.005555556
2022-03-25 21:58:19,078 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,078 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.012777778
2022-03-25 21:58:19,078 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,078 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.00245
2022-03-25 21:58:19,078 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,079 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.000333333
2022-03-25 21:58:19,079 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,079 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-04. value of entry: 0.000666667
2022-03-25 21:58:19,079 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-05. value of entry: 0.034785833
2022-03-25 21:58:19,079 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-05. value of entry: 0.00297
2022-03-25 21:58:19,079 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,080 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-07. value of entry: 0.02
2022-03-25 21:58:19,080 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-08. value of entry: 0.027777778
2022-03-25 21:58:19,080 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-08. value of entry: 0.0458
2022-03-25 21:58:19,080 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,081 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-09. value of entry: 0.014953919
2022-03-25 21:58:19,081 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-09. value of entry: 0.0275
2022-03-25 21:58:19,081 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,081 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.035138889
2022-03-25 21:58:19,081 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.004047361
2022-03-25 21:58:19,082 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,082 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.00274
2022-03-25 21:58:19,082 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,082 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-11. value of entry: 0.003025
2022-03-25 21:58:19,083 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-12. value of entry: 0.05502
2022-03-25 21:58:19,083 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.0225
2022-03-25 21:58:19,083 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.026388889
2022-03-25 21:58:19,083 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,083 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.001981171
2022-03-25 21:58:19,083 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,084 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.02369
2022-03-25 21:58:19,084 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,084 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.033055556
2022-03-25 21:58:19,084 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,084 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-14. value of entry: 0.048888889
2022-03-25 21:58:19,084 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-15. value of entry: 0.007982917
2022-03-25 21:58:19,085 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.108611111
2022-03-25 21:58:19,085 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.013869167
2022-03-25 21:58:19,085 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,085 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.014677004
2022-03-25 21:58:19,085 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,086 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.045255
2022-03-25 21:58:19,086 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,086 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-17. value of entry: 0.039583333
2022-03-25 21:58:19,086 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.014119444
2022-03-25 21:58:19,086 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.061111111
2022-03-25 21:58:19,086 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,087 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.014033333
2022-03-25 21:58:19,087 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,087 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.004722222
2022-03-25 21:58:19,087 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,087 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.104561111
2022-03-25 21:58:19,088 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.016666667
2022-03-25 21:58:19,088 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,088 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.004666667
2022-03-25 21:58:19,088 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,088 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.013261111
2022-03-25 21:58:19,088 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,088 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.025006667
2022-03-25 21:58:19,089 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,089 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.0057475
2022-03-25 21:58:19,089 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,089 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.048888889
2022-03-25 21:58:19,089 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,089 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.012777778
2022-03-25 21:58:19,090 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.054305556
2022-03-25 21:58:19,090 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,090 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.055416667
2022-03-25 21:58:19,090 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,090 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.033135972
2022-03-25 21:58:19,090 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,091 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.002215614
2022-03-25 21:58:19,091 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,091 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.052416667
2022-03-25 21:58:19,091 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,091 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.000257535
2022-03-25 21:58:19,091 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,091 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.1662325
2022-03-25 21:58:19,092 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.013235
2022-03-25 21:58:19,092 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,092 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.153333333
2022-03-25 21:58:19,092 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,092 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.067083333
2022-03-25 21:58:19,092 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,093 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.237966667
2022-03-25 21:58:19,093 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.01440009
2022-03-25 21:58:19,093 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,093 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.029746667
2022-03-25 21:58:19,093 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,094 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.083333333
2022-03-25 21:58:19,094 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,094 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.052777778
2022-03-25 21:58:19,094 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.057166885
2022-03-25 21:58:19,094 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,095 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.008888889
2022-03-25 21:58:19,095 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,095 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.02375
2022-03-25 21:58:19,095 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,095 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.072222222
2022-03-25 21:58:19,095 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,095 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.083055556
2022-03-25 21:58:19,095 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,096 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.083055556
2022-03-25 21:58:19,096 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.077906111
2022-03-25 21:58:19,096 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,096 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.004722222
2022-03-25 21:58:19,096 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,097 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.014590278
2022-03-25 21:58:19,097 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,097 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.067222222
2022-03-25 21:58:19,097 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,097 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.011613333
2022-03-25 21:58:19,097 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,097 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.000623267
2022-03-25 21:58:19,097 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,098 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.057777778
2022-03-25 21:58:19,098 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,098 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.07044
2022-03-25 21:58:19,098 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,098 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.160954444
2022-03-25 21:58:19,098 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,098 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.343994444
2022-03-25 21:58:19,098 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,099 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.201709444
2022-03-25 21:58:19,099 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,099 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.080689185
2022-03-25 21:58:19,099 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.014054444
2022-03-25 21:58:19,099 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,099 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.073333333
2022-03-25 21:58:19,099 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,100 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.085555556
2022-03-25 21:58:19,100 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,100 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.06
2022-03-25 21:58:19,100 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.085555556
2022-03-25 21:58:19,100 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,101 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.033350089
2022-03-25 21:58:19,101 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,101 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.081666667
2022-03-25 21:58:19,101 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,101 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.0084
2022-03-25 21:58:19,101 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.056666667
2022-03-25 21:58:19,101 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,102 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.00476
2022-03-25 21:58:19,102 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,102 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.008377115
2022-03-25 21:58:19,102 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,102 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.001534722
2022-03-25 21:58:19,102 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,103 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.083333333
2022-03-25 21:58:19,103 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.026444444
2022-03-25 21:58:19,103 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,103 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.0030825
2022-03-25 21:58:19,103 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,104 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-30. value of entry: 0.014123175
2022-03-25 21:58:19,104 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-30. value of entry: 0.0225
2022-03-25 21:58:19,104 src.p2p_statement_parser DEBUG add to existing entry
2022-03-25 21:58:19,104 parse-account-statements INFO Account statement parsing finished. Found (and aggregated) 31 transactions
2022-03-25 21:58:19,104 parse-account-statements INFO Writing Portfolio Performance compatible CSV file.
2022-03-25 21:58:19,105 src.portfolio_writer DEBUG Datum,Wert,Buchungswährung,Typ,Notiz
2019-10-30,750.0,EUR,Einlage,Tageszusammenfassung
2019-10-30,0.002916667,EUR,Zinsen,Tageszusammenfassung
2019-10-31,0.005277778,EUR,Zinsen,Tageszusammenfassung
2019-11-01,0.029626667,EUR,Zinsen,Tageszusammenfassung
2019-11-02,0.027036667,EUR,Zinsen,Tageszusammenfassung
2019-11-03,0.061130833,EUR,Zinsen,Tageszusammenfassung
2019-11-04,0.000666667,EUR,Zinsen,Tageszusammenfassung
2019-11-05,0.037755833,EUR,Zinsen,Tageszusammenfassung
2019-11-07,0.02,EUR,Zinsen,Tageszusammenfassung
2019-11-08,0.073577778,EUR,Zinsen,Tageszusammenfassung
2019-11-09,0.042453919,EUR,Zinsen,Tageszusammenfassung
2019-11-10,0.04192625,EUR,Zinsen,Tageszusammenfassung
2019-11-11,0.003025,EUR,Zinsen,Tageszusammenfassung
2019-11-12,0.05502,EUR,Zinsen,Tageszusammenfassung
2019-11-13,0.107615616,EUR,Zinsen,Tageszusammenfassung
2019-11-14,0.048888889,EUR,Zinsen,Tageszusammenfassung
2019-11-15,0.007982917,EUR,Zinsen,Tageszusammenfassung
2019-11-16,0.182412282,EUR,Zinsen,Tageszusammenfassung
2019-11-17,0.039583333,EUR,Zinsen,Tageszusammenfassung
2019-11-19,0.09398611,EUR,Zinsen,Tageszusammenfassung
2019-11-20,0.218798612,EUR,Zinsen,Tageszusammenfassung
2019-11-21,0.210525789,EUR,Zinsen,Tageszusammenfassung
2019-11-22,0.399884166,EUR,Zinsen,Tageszusammenfassung
2019-11-23,0.365446757,EUR,Zinsen,Tageszusammenfassung
2019-11-24,0.29786133,EUR,Zinsen,Tageszusammenfassung
2019-11-25,1.094609099,EUR,Zinsen,Tageszusammenfassung
2019-11-26,0.253632518,EUR,Zinsen,Tageszusammenfassung
2019-11-27,0.260572312,EUR,Zinsen,Tageszusammenfassung
2019-11-28,0.079738504,EUR,Zinsen,Tageszusammenfassung
2019-11-29,0.112860277,EUR,Zinsen,Tageszusammenfassung
2019-11-30,0.036623175,EUR,Zinsen,TageszusammenfassungGood to know that this fixed it for you. I will try and have a look into providing a more robust fix as well.
pedrojvaz
commented
2 years ago Perfect! Just one more thing, before I open a new ticket. If this is to be imported in All Securities -> My Security -> Quotes -> Import from CSV file the results don't make sense. I would expect that the €750 investment of October 30 to be worth €754.21 (sum o Wert column) but I don't see that in PP
ChrisRBe
commented
2 years ago Hi @pedrojvaz,
two things. I updated #516 with improved locale handling. Could you give that branch a try?
Secondly, I usually import all my updates through Files -> Import -> CSV files . I haven't used the other interface, so I can't say for sure that it will be the same.
What I noticed on my end though when importing the corrected csv into an English layout Portfolio Performance, I had to manually change most options in the import screen:
Before:
After:
Afterwards I got the correct value in PP:
pedrojvaz
commented
2 years ago I just update to the latest version and ran it with the same file. All seems ok! Here's the log:
python3 parse-account-statements.py 20220313-account-statement.csv --type mintos --aggregate daily --debug
2022-03-26 17:41:57,000 parse-account-statements INFO Parsing peer to peer lending site account statements with the following options:
2022-03-26 17:41:57,000 parse-account-statements INFO Account statement file: 20220313-account-statement.csv
2022-03-26 17:41:57,000 parse-account-statements INFO Peer to peer platform: MINTOS
2022-03-26 17:41:57,000 parse-account-statements INFO Aggregation type: DAILY
2022-03-26 17:41:57,000 parse-account-statements INFO Loading config for mintos
2022-03-26 17:41:57,000 src.p2p_statement_parser INFO Aggregating data on a daily basis
2022-03-26 17:41:57,004 src.p2p_config INFO Setup config for statement parser. Run with --debug to see config values
2022-03-26 17:41:57,004 src.p2p_config DEBUG Config settings: {'type_regex': {'deposit': '(Deposits)|(^Incoming client.*)|(^Incoming currency exchange.*)|(^Affiliate partner bonus$)', 'withdraw': '(^Withdraw application.*)|(Outgoing currency.*)|(Withdrawal)', 'interest': '(^Delayed interest.*)|(^Late payment.*)|(^Interest income.*)|(^Cashback.*)|(^.*[Ii]nterest received.*)|(^.*late fees received$)', 'fee': '(^FX commission.*)|(.*secondary market fee$)', 'ignorable_entry': '.*investment in loan.*|.*[Pp]rincipal received.*|.*secondary market transaction.*', 'special_entry': '(.*discount/premium.*)'}, 'csv_fieldnames': {'booking_date': 'Date', 'booking_date_format': '%Y-%m-%d %H:%M:%S', 'booking_details': 'Details', 'booking_id': 'Transaction ID:', 'booking_type': 'Details', 'booking_value': 'Turnover', 'booking_currency': 'Currency'}}
2022-03-26 17:41:57,006 src.p2p_config INFO Config done.
2022-03-26 17:41:57,007 src.p2p_statement_parser INFO Loading account statement
2022-03-26 17:41:57,011 src.p2p_statement_parser DEBUG entry type is Einlage. new entry date is 2019-10-30. value of entry: 750.0
2022-03-26 17:41:57,012 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-10-30. value of entry: 0.002916667
2022-03-26 17:41:57,014 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-10-31. value of entry: 0.005277778
2022-03-26 17:41:57,015 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-01. value of entry: 0.029626667
2022-03-26 17:41:57,015 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.002222222
2022-03-26 17:41:57,015 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.005555556
2022-03-26 17:41:57,015 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,015 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.010555556
2022-03-26 17:41:57,016 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,016 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-02. value of entry: 0.008703333
2022-03-26 17:41:57,016 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,016 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.0083475
2022-03-26 17:41:57,016 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.024444444
2022-03-26 17:41:57,016 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,017 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.007222222
2022-03-26 17:41:57,017 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,017 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.005555556
2022-03-26 17:41:57,017 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,018 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.012777778
2022-03-26 17:41:57,018 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,018 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.00245
2022-03-26 17:41:57,018 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,018 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-03. value of entry: 0.000333333
2022-03-26 17:41:57,019 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,019 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-04. value of entry: 0.000666667
2022-03-26 17:41:57,019 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-05. value of entry: 0.034785833
2022-03-26 17:41:57,019 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-05. value of entry: 0.00297
2022-03-26 17:41:57,019 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,020 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-07. value of entry: 0.02
2022-03-26 17:41:57,020 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-08. value of entry: 0.027777778
2022-03-26 17:41:57,020 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-08. value of entry: 0.0458
2022-03-26 17:41:57,020 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,020 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-09. value of entry: 0.014953919
2022-03-26 17:41:57,021 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-09. value of entry: 0.0275
2022-03-26 17:41:57,021 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,021 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.035138889
2022-03-26 17:41:57,021 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.004047361
2022-03-26 17:41:57,021 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,022 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-10. value of entry: 0.00274
2022-03-26 17:41:57,022 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,022 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-11. value of entry: 0.003025
2022-03-26 17:41:57,022 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-12. value of entry: 0.05502
2022-03-26 17:41:57,023 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.0225
2022-03-26 17:41:57,023 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.026388889
2022-03-26 17:41:57,023 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,023 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.001981171
2022-03-26 17:41:57,023 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,023 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.02369
2022-03-26 17:41:57,023 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,024 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-13. value of entry: 0.033055556
2022-03-26 17:41:57,024 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,024 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-14. value of entry: 0.048888889
2022-03-26 17:41:57,024 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-15. value of entry: 0.007982917
2022-03-26 17:41:57,024 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.108611111
2022-03-26 17:41:57,025 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.013869167
2022-03-26 17:41:57,025 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,025 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.014677004
2022-03-26 17:41:57,025 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,025 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-16. value of entry: 0.045255
2022-03-26 17:41:57,025 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,025 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-17. value of entry: 0.039583333
2022-03-26 17:41:57,026 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.014119444
2022-03-26 17:41:57,026 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.061111111
2022-03-26 17:41:57,026 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,026 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.014033333
2022-03-26 17:41:57,026 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,026 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-19. value of entry: 0.004722222
2022-03-26 17:41:57,027 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,027 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.104561111
2022-03-26 17:41:57,027 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.016666667
2022-03-26 17:41:57,027 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,027 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.004666667
2022-03-26 17:41:57,027 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,027 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.013261111
2022-03-26 17:41:57,027 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,028 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.025006667
2022-03-26 17:41:57,028 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,028 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.0057475
2022-03-26 17:41:57,028 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,028 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-20. value of entry: 0.048888889
2022-03-26 17:41:57,028 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,028 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.012777778
2022-03-26 17:41:57,029 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.054305556
2022-03-26 17:41:57,029 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,029 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.055416667
2022-03-26 17:41:57,029 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,029 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.033135972
2022-03-26 17:41:57,029 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,029 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.002215614
2022-03-26 17:41:57,030 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,030 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.052416667
2022-03-26 17:41:57,030 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,030 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-21. value of entry: 0.000257535
2022-03-26 17:41:57,030 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,030 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.1662325
2022-03-26 17:41:57,031 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.013235
2022-03-26 17:41:57,031 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,031 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.153333333
2022-03-26 17:41:57,031 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,031 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-22. value of entry: 0.067083333
2022-03-26 17:41:57,031 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,031 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.237966667
2022-03-26 17:41:57,032 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.01440009
2022-03-26 17:41:57,032 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,032 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.029746667
2022-03-26 17:41:57,032 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,032 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-23. value of entry: 0.083333333
2022-03-26 17:41:57,032 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,033 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.052777778
2022-03-26 17:41:57,033 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.057166885
2022-03-26 17:41:57,033 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,033 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.008888889
2022-03-26 17:41:57,033 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,033 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.02375
2022-03-26 17:41:57,033 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,034 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.072222222
2022-03-26 17:41:57,034 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,034 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-24. value of entry: 0.083055556
2022-03-26 17:41:57,034 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,034 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.083055556
2022-03-26 17:41:57,034 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.077906111
2022-03-26 17:41:57,035 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,035 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.004722222
2022-03-26 17:41:57,035 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,035 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.014590278
2022-03-26 17:41:57,035 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,035 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.067222222
2022-03-26 17:41:57,035 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,036 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.011613333
2022-03-26 17:41:57,036 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,036 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.000623267
2022-03-26 17:41:57,036 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,036 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.057777778
2022-03-26 17:41:57,036 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,036 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.07044
2022-03-26 17:41:57,036 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,037 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.160954444
2022-03-26 17:41:57,037 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,037 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.343994444
2022-03-26 17:41:57,037 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,037 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-25. value of entry: 0.201709444
2022-03-26 17:41:57,037 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,037 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.080689185
2022-03-26 17:41:57,038 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.014054444
2022-03-26 17:41:57,038 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,038 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.073333333
2022-03-26 17:41:57,038 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,038 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-26. value of entry: 0.085555556
2022-03-26 17:41:57,038 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,039 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.06
2022-03-26 17:41:57,039 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.085555556
2022-03-26 17:41:57,039 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,039 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.033350089
2022-03-26 17:41:57,039 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,040 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-27. value of entry: 0.081666667
2022-03-26 17:41:57,040 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,040 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.0084
2022-03-26 17:41:57,040 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.056666667
2022-03-26 17:41:57,040 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,040 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.00476
2022-03-26 17:41:57,040 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,041 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.008377115
2022-03-26 17:41:57,041 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,041 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-28. value of entry: 0.001534722
2022-03-26 17:41:57,041 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,041 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.083333333
2022-03-26 17:41:57,042 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.026444444
2022-03-26 17:41:57,042 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,042 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-29. value of entry: 0.0030825
2022-03-26 17:41:57,042 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,042 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-30. value of entry: 0.014123175
2022-03-26 17:41:57,042 src.p2p_statement_parser DEBUG entry type is Zinsen. new entry date is 2019-11-30. value of entry: 0.0225
2022-03-26 17:41:57,042 src.p2p_statement_parser DEBUG add to existing entry
2022-03-26 17:41:57,043 parse-account-statements INFO Account statement parsing finished. Found (and aggregated) 31 transactions
2022-03-26 17:41:57,043 parse-account-statements INFO Writing Portfolio Performance compatible CSV file.
2022-03-26 17:41:57,043 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,048 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,048 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,048 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,048 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,048 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,049 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,050 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,051 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,051 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,051 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,051 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,051 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,051 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,051 src.portfolio_writer DEBUG Current locale: ('en_US', 'UTF-8')
2022-03-26 17:41:57,051 src.portfolio_writer DEBUG Datum,Wert,Buchungswährung,Typ,Notiz
2019-10-30,750,EUR,Einlage,Tageszusammenfassung
2019-10-30,0.0029166670,EUR,Zinsen,Tageszusammenfassung
2019-10-31,0.0052777780,EUR,Zinsen,Tageszusammenfassung
2019-11-01,0.029626667,EUR,Zinsen,Tageszusammenfassung
2019-11-02,0.027036667,EUR,Zinsen,Tageszusammenfassung
2019-11-03,0.061130833,EUR,Zinsen,Tageszusammenfassung
2019-11-04,0.00066666700,EUR,Zinsen,Tageszusammenfassung
2019-11-05,0.037755833,EUR,Zinsen,Tageszusammenfassung
2019-11-07,0.020000000,EUR,Zinsen,Tageszusammenfassung
2019-11-08,0.073577778,EUR,Zinsen,Tageszusammenfassung
2019-11-09,0.042453919,EUR,Zinsen,Tageszusammenfassung
2019-11-10,0.041926250,EUR,Zinsen,Tageszusammenfassung
2019-11-11,0.0030250000,EUR,Zinsen,Tageszusammenfassung
2019-11-12,0.055020000,EUR,Zinsen,Tageszusammenfassung
2019-11-13,0.10761562,EUR,Zinsen,Tageszusammenfassung
2019-11-14,0.048888889,EUR,Zinsen,Tageszusammenfassung
2019-11-15,0.0079829170,EUR,Zinsen,Tageszusammenfassung
2019-11-16,0.18241228,EUR,Zinsen,Tageszusammenfassung
2019-11-17,0.039583333,EUR,Zinsen,Tageszusammenfassung
2019-11-19,0.093986110,EUR,Zinsen,Tageszusammenfassung
2019-11-20,0.21879861,EUR,Zinsen,Tageszusammenfassung
2019-11-21,0.21052579,EUR,Zinsen,Tageszusammenfassung
2019-11-22,0.39988417,EUR,Zinsen,Tageszusammenfassung
2019-11-23,0.36544676,EUR,Zinsen,Tageszusammenfassung
2019-11-24,0.29786133,EUR,Zinsen,Tageszusammenfassung
2019-11-25,1.0946091,EUR,Zinsen,Tageszusammenfassung
2019-11-26,0.25363252,EUR,Zinsen,Tageszusammenfassung
2019-11-27,0.26057231,EUR,Zinsen,Tageszusammenfassung
2019-11-28,0.079738504,EUR,Zinsen,Tageszusammenfassung
2019-11-29,0.11286028,EUR,Zinsen,Tageszusammenfassung
2019-11-30,0.036623175,EUR,Zinsen,TageszusammenfassungI'm merging #516 today which changes the way how data is formatted when writing the csv file. Specifically I am now testing and setting the decimal sign according to the user's locale settings.
What does this mean? If you run en_US locale for example your decimal sign will be '.', if you run a German locale, your decimal sign should be ','. This should also be OK on import in Portfolio Performance. You should make sure that you either set Portfolio Performance to Automatic with regards to language/locale settings or select the correct locale manually.
Hello,
I've ran the program on a sample file and I get strange results. For example, mintos reports a deposit of 750 and the program translates that into 75,000,000,000
My file is in US notation
Thanks