Freedom24 import

English
3

I created a PowerShell script to convert Excel (XLSX) file into CSV format.

You will need extra PowerShell module “ImportExcel” free from GIT. You will not need Excel to work with the file. Use this command to install it
“Install-Module -Name ImportExcel”.
More details here
https://github.com/dfinke/ImportExcel

It is the same like for XTB and T212 I published here before
https://forum.portfolio-performance.info/t/how-to-import-from-xtb/22308

Usage

  1. (one-time) install ImportExcel module to PowerShell
    Install-Module -Name ImportExcel

  2. download Excel file from Freedom24 (Member area - Reports - Broker report).

  3. run “F24_convert_run.bat”

  4. choose XLSX file

  5. script will convert the Excel file to CSV and output updated CSV

  6. import CSV file into PP. Program will load all the columns correctly. It should not need any changes. You need “F24 EUR” / “F24 USD” deposit account and “F24 EUR” / “F24 USD” in securities accounts (otherwise you will have to edit the script) in PP

Freedom24_convert_run.zip (1.8 kB)

1 Like