XTB have a new template for cash operations

[rubengr]

Hi,

In last update XTB changed the export template:

Now there are tabs in excel and one is cash opertations. Could you please update you code?

Thanks.

[dickwolff]

Sure! Can you give me a CSV export that contains these new values, so I can add them?

[netcarlos]

I have succesfully imported csv with only minor changes in xtbConverter.ts.

But the biggest hurdle is actually extracting the csv from the large multi-sheet xls. How would you like to proceed with it? Users should do this manually?

What is the spec for xls->csv conversion?
I have noticed that converter requires a semicolon as column separator and a dot as decimal separator.

Excel offers saving just the active sheet into CSV when I use Save As.. by default. But that would include some account metadata before the actual header and the number of columns would raise to 10 instead of just 6.

Let me know how to proceed and I can send you a sample by email. Thank you very much.

[netcarlos]

I have extracted only the table cash operation history, including the header. (Six colums)
Then I've switched order of columns (basically switching symbol and comment).

Then I had to do following changes:

netcarlos@0503ed0

[rubengr]

Shure
account_1_en_xlsx_2025-02-27_2025-03-08.xlsx

[dickwolff]

@netcarlos Sorry for the late response, and may thanks for the research!

But the biggest hurdle is actually extracting the csv from the large multi-sheet xls. How would you like to proceed with it? Users should do this manually?

Yes, as far as the tool is concerned, the input for it is a CSV. In the readme I would then like to put the instructions how to get to the CSV that can be processed. So if you know how to do it, can you provide the instructions for it?

Then I had to do following changes:

Thanks for these suggestions. If only the column order changed, I can also pick that up in the tool so you don't have to do it manually. I will look into the other changes as well and see if I can merge them into the tool. I don't know when I have time for it, as Im currently busy with other things as well. Whenever I have some changes, I will let you know here.

[dickwolff]

Sorry for the inactivity, I’m currently otherwise occupied and haven’t had time for this. Will try to make some time this week!

[dickwolff]

I made some changes to the XTB converter this afternoon. I took inspiration @netcarlos's changes for handling the values. I also updated the code to accept the new export format. This means I changed the column order and set the separation character to comma. Also, now you'll need to export the specific tab (cash operation history) to CSV and do some manual cleanup. I tried to incorporate these instructions in the export instructions.

@netcarlos @rubengr can you please verify if the changes are working for you? I tried the export that @rubengr provided and I can process that one.

You can try with this Docker image, or checkout this branch to run locally.

Much appreciated! And again, sorry for the late response 🙂

[rubengr]

Hi,

Thanks for your work! Unfortunately don't works for me:

xxx;DIVIDENT;26/03/2025 11:47:01;FB.US USD 0.5250/ SHR;FB.US;0,48;;;;
xxx;Withholding Tax;26/03/2025 11:47:01;FB.US USD WHT 15%;FB.US;-0,07;;;;

Anyway, don't like to much this way :) It's not possible to import directly from xlsx exported by xtb?

Thanks

[rubengr]

Sorry have checked and is because in my language excel saves columns delimited by ; not comma ,. But in this case money is separated by comma too. Don't like it :(

[rubengr]

Type is not valid. I think you are not generating type property no?
For example:

The value is not correct too. are putting 0 in all dividends:

Types looks diferent now, no?