Freedom24 import

Darelas · October 8, 2021, 6:40am

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?

Harry_Hirsch · October 8, 2021, 8:53am

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.

hubga · February 21, 2026, 7:10pm

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

(one-time) install ImportExcel module to PowerShell
Install-Module -Name ImportExcel
download Excel file from Freedom24 (Member area - Reports - Broker report).
run “F24_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. 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)

chefkoch · April 21, 2026, 6:26pm

Hi,

just for your information, I also recently wanted to import from freedom24 so I created a first version for a JSON importer.

I created the pull request at github, see

github.com/portfolio-performance/portfolio

Add Freedom24 (Freedom Finance Europe) JSON broker report importer (#5636)

master ← chefkoch:importer-freedom24-json-extractor

offen 12:24PM - 20 Apr 26 UTC

chefkoch

+2428 -3

## Summary Adds a new importer for **Freedom24 / Freedom Finance Europe** bro…ker report JSON files (`.json`), exported from the Freedom24 client portal at https://freedom24.com/cabinet?tabId=reports The JSON format specification is documented at https://freedom24.com/tradernet-api/broker-report (API reference only, not required for importing). The importer handles the following transaction types: - **Stock trades** (buy / sell) — `trades.detailed`, `instr_type = 1` - **Currency conversions** — `trades.detailed`, `instr_type = 6`, mapped to `AccountTransferEntry` between two currency accounts - **Deposits and withdrawals** — `cash_in_outs` (preferred) or `cash_flows.detailed` (fallback), type `bank` only; internal block/unblock entries are skipped - **Interest charges** on negative cash balances — `commissions.detailed`, mapped to `AccountTransaction.INTEREST_CHARGE` - **Promo / gift shares** (DELIVERY_INBOUND) — `securities_in_outs` joined with `in_outs_securities.detailed` to resolve the ISIN, which is only present in the detailed section ### Cross-currency commission handling Freedom24 always charges commissions in EUR, even for trades executed in USD. Portfolio Performance rejects a `FEE` unit whose currency differs from the portfolio transaction currency. For this reason cross-currency commissions are emitted as a separate `AccountTransaction.FEES` with a `GROSS_VALUE` unit carrying the exchange rate. The rate is parsed from the embedded `comment` field of the trade using a regex pattern. ### Security lookup Securities are matched in priority order: 1. ISIN + currency (most reliable) 2. Exact `tickerSymbol` match 3. Yahoo-format ticker match — Freedom24 uses exchange-suffixed tickers (e.g. `CLSK.US`), while Portfolio Performance stores the Yahoo symbol (`CLSK`). Both forms are tried to prevent duplicate security creation on re-import. If no match is found, a new `Security` is created and a `SecurityItem` is appended so the user can review it in the import wizard. ### Language support Freedom24 exports are available in multiple languages. The importer has been tested and verified against all 22 languages available in the Freedom24 client portal: Arabic, Bulgarian, Czech, Danish, German, Greek, English, Spanish, Estonian, French, Armenian, Italian, Kazakh, Lithuanian, Dutch, Polish, Portuguese, Romanian, Russian, Tajik, Ukrainian, and Chinese. The three categories of language-dependent strings are: | Category | Handling | |---|---| | Gift shares type | Exact `Set` match (`STOCK_AWARD_TYPES`) | | Interest charge type | Prefix `Set` match (`INTEREST_CHARGE_PREFIXES`) — handles trailing currency code (EUR / USD) | | Trade commission prefix (skipped) | Prefix `Set` match (`TRADE_COMMISSION_PREFIXES`) | --- ## Changed files | File | Change | |---|---| | `name.abuchen.portfolio/.../datatransfer/freedom/Freedom24JSONExtractor.java` | New extractor | | `name.abuchen.portfolio.ui/.../ui/handlers/ImportFreedom24Handler.java` | New UI handler | | `name.abuchen.portfolio.bootstrap/Application.e4xmi` | Menu entry + icon URI | | `name.abuchen.portfolio.bootstrap/OSGI-INF/l10n/bundle*.properties` | Labels in all supported languages | | `name.abuchen.portfolio.ui/icons/logos/freedom24.svg` | Broker logo (16×16) | | `name.abuchen.portfolio.ui/.../ui/Images.java` | Registered `FREEDOM24_LOGO` | | `name.abuchen.portfolio.tests/.../datatransfer/freedom/Freedom24JSONExtractorTest.java` | 9 unit tests | | `name.abuchen.portfolio.tests/.../datatransfer/freedom/*.json` | 9 JSON test fixtures | --- ## Test coverage | Test | Transaction type | Fixture | |---|---|---| | `testKauf01` | BUY (cross-currency commission) | `Kauf01.json` | | `testVerkauf01` | SELL (cross-currency commission) | `Verkauf01.json` | | `testEinzahlung01` | Deposit | `Einzahlung01.json` | | `testEntnahme01` | Withdrawal | `Entnahme01.json` | | `testZinsen01` | Interest charge (DE) | `Zinsen01.json` | | `testZinsen01_EN` | Interest charge (EN) | `Zinsen01_EN.json` | | `testEinlieferung01` | Promo share / ISIN join (DE) | `Einlieferung01.json` | | `testEinlieferung01_EN` | Promo share / ISIN join (EN) | `Einlieferung01_EN.json` | | `testWaehrungskonversion01` | Currency conversion | `Waehrungskonversion01.json` | | `testEinlieferung01_{AR–ZH}` | Gift share – 20 additional languages | `Einlieferung01_{AR–ZH}.json` | | `testZinsen01_{AR–ZH}` | Interest charge – 20 additional languages | `Zinsen01_{AR–ZH}.json` | --- ## Known limitations and open points ### Icon license (blocker) The `freedom24.svg` logo is derived from Freedom24's corporate branding. The contributing guidelines require all icons to be [CC0 licensed](https://creativecommons.org/publicdomain/zero/1.0/). A replacement icon (e.g. a generic shield or custom neutral icon under CC0) should be used unless explicit permission is obtained from Freedom24. ### No wizard pre-selection for accounts and depot The import wizard cannot pre-select the correct account (EUR / USD) or depot automatically because the JSON report does not contain a reliable mapping to Portfolio Performance portfolio/account names. The user must assign accounts manually in the wizard. ### Unsupported instrument types `instr_type` values other than `1` (stock) and `6` (currency pair) — such as bonds, ETFs with a different type code, or futures — are silently ignored. No error is reported to the user. ### No test for commission skip logic The logic that skips trade-linked commissions in `commissions.detailed` (type prefix `"Für eine Transaktion:"` / `"For trade:"`) is not covered by a dedicated unit test. ### No `AssertImportActions` validation in tests The tests do not call `new AssertImportActions().check(results, "USD")` to validate overall import action consistency. This should be added once multi-currency import actions are better understood for this broker. --- ## Forum reference There is an existing community thread requesting Freedom24 import support. It is provided here as background context only and is not linked in commits: https://forum.portfolio-performance.info/t/freedom24-import/18110

Everything should be described there. So far nothing tax related was included in my files and I also did not have any sample data for dividends, options, futures or so.

In case anyone has a rich amount of transations, you could get in contact with me, so we could add support for it quite easily based on the single day extracts containing those transations and making them anonymous before sharing.

Best Regards

Synthia_Casper · April 23, 2026, 10:02am

This is a great workaround! Using a PowerShell script to bridge the gap to CSV definitely seems like the most reliable way to handle those XLSX exports for now. It’s a lot easier than manually reformatting everything or waiting for a native parser. Thanks for sharing the setup steps - getting those deposit accounts named correctly is a solid tip to keep things running smoothly!

hubga · May 14, 2026, 7:56pm

Here is script update. There was a minor bug with the sell transaction (fee not handled correctly). Also, now it can import dividends. I have 100 % same result in PP now.

Freedom24_convert_run.zip (2.0 kB)

hubga · May 14, 2026, 7:58pm

Maybe later when I have free time to anonymize it.

How does the JSON handle situations like money trasnfer between accounts? Probably doesn’t, right?

chefkoch · May 14, 2026, 9:12pm

Hi @hubga

Depends, in case with accounts you mean currency conversion, then it does. See https://github.com/portfolio-performance/portfolio/pull/5636/changes#diff-ac557c3c64a21dcfb9a891dbcce6fce3ab31a1ea021d2a0a471629620dc1ee1b

In case you have multiple account IDs at freedom, then it does not, yet. Since I do not have that and thus I am not able to test without sample files. In case these are provided , I can try to implement it.

Br, chefkoch

Btw: looking at the pull request code, I am thinking again whether it is good to support all the languages freedom supports in their UI or whether I should keep it simple between 1 or 3 languages.