The file upload facility supports comma separated value (CSV) files. If you are creating or modifying a file in a spreadsheet program such as Microsoft Excel, it is important that you save the file as a CSV before uploading to Sharesight. To do this, click ‘save as’ and then choose CSV in the file type drop down box.
The first row of your file should contain a header for each column as described below. It is important that the column headers and data values match the format supplied below to ensure that your data is imported correctly.
Compulsory Fields
| Column Header | Description | Accepted Values | Example | Notes |
|---|---|---|---|---|
| traded_on | The date of the trade | dd/mm/yyyy | 22/05/2005 | |
| symbol | The stock ticker symbol and market code separated by a period. | code.market | TLS.AX | market_code and instrument_code can be accepted in place of symbol |
| quantity | The quantity of shares bought or sold | Integer (should be a positive value, fractions are not allowed) | 1000 | |
| price | The price per share in the currency of the market | Decimal (up to 6dp) | 12.123456 | |
| transaction_type | Whether the trade was a buy or sell | BUY,SELL | BUY |
Optional Fields
| Column Header | Description | Accepted Values | Example | Notes |
|---|---|---|---|---|
| market_code | The market code (2 or 3 letter version of the code can be accepted) | AX, NZ, ASX, NZX | AX | market_code and instrument_code can be accepted in place of symbol |
| instrument_code | The instrument Code | code | TLS | market_code and instrument_code can be accepted in place of symbol |
| exchange_rate | The exchange rate to be applied to the share price (and brokerage if applicable). Quoted as the amount of foreign currency that equals $1 of local currency | Decimal (up to 6dp) | 1.123456 | If not specified will default to 1 |
| brokerage | The brokerage paid per share in the brokerage_currency specified. | Decimal (up to 2dp) | 39.95 | If not specified will default to zero |
| brokerage_currency | The currency code that the brokerage was paid in. It must be either your local currency or the currency of the market | AUD, NZD | AUD | Optional, If not specified will default to the market currency |
| comments | Comments to be stored in the comments field for the transaction | text | Recommended by Market Analysis newsletter |
The Sharesight file upload facility also directly supports export files from the following systems:
Please contact us if you would like to request support for other export files.