How to import from XTB?

juanmurodriguez · November 23, 2022, 6:46pm

Hi, Congrats for the app.
I have no idea how to import from xtb broker. I have tried from pdf but it fails. Any ideas?
Thank u

hubga · December 28, 2024, 5:57pm

Hi,
I had the same problem so I created a PowerShell script to convert CSV file with history from XTB. This script adds necessary columns (currency, shares count & price, date/time, deposit/security account) and renames the rest

download CSV file from XTB. Save it with currency, like “xStation5_cashOperations_123456789_01-01-2024–30-12-2024_EUR.csv”. I assume that everybody has a separate account for each currency on XTB.
run “XTB_convert_run.bat”
choose CSV file
import CSV file into PP. Program will load all the columns correctly. Just fix the “Type” column and all columns with values have to use “.” (dot) as decimal point instead of “,” (comma). Again, I assume that everybody has “EUR” deposit account and “XTB EUR” in securities accounts.
save CSV import settings

This way I was able to import whole CSV in few clicks.
If anybody has ideas how to improve it, let me know.

XTB_convert.zip (2.6 kB)

Marcelo_Correia · February 2, 2025, 8:34pm

Hi thanks for your work

Work now?
Where do you import the file after it stays out at the end? I tried everything…

Thank you

hubga · February 5, 2025, 4:28pm

Please, describe your problem a little better.
If you follow the steps then you should make it work. You may change the import script in notepad (or any text editor) if you have different names for accounts.

If you ask, how to import the file in the program - it is easy. Go to first menu File, choose Import and then “CSV comma separated values”. Then choose the “out” file from the script.
It will show import dialog. You have to change some columns (step 4). Then you save it as a template. Next time you just select the template.

Just to make the “Step 4” more clear
Script will transform
“xStation5_cashOperations_123456789_01-01-2024–30-12-2024_EUR .csv”
into
“xStation5_cashOperations_123456789_01-01-2024–30-12-2024_EUR_out .csv”.

Import tutorial is here

Marcelo_Correia · February 5, 2025, 9:11pm

will create manually.

With note pad

Thanks

wjtkport · February 12, 2025, 4:18pm

I see that CSV export in XTB is not available - there is Excel, PDF and HTML available. Do you plan to update your script ;)?

hubga · February 15, 2025, 2:19pm

No, it is still there. You probably chose wrong report.
Do not use “full report” on the right side but financial operation (first button).

stoeggich · February 15, 2025, 2:38pm

pdf is perfect post a report

wjtkport · February 16, 2025, 5:44pm

Hmm, maybe we have different interfaces? That’s what I see when I enter “Account history” → “Export”

hubga · February 16, 2025, 8:06pm

I hope they are not about to update it. Do you use web, right?
I am in xStation 5, I enter “Account history”, then “Cash operations”.
There is Export button on the right side which opens this

wjtkport · February 17, 2025, 12:19pm

Yes, that’s the same platform (xstation5 web) and the same place → modal after clicking on Export button (top-right) in Cash History. But for sure we have different versions as our UIs are different ;(

hubga · February 17, 2025, 7:40pm

I will wait now. If they update it for me too, I will definitely try to write some code to fix the export format. Editing Excel is more complicated in PowerShell, probably impossible for PDF.
Do you use Windows + Chrome?

It is a litte weird that you have only one option. Is the output with cash operations only? Or does it cointain open/closed positions too?

stoeggich · February 18, 2025, 3:51pm

klick on pdf and post it

hubga · February 23, 2025, 4:23pm

I am still curious why it is different - when I right click in any empty space in the cash history, it shows version - it shows xStation 5 version 2.66.1 (Build: 10).

What about you, guys?

hubga · March 3, 2025, 7:17pm

So they updated it to 2.67 and I have also the new style without CSV export
I will investigate how to make it work.

hubga · March 4, 2025, 5:37pm

I spent a nice evening with this and here is the update.
If you want to thank me, just send me a Tesla stock, they will be for free soon. Well, all US-stock will

You will need extra PowerShell module “ImportExcel” free from GIT. You will not need Excel to work with the file.
Basically, you will just run PowerShell manually and use this command
“Install-Module -Name ImportExcel”.
More details here
https://github.com/dfinke/ImportExcel

Then you will use this updated script which will convert Excel to CSV and then it will work like before

Here I repeat the steps

(one-time) install ImportExcel module to PowerShell
Install-Module -Name ImportExcel
download Excel file from XTB (History - Cash operation). Save it with currency, like “account_12345678_en_xlsx_2024-01-01_2024-12-30_EUR.xlsx”. I assume that everybody has a separate account for each currency on XTB.
run “XTB_convert_run.bat”
choose XLSX file
script will convert the Excel file to CSV and output updated CSV
import CSV file into PP. Program will load all the columns correctly. Just fix the “Type” column and some columns with number values have to use “.” (dot) as decimal point instead of “,” (comma). Again, I assume that everybody has “EUR” deposit account and “XTB EUR” in securities accounts (otherwise you will have to edit the script on line 210 for deposit account and on line 212 for securities account)
save CSV import settings

XTB_convert_run.zip (2.7 kB)

hubga · March 10, 2025, 7:03pm

Here is one significant update - Excel provides the currency. So I updated the script, it will read the currency automatically

Now it is really just “one” click - save export, run script, choose file and it is done.

XTB_convert.zip (2.7 kB)