Skip to content

Importing Data

ShareCalc supports importing data directly from your broker account statements. Currently, the system only supports Interactive Brokers, but if you have a preferred broker, please get in touch and we will add support.

To import data, go to the "Import" link in the left hand sidebar and click the "Import New Data" button. Select the account you want the imported data to belong to, the file format, and the default time zone.

The default time zone controls how the date field of a transaction is interpreted:

  1. When a date has a time with a time zone (like '2024-02-14 15:30 +00:00'), it uses the time zone specified.
  2. When a transaction has a time but no time zone (like '2024-02-14 15:30'), it uses your default time zone setting.
  3. When a transaction has only a date (like '2024-02-14'), it's recorded as midnight London time.

Note: Ex-dividend dates are pure calendar dates - they don't have an associated time. They're simply that date in London time.

When you calculate your taxes, all times are converted to London time and are considered to occur on the resulting calendar date.

Interactive Brokers

The data import for Interactive Brokers uses their Flex Query XML format. To create the report(s) that you need, follow these steps:

  1. Login to your Interactive Brokers account.
  2. Go to the Flex Query subsection under the Performance and Reports menu.
  3. In the Active Flex Query section, click the plus icon to create a new report.
  4. ShareCalc requires the following sections. For each section select all the available fields.
    1. Cash Transactions
    2. Change in Dividend Accruals
    3. Corporate Actions
    4. Trades
    5. Transaction Fees
    6. Transfers
  5. In the Delivery Configuration section, set the format to XML.
  6. In the General Configuration section, make sure the following are set:
    1. Date format: yyyyMMdd
    2. Time format: HHmmss
    3. Date time separator: ;
    4. Breakout by day: No
  7. Save the report.
  8. Run the report for the date range you want to import, being careful not to include any overlapping data.
  9. The XML output can be imported into ShareCalc.

Halifax Sharedealing

There's limited support for parsing investment history from Halifax Sharedealing (HSD) accounts. HSD reports display only the net consideration or proceeds in GBP terms so the report view does not display information such as the actually transaction currency, fees, or the tax withheld. Further, dividends are displayed with the issue date instead of the pay date, which may be relevant to your situation. As a result, it's very important to consider the data imported from HSD as a convenience that requires further review and editing.

The HSD import supports importing data from the Dealing History, Dividend History, and Cash History reports. You can find each report under the Valuation & Statements section on the right hand side of the HSD website. The steps for each report are the same. Please note that the Cash History report only imports Fees, Withdrawals, and Deposits.

To create a report, follow these steps:

  1. Select the report on the right hand side of the HSD website.
  2. Enter the search period of the transactions you want to import and list them on the page.
  3. When the transactions are visible, click on the Printer Friendly View above the search section.
  4. Save the full HTML page to your computer and upload the .html file to ShareCalc.

ShareCalc CSV

The CSV specification is still being finalised and will be available soon.