How to import my financial data

Back

Preparing your File

Investment Transactions

Cash Transactions

Preparing your File

Simple Stocks allows you to import two different types of data: investment transactions, and cash transactions.

Investment transactions refer to any transaction for stocks, crypto, ETFs, and funds.
Cash transactions refer to transactions for cash accounts.

Investment Transactions

Simple Stocks supports imports of open (buy) and close (sell) transactions. Importing of Splits and Dividends is currently not supported, but these should automatically be reflected in your portfolio immediately after import.
You may use any CSV file in any format provided that it contains a column for each of the following transaction fields:

Symbol or ISIN

You may provide either an ISIN or a symbol. Please note that if you provide symbols for non-US instruments, you will need to ensure they contain the supported suffix, please check the 'code' column in the list of available exchanges.

Date

The date of the transaction. Most date formats should be automatically recognized, so there should not be a need to reformat this data.

Type

Whether it is an open or close transaction. Accepted terminology can be found here.

Units

The number of units/shares being traded. This should be a positive number, even for 'close' transactions.

Amount

The value of the transaction (not the price per share).
The fields below may also be imported but are optional:

Currency

If the transaction was in a different currency than the instrument, you may provide the currency here. This must provided using the 3 letter abbreviation for the currency. See the full list of accepted currencies.

Exchange Rate

If the transaction was in a different currency than the instrument, you should provide the exchange rate that was used.

Cash Transactions

Simple Stocks supports deposits, withdrawals and interest transactions for cash accounts. You may use any CSV file in any format provided that it contains a column for each of the following transaction fields:

Account Name

The exact name of the cash account that the transaction belongs to. Please note that you should create the cash accounts manually first before you can import transactions to them.

Date

The date of the transaction. Most date formats should be automatically recognized, so there should not be a need to reformat this data.

Type

Whether it is a deposit, withdrawal or interest transaction. Accepted terminology can be found here.

Amount

The value of the transaction.
The fields below may also be imported but are optional:

Currency

If the transaction was in a different currency than the account currency, you may provide the currency here. This must provided using the 3 letter abbreviation for the currency. See the full list of accepted currencies.

Exchange Rate

If the transaction was in a different currency than the account currency, you should provide the exchange rate that was used.

Reference

The transaction reference.

Loading your File

Select your File

Click on the ' + ' plus button in the top right of the Simple Stocks app
In the menu that appears click on 'Import Transactions'

3. In the new sheet that appears, click on 'Select File...' and browse for your CSV file.4. Once selected, click on the 'Next' button at the bottom right of the page.

Mapping CSV Columns

1. On 'Map CSV Column' page, start by selecting what type of file you are importing, either Investment or Cash transactions2. Once selected, the appropriate fields will appear on the page. The fields that appear will be the same as those detailed in the 'Preparing your file' section above.3. [Investment only] In the 'Portfolio' field, select which portfolio you wish to import the transactions to.4. Ensure that the auto detected format in the 'Date format' field is correct.5. In the 'Map CSV Columns' section, ensure that the correct CSV column name is selected for each transaction field. You may amend them by selecting from the provided dropdown fields. The fields marked as (optional) can be left blank.6. Once completed click on the 'Next' button

Review and Import

On the 'Review and Import' page you will get a chance to preview and amend the data from your CSV file before importing.

If any symbol was not found, they will be displayed with red border around them. Please ensure they are correct before continuing (see the preparing your file section above for further guidance).
You may remove rows by clicking on the red 'trash' icons on the left of the rows. Once removed, a row will not be imported.
When you are ready to import, click on the 'Import' button at the bottom right of the sheet.
After the import completes, you may need to manually refresh the interface for changes to fully take effect. To do this, click on the circular arrow in the top right of the screen on Mac, or scroll up until you see a loading wheel on iPhone/iPad.

Contact Us

If you encounter some difficulties with the steps listed above, or have some suggestions to improve the process, please reach out to us and let us know.

Page updated

Google Sites

Report abuse