Importing your folio

You can import your portfolio from an Excel/CSV file to quickly populate your portfolio.

Step by Step Instructions for Excel/CSV Import

Step 1 - Preparing the Spreadsheet with your transactions

  • Download the template CSV spreadsheet from this link - download (Safari users - you may need to right click and then click 'Download')
  • Please either populate the downloadable spreadsheet above with your transactions or rename your spreadsheet columns with the following column titles: TICKER, DATE, TIME, TYPE, SHARES, PRICE, CURRENCY, FX, COMMISSION, TAX
  • Of the fields above, only those fields in bold are needed as a minimum upload requirement. Optional fields can be added for extra information, else the column should be deleted from your spreadsheet.


    • TICKER - these will default to local EPIC tickers. Otherwise use the google style - EXCHANGE:TICKER.
      Common exchange codes: LON for London Stock Exchange, NASDAQ for Nasdaq, NYSE for New York Stock Exchange, ETR for Deutsche Börse XETRA, ASX for Australian Securities Exchange.
    • DATE - formatted as DD/MM/YYYY (optional, will default to today).
    • TIME - formatted as HH:MM:SS (optional - delete column if not used).
    • TYPE - case insensitive, options available are: buy, sell, dividend, deposit, withdrawal.
    • SHARES - quantity of shares in the transaction.
    • PRICE - the share price , dividend per share or the deposit & withdrawal amount.
      For shares & dividends, this is the same units as the CURRENCY field.
      For deposits & withdrawals this will always be in the portfolio currency.
    • CURRENCY - a 3 digit currency code for the transaction.
      e.g. GBP for British pound. GBX for pence. (Optional, defaults to the security's quote currency).
    • FX - the exchange rate from the security major currency to the portfolio currency at the time of the transaction. (Optional, Default is 1).
    • COMMISSION - Broker fees stated in the portfolio currency units. Please show the cost as a positive number, rather than a negative value. (Optional - delete if not used).
    • TAX - Sum of stamp duty & levies in the portfolio currency units. Please show the cost as a positive number, rather than a negative value. (Optional - delete if not used).
  • Save your spreadsheet in the file format of "Comma Separated Values (.CSV)" to your desktop.

Step 2 - Creating your Folio

  • Within Stockopedia, click on 'Folios' in the sidebar and then 'Create Folio', as shown below:

df21a55efcf01be5c248205ca7c0febe99ffd2cd1553015659.jpeg

  • Name your portfolio, choose its currency and benchmark and add a description if desired. Click 'Save'.
  • In the overview page, click on the 'Select File' button as shown below:

f0d1898a0e07e274d41b3cf4397c91f071f407491553015824.jpeg

  • Select your recently created .CSV file.

Step 3 - Validating the data

  • In the pop up that appears, check that the dropdown columns match to the required data in the spreadsheet.
  • If required you can change the column mapping by choosing the correct mapping from the dropdown.
  • When happy, click 'Next'.

eadeb6b6fcee13abac69c6e2dc65c65633a528101549989060.jpeg

  • The next page allows you to check that the securities listed have been mapped across correctly.
    • You can edit a position by clicking on the pencil icon and searching for the security.
    • Alternatively you can click on 'X' to remove the position.
  • Click on 'Next' when confirmed.

bc4c36c96687250ab1e9b30a04326ea90e164a961549989287.jpeg

  • The final page allows you a final check of your transactions. Click on 'Import' to import your positions.

0a2e6ff3c5bee929227b55b2ded800776513a1921549989454.jpeg

You will redirected to your newly imported portfolio.

A subscription to Stockopedia will be one of the best investments you'll ever make...

Here's what you'll get:
A decade of research into what works in stock markets
Millions of pounds of platform investment
Countless hours of research time saved
Access to hundreds of educational articles and ebooks
Over 30 talented professionals working flat out for you
A team of the very best bloggers acting as mentors
Saving you thousands in advisory fees every year
Stockopedia is the perfect solution for the time-poor individual investor looking for results
Starting at less than £21 per month

After your free trial, plans start at less than £21 per month. With a one month money back guarantee, there's no risk.

© Stockopedia 2021, Refinitiv, Share Data Services.
This site cannot substitute for professional investment advice or independent factual verification. To use it, you must accept our Terms of Use, Privacy and Disclaimer policies.