CSV file format in 2022 report?

[5thorm]

Hi,

I just tried your code 1st time with IBKR 2022 report, but after report was generated and uploaded to parser nothing happened. It was not able to parse csv file.

Maybe the reason is that there is new mandatory parameter called Delivery confugurations in the Reporting section compared to the screenshot you had.

[5thorm]

Uploading your test data works fine, data_single_account_2022.csv. I compared the headers and noticed that my report header have some extra rows. Deleted rows 1 to 6, but still it fails to upload.

Here are first ten lines from my report.

<style> </style>

Statement,Header,Field Name,Field Value
Statement,Data,BrokerName,
Statement,Data,BrokerAddress,
Statement,Data,Title,Activity Statement
Statement,Data,Period,"January 1, 2022 - December 31, 2022"
Statement,Data,WhenGenerated,"2023-01-03, 01:21:22 EST"
Trades,Header,DataDiscriminator,Asset Category,Currency,Symbol,Date/Time,Exchange,Quantity,T. Price,C. Price,Proceeds,Comm/Fee,Basis,Realized P/L,MTM P/L,Code
Trades,Data,Order,Warrants,EUR,GH8MB6,"2022-11-23, 11:22:06",-,100,2.81,3.02,-281,-1.735,282.735,0,21,O
Trades,Data,Trade,Warrants,EUR,GH8MB6,"2022-11-23, 11:22:06",SWB,100,2.81,3.02,-281,-1.735,282.735,0,21,O
Trades,Data,Order,Warrants,EUR,GH8MB6,"2022-11-24, 02:10:23",-,-100,2.72,2.29,272,-1.725,-282.735,-12.46,43,C
Trades,Data,Trade,Warrants,EUR,GH8MB6,"2022-11-24, 02:10:23",FWB,-100,2.72,2.29,272,-1.725,-282.735,-12.46,43,C

[oittaa]

The current version doesn't know hot to handle "Warrants" since I've never bought them. :)

I can easily add those if there's nothing special about them. Do they show up exactly the same way as "Stocks" or do they have to be calculated in some special way like "Equity and Index Options", which need to be multiplied by 100 to get the real value of the trade?

[mexumoi]

I have plenty of warrants. Please add them to the report. To simplify they are like stocks in this report (no option like multipliers applied).

[oittaa]

Could you attach a CSV file (just make sure you don't have your account information there), which shows a single full warrant transaction a bit like this stock transaction: https://raw.githubusercontent.com/oittaa/ibkr-report-parser/main/tests/test-data/data_single_account.csv

I think the change is very simple and this might work: #643