and select the data for dataframes for stocks, options and currencies with
HEADER | TRNT - line 22
DATA | TRNT - line 23
"HEADER" describes if there is something "new" starting in the report - in this case "TRNT" = transactions are starting on line 22
"DATA" means that there happened something relevant = which we should process; starting line 23
"TRNT" marks the transaction, which we use in the calculations; starting line 22/23
background: i don´t want to manipulate the input files, which are coming from IBKR as with every manual manipulation, there might be some errors and i think that pandas can easily extract only the TRNT data.
and select the data for dataframes for stocks, options and currencies with HEADER | TRNT - line 22 DATA | TRNT - line 23
"HEADER" describes if there is something "new" starting in the report - in this case "TRNT" = transactions are starting on line 22 "DATA" means that there happened something relevant = which we should process; starting line 23 "TRNT" marks the transaction, which we use in the calculations; starting line 22/23
original file was here: https://docs.google.com/spreadsheets/d/1xL9GxZ5TpXgERhIxJxkpTD5m-w1mRvOf5lBV6GEDSlY/edit#gid=770943250 (it should be the same as the one i already provided.)
background: i don´t want to manipulate the input files, which are coming from IBKR as with every manual manipulation, there might be some errors and i think that pandas can easily extract only the TRNT data.