How to import from XTB?

English Import/export
1

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

2 Likes
2

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

  1. 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.
  2. run “XTB_convert_run.bat”
  3. choose CSV file
  4. 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.
  5. 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)

1 Like