At Parqet, we want to make it as easy as possible for investors to visualize and analyze portfolios across all brokers and banks.
With the zero-click PDF import of statements from the most common brokers, Parqet already offers a comfortable and easy way to create activities in Parqet.
To make creating activities like securities purchases, dividend payments, or sales of stocks, ETFs, and cryptos as easy as possible, Parqet now supports importing files in .csv format. We rely on a flexible solution so that different files (like from Excel) can easily be converted to a format we support.
Download CSV TemplateThe Structure of the .csv File
The .csv file must have a header row, contain at least the required columns, and contain at least one activity. Columns must be separated by semicolons.
| Column | Description | Format | Required |
|---|---|---|---|
| currency | The currency of the activity | Three-letter code in uppercase Example: EUR | No (EUR is used automatically) |
| date | The date of the activity. The date must not be older than 01.01.1990 and not more than four weeks in the future | dd.MM.yyyy or yyyy-MM-dd Example: 2021-11-07 | Either datetime or date column must be present |
| datetime | The date and time of the activity. The date must not be older than 01.01.1990 and not more than four weeks in the future. | yyyy-MM-ddTHH:mm:ss.fffZ Example: 2021-11-07T18:25:21.689Z | Either datetime or date column must be present |
| fee | Amount of fees paid | Decimal number without thousands separator Example: 1.00 | Yes |
| fxrate | Original exchange rate from the original currency | Positive decimal number without thousands separator Example: 1.00 | No |
| assetType | The type of asset. Must be set for all transactions not related to a security | Security, Crypto or Cash (case-sensitive) | No (Security is used automatically) |
| identifier | The identifier of the asset. For securities, it's the ISIN. For cryptos, the symbol | For securities: Twelve-character alphanumeric combination; For cryptos: Alphanumeric combination | Either identifier or wkn column must be present |
| price | Price per share | Positive decimal number without thousands separator Example: 1.00 | Yes |
| shares | Number of shares | Positive decimal number without thousands separator Example: 1.00 | Yes |
| amount | Sum of the transaction | Positive decimal number without thousands separator Example: 1.00 | Yes |
| tax | Amount of taxes paid (incl. withholding tax) | Decimal number without thousands separator Example: 1.00 | Yes |
| time | Time of the activity | HH:mm:ss Example: 09:15:00 | No |
| type | Activity type (Buy, Sell, etc.) | One of the following values: Buy, Sell, Dividend, Interest, TransferIn or TransferOut (case-sensitive) | Yes |
| wkn | The securities identification number | Six-character alphanumeric combination in uppercase | Either identifier or wkn column must be present |
The structure for a purchase of Apple shares on 04.01.2021 for 100 euros could look like this:
date;price;shares;tax;fee;type;assetType;identifier
2021-01-04;105.20;0.950570342;0;4.99;Buy;Security;US0378331005
2022-01-01;41935.56;1;0;0;Buy;Crypto;BTC
Download CSV Template
Importing Cash Transactions
To add cash transactions to the portfolio via zero-click import, the following steps must first be performed:
- If not already present, first create the desired cash account in the portfolio
- Download the following CSV template for cash
- Go to the holding page of the cash account and copy the link from the browser (e.g., https://app.parqet.com/p/637793872699356a62ee6578/h/632753972193856f22ee6618)
- Replace the placeholder HOLDING_ID in the CSV template with the desired holding ID. You can find the holding ID in the copied link. It's the last sequence of characters after /h/, in this case 632753972193856f22ee6618
date;amount;tax;fee;type;holding
2021-01-04;1000;0;0;TransferIn;HOLDING_ID
2021-02-04;-1;0;0;Interest;HOLDING_ID
2021-10-04;10;0;0;Interest;HOLDING_ID
2021-12-04;1000;0;0;TransferOut;HOLDING_ID
Download CSV Template
Import the .csv File via Drag-and-Drop
The import works as easily as usual in one step:
- Drag the .csv file into your Parqet Portfolio
That's it!
Discover your portfolio performance, allocation, dividends, value development, and more. With support for .csv files, you can now import your activities even more easily. For example, use your already existing Excel file with securities transactions or the .csv files created by your broker as a basis and simply convert them to our flexible format to import these activities into your portfolio.
New to Parqet?
At Parqet, we work every day to remove barriers to wealth building. We build tools that allow you to keep track of your portfolio effortlessly, whether at home or on the go.
See how Parqet can simplify your wealth planning, or create your free portfolio in seconds.
Create Portfolio