SharePad lets you import transactions from other sources to avoid having to re-record your portfolio's history by hand.
Follow these instructions to create and import a compatible file containing all of your transaction history.
If you are a Stockopedia user, follow these steps in order to create a file you can import into SharePad:
Open the Transactions view of your Stockopedia portfolio:
Scroll to the bottom of the page and press the Download button, then select CSV:
Save the file. We recommend saving to your Desktop as it will be easier to find.
If you have been maintaining a portfolio in Excel or have downloaded it from another system (FT.com, Google Finance etc.) you can use Excel (or similar programs) to convert it to a format which SharePad can import.
Here you can see an example transaction file:
The transactions must be recorded one per row, with the first row reserved for the column headings. The position of the columns can be rearranged and the transactions themselves can be recorded in any order.
|Date||The date of the transaction. There are four accepted date formats: DD/MM/YYYY, DD-MM-YYYY, YYYY/MM/DD and YYYY-MM-DD.|
|Time||Optional. The time of the transaction. Can be recorded in HH:MM or HH:MM:SS format. If omitted it will default to 12:00.|
|ShareID||The instrument's identifier. This can be the TIDM, Sedol or ISIN (in the example above all three IDs are for GlaxoSmithKline PLC).|
|Type||The type of transaction. This can be buy, sell, dividend, credit or debit. The first three refer to a specific share, while the latter two are used to record cash transactions. Cash transactions only require the Date and Total fields to be completed as well.|
|Shares||The number of shares involved in the transaction. Only required for buy, sell and dividend transactions.|
|Price||The per share value of the transaction. As SharePad only supports transactions recorded in GBP, currency symbols are not used. If a p is appended, the number is interpreted as pence, otherwise it defaults to pounds.|
|Broker||The transaction's broker charge in pounds. This can be left blank and is only relevant for buy and sell transactions.|
|Stamp||The transaction's stamp duty in pounds. This can be left blank and is only relevant for buy and sell transactions.|
|NonCash||If set to "1" the transaction will be considered a Non-Cash transaction and will not add a corresponding credit or debit to the cash view.|
|Total||This is only required for credit and debit transactions where it is the amount credited or debited. This field is ignored for buy, sell and dividend transactions.|
|Note||Optional - you can record a comment about the transaction (limited to 120 characters).|
The file needs to be saved in Comma Separated Value (CSV) format. Although some spreadsheet programs allow you to choose an alternative separator (semicolon or tab), SharePad will only accept CSV files with a comma as the separator.
Fields can be written between quotes or not: GSK and "GSK" are treated the same. Quoting is only necessary if your Note field contains a comma. For example, the text target 230, stoploss 190 is an invalid entry as the comma will split it into two separate fields, but "target 230, stoploss 190" will be imported correctly.
In SharePad, press the button and select Import portfolio from file.
Select the format of the transaction file you wish to import, then press the Browse button which will let you select your file.
If you wish you can change the name given to the portfolio, then press OK to confirm.
The next screen will list all of the shares identified in the file. If SharePad can find more than one match for one of the instruments in your file it will default to the LSE-listed instrument. In our example, SharePad would match the identifier "GSK" with both the LSE- and NYSE-listed instruments. In this case, click on the Other button displayed next to the instrument to cycle through all matching items.
Once you are happy that the correct instruments have been identified, click on Add to import your portfolio.
Any transaction which could not be imported will be displayed as an error. You can correct any errors and re-import the file.