Tutorial: Importing Transactions

In this tutorial, we will look at how to import transactions from different sources into ShareScope.

You can import transactions from other sources providing they are in one of the following file formats:

  • .CSV
  • .EXP
  • .TSV

The file will need to contain the following information:

  • Date - The format can be selected during the import process - see below.
  • Time - Optional - will be used if present.
  • Exchange - Optional - ShareScope assumes the share is listed on the LSE. If the share is listed on a different exchange or is a different type of instrument then you will need to use an exchange code column - see below.
  • Ticker - Also known as EPIC or TIDM. This is the exchange code for the share and is the primary identifier for the share.
  • Type - This is the type of transaction for that row and can be any of the following:

BUY

Buy

SELL

Sell

DIV

Dividend

OTHER ACQ

Other acquisition

OTHER RET

Other Return

OTHER COS

Other Cost

RIGHTS

Rights Issue

SELL N

Sell nil paid rights

SCRIP

Scrip dividend

INIT

Initial Part Payment

PART

Part Payment

SPLIT

Share Split

CONS

Share Consolidation

CREDIT

Cash Credit

DEBIT

Cash Debit

INT

Cash Interest

CHARGE

Cash Charge

XXXXX

Ignore this Transaction

  • Shares - This is the number of shares involved in the transaction
  • Price - This is the price per share paid or received and is in the lower denomination of the currency i.e. pence/cents.
  • Broker & Stamp - Both of these charges are optional and are recorded in the higher denomination of the currency i.e. pounds/euros/dollars
  • Total - This is used for Credits and Debits which will be recorded in an optional Cash Account that can be created upon import.
  • Note - This records a note against the individual transaction and is optional.

Exchange codes

To locate the full list of exchange codes used in ShareScope, click on Help in the menu bar, choose Help - contents and search. Select the Index tab. Type: "Exchange codes"

Here is a selection of the more popular codes that are used in ShareScope.

Exchange

Code

London Stock Exchange

LSE

Nasdaq (US)

NAS

New York Stock Exchange (US)

NYSE

UK Unit Trusts

UT

If the transactions that are to be imported are not recorded in GBP then a row will need to be inserted at the top of the file to indicate the currency of the portfolio.

The import function looks for the currency code in the first row so you can write "Currency: USD" or "In EUR" or just "USD" as examples.

This is how the transactions would look in Excel prior to saving in the correct format.

When you save the file you will need to make sure you save it with the correct file type.

To save the file as the correct type select the Save As option in Excel and then select the Save as type: drop down list and select the CSV (Comma delimited) (*.csv) option. This process should be the same in any other spreadsheet software you may be using.

Once you have a file with the correct details and in the right format. Open ShareScope, then click on File in the menu bar, choose Import and select Import transactions

Select the file containing your transactions and click on Open.

ShareScope will scan the file and query any columns that it does not recognise.

You can either choose to 'Ignore this column' or identify it from the drop down list.

In this example a file containing transactions has been exported from SharePad and is being imported into ShareScope. SharePad has a unique id for shares called IONICID as this cannot be recognised by ShareScope it can be ignored.

Once you have dealt with any unknown columns ShareScope will prompt you to Choose a name for the portfolio.

Enter a name for your new portfolio.

Note: If the name of the imported portfolio has already been used, you will have to enter a different name to proceed. Two portfolios cannot have the same name in ShareScope.

The option to create a new cash account is also available if you have Credits and/or Debits in your transaction file then you should tick this option.

Also, if you wish to create a toolbar button, you can do so. Once you have made your selections click on OK


You will then be prompted to specify the date format you have used in transaction file.

If the import function identifies any unknown transaction type it will ask you to confirm a type for the transaction in question.

Click on OK when done. You should see the following confirmation message

Click on OK and a notepad will open with a list of the shares that were not found during the import process.

The portfolio and, if you chose to create one, the cash account will have been created and you will be able to select them using Select a portfolio.