search

agusalex / tax_calculator

Apache License 2.0
0 stars 1 forks source link

year end consolidation 2021 #2

Open wusatiuk opened 8 months ago

wusatiuk commented 8 months ago

i would like to structure the input in a folder /input/ by year e.g.: /input/2021_ibkr_TRNT.csv for the transactions

while calculating the tax, there will be some "open positions" in the account at year and, which have not been sold. these positions, we should to write to "2021_ibkr_open_positions_by_endofyear.csv" into the output folder. these calculations should be done on stocks, options and currencies.

please find enclosed a screenshot showing the end balance 2021 for stocks & options in the PDF:

2024-03-03_17-30-20

wusatiuk commented 6 months ago

open positions are shown in the PDF as well. here is an example how to calculate them: https://docs.google.com/spreadsheets/d/1c8xpz4Jjh4zs7Vlqb2TI2UKSCGVDO64XqvJHIBZyHBY/edit#gid=0