CSV Import
Christian Peter avatar
Written by Christian Peter
Updated over a week ago

To easily connect your own CSV with getquin, we have created a template for you here. Here you will learn everything you need to know in a step by step guide:

Download CSV template here

Delete sample data from line 2 and insert your own data according to the same pattern

Use the tab "File" > "Save as" to export your data as a CSV file

Here you can see the rough structure of the CSV

Note on formatting and which data belong in which columns.

The value in the "Value" column is calculated from "Number of shares bought" multiplied by the "Buy price per share".

-> Shares * Buy Price = Value

The date format consists of year-month-dayThour:minute:second+00:00.

The separation of the individual columns is done by a semicolon and not by a comma.

Separators between thousands are not necessary.

For sums, the European notation is always correct.

0,5 would be the correct version of 0.5.

The WKN and Ticker column can be left empty.

To upload the CSV, go to your portfolio dashboard.

Webapp:

  1. "Portfolio" and then "New Portfolio."

  2. Instead of choosing a broker, go to "Individual Portfolio".

  3. Select "Bulk Import

  4. Upload your CSV file

Mobile App:

  1. Tap on the blue "plus" in the portfolio

  2. "Select "New Portfolio

  3. "Open "Custom Portfolio

  4. Select bulk import to upload the CSV file

FAQ:

  1. Do I need to include dividend payments in the CSV?

    No! Dividends are automatically created by us based on the purchase date and the ex-date.

  2. Do I have to enter (reverse) splits in the CSV?

    No! Again, our system does the splits automatically.

  3. Can cryptocurrencies also be imported via CSV?

    No, at the moment this is not possible.

  4. Is it possible to export my portfolio from getquin as CSV?

    No, we do not offer such a function.

  5. The CSV import does not exist as an option for me. What am I doing wrong?
    Currently we offer the CSV import only in Germany, Austria and Switzerland.

Done! πŸŽ‰

If you need help with the depot linking, just get in touch with us. We are here for you and will be happy to help you at any time! Just write us an email to [email protected] .

Did this answer your question?