Help with importing from xml file

[Knuj0]

Hi, thought I'd leave a quick feedback from my experience I have recently given the App a try but unfortunately it only Imports Dividends ignoring Futures and Stocks. Fact that it is importing Dividends makes me thing xml file is good and the problem is somewhere else. FYI: Section104.txt and Trades Calculations.txt are empty whereas Dividends Summeary.txt has been populated with correct details

[alexpung]

What is the number shown in the app just below the import section?

e.g. Number of tax events: 45 Number of dividends imported: 10 Number of trades imported: 35 Number of corporate actions imported: 0

[Knuj0]

Number of tax events: 8 Number of dividends imported: 0 Number of trades imported: 0 Number of corporate actions imported: 0

[Knuj0]

sorry had a typo! Number of tax events: 8 Number of dividends imported: 8 Number of trades imported: 0 Number of corporate actions imported: 0

[alexpung]

Then the trades are not imported. Make sure your trades are in the same format as: https://github.com/alexpung/UK-Investment-tax-calculator/tree/master/UnitTest/System%20Test/Interactive%20brokers

In particular levelOfDetail should be "ORDER"

<Order currency="USD" fxRateToBase="0.8" assetCategory="STK" symbol="ABC" description="ABC Example Stock" dateTime="01-May-21 12:34:56" quantity="200" proceeds="-2000" taxes="-20" ibCommission="-1.5" ibCommissionCurrency="USD" buySell="BUY" levelOfDetail="ORDER" />

[Knuj0]

This is the format I am using: I have 2 doubt: my DateTime format (in particular HH:MM:SS) and levelOfDetail is sometimes "EXECUTION" (not sure why as they are trades anyway)

[Knuj0]

[alexpung]

It should work if you correct the time format. (change 112234 to 11:22:34)

The app is a bit of pain when an exception occurs. It just swallow the error and give the error at the browser console. System.FormatException: Format_BadDateTime, 20-May-22 112234

The execution data is fine as long as you also include the order data.

Thanks for the feedback.

[Knuj0]

great! it looks like that by changing the time format I get many more trades - I understand Options are not being imported (IBKR Classes: Equity and Index Options, Options on Future, Warrants) and same for Bonds and other Fixed Income instruments. I'd like to check and compare calculations , is there a way to download Calculations/Reposts in csv format? Thank you!

[alexpung]

In the Disposal calculation summary page you can export the table to excel or pdf, but the details are hidden.

Unfortunately no, I cannot imagine the calculation details stored in a csv file. I plan to make a pdf output, but not csv.

[Knuj0]

thank you very much - do you plan to implement Equity and Index Options, Options on Future, Warrants also - their calculations mimic stocks though you'd need to deal with options exercises events ? will you keep only the app or have also a python local version?

[alexpung]

I may consider implementing options someday but not in the near future.