Freedom24 import

English
1

Hi, how to perform an automatic trading data upload from the broker Freedom Finance (platform Freedom24) https://freedomfinance.eu/, https://ffgermany.de/. It provides data in four formats: .pdf, .json, .xls, and .xlm. But I am unable to upload any of the submitted files to PP. Please help, maybe it would be possible to create an automatic .xlm upload, as in the case of Interactive Brokers?

2

Hey Darelas,

the import of data from pdf document does not work out of the box for every file. The parser in PP for those documents needs to be programmed by the clever programmers in this forum. In order for those volunteers to help you out it is necessary to assist them by providing such documents. As they need the text content of such PDFs they require you to convert the PDFs to text. How that works is described in this thread (I only did find this German version).

At the end of the initial post there is a link to a tutorial “Tutorial zum Extrahieren von Text aus PDF” for extracting text from a pdf. In the post itself it is mentioned how to embed the text in a PP forum post.

1 Like
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