timetotrade

This is the TimeToTrade help wiki. Use the TimeToTrade Trigger Trading Technology™ to execute your trades when Price, Candle Stick, Trend Line, Volume and Technical Analysis chart conditions are met - no coding required. Trade directly in the world’s global markets. Backtest your Trading Strategies. Calculate your UK HMRC Capital Gains Tax liabilities. Manage your Investment Club.


Import Manual

With TIMETOTRADE you can import and export your accounttransactions. The data export enables you to create a 'point-in-time' copy of your accounts for all account transactions including, share, funds, forex, spreadbet, income/expenditure, member subscriptions, unit cancellations, unit additions, dividends, fund distributions transactions and more. Using the data export you can fully restore your accounts by importing the exported data. The export feature enables you to download your investment transactions in a format that can be opened using Excel or Open Office. The TIMETOTRADE data import feature enables you to import historical investment transaction data from spread sheets. This help section provides support on how to import transaction data into your TIMETOTRADE accounts.


If you are not comfortable with formatting your data or if you feel that there is a lot of work involved, please contact TIMETOTRADE and we can provide this service.


Importing Data while creating a New Account

There are two ways in which you can import your data from Spread Sheets and both require the historical transaction data to be formatted in the same way. The first method that can be used to import your historical transaction data is while creating a new account. To begin navigate to the ACCOUNTS screen using the PORTFOLIO drop down navigation menu as illustrated:


Accounts Navigation.png


When viewing the the PORTFOLIO ACCOUNTS page, click on the ‘add/edit’ button as illustrated in the following screen shot:


Import 1-2.png


To create a new Account follow the instructions on the following screen shot:


Import 2-3.png


After clicking on the import button, the following screen will appear. Use the Browse button to select the historical transaction data file from your desktop that you wish to import. When you have selected the file that you wish to import, click on the import button as illustrated:

Import 1-4.png

Please note that only Spread Sheets saved in a comma separated value (csv) format can be imported.


Importing Data into an Existing Account

You can import data into an Account that you have already created. Typically this is used to import monthly broker statements. To do so, go to the income/expenditure page and click on the import link at the bottom right corner of the screen as illustrated:


Import 1-13.png


After clicking on the import button, the following screen will appear. Use the Browse button to select the historical transaction data file from your desktop that you wish to import. When you have selected the file that you wish to import, click on the import button as illustrated:


Import 1-4.png


Formatting your Investment Transaction Import Data

To import investment transactions from a spread sheet into TIMETOTRADE, your spread sheet needs to be formatted as per the following extract example and then saved as a CSV file:

Format Data For Import 4-1.png


The following steps discuss how to format your data to enable it to be imported into TIMETOTRADE.


To help you create a template and understand how data is entered for the various fields, you could start by manually entering some transactions in your TIMETOTRADE accounts that reflect the type of entries that you would like to import. For example buy some shares, then sell them, then add some dividend transactions. When you are finished export the transaction data from the TIMETOTRADE account to create a template. You can then use this exported spread sheet as a template for the data that you are going to import; or just set up the spreadsheet as discussed below.


Step 1: Header Field Descriptions

The first step requires the formatting of your investment transaction spread sheet data to enable it to be imported into TIMETOTRADE. Start by creating a new spread sheet with the following headers in cells A1 through to P1, where each cell contains the following header titles:

  • A1 = date
  • B1 = taxdate
  • C1 = time
  • D1 = description
  • E1 = typeid
  • F1 = uvs
  • G1 = value
  • H1 = currency
  • I1 = symbol
  • J1 = quantity
  • K1 = price
  • L1 = tax
  • M1 = commission
  • N1 = cashreceived
  • O1 = assettype
  • P2 = transfer
  • Q1 = margin
  • R1 = rollover
  • S1 = point_size
  • T1 = option_symbol
  • U1 = contract_size
  • V1 = equalisation_date
  • W1 = group_2_units
  • X1 = equalisation_payment


After you have created the template with the above field headers, start populating each field by cutting & pasting data from your existing spread sheet to the new spread sheet that you will import to TIMETOTRADE.


The following steps discuss how the data in each field should be formatted before it came be imported to TIMETOTRADE.


Step 2: Date fields

The 'date' and 'taxdate' fields must be saved in the format: yyyy-mm-dd e.g. 2007-03-05 equals the 5th of March 2007. To support share reorganisations TIMETOTRADE uses to date fields 'date' and 'taxdate'. When importing your data, set the 'date' and 'taxdate' to the same values and use the share reorganisation wizard to reorganise investments as it calculates the apportionment of costs and adjusts the taxdate according to the HMRC guidelines. The 'taxdate' is included to enable the import of share reorganisation events from a previous backups of your accounts.


To format the date using Excel, firstly select the cells that contain the dates of the transactions that you wish to import. Then right click on the selected cells and then select the 'Format Cells...' link that appears on the pop-up menu.


A 'Format Cells' pop-up menu will appear, typically with the 'Number' tab selected. Within the 'Category' menu select the 'Custom' category. In the 'Type:' text box, enter the date format by typing: yyyy-mm-dd.


When finished click on the 'OK' button on the bottom right. Your date cells should now appear in the year-month-date format e.g. 2006-08-01


Please note that Excel can reformat your date after you save then re-open your spreadsheet, therefore please ensure that each time you save your spread sheet that your date is saved in the correct format i.e. year-month-day


Step 3: Time

To enable 'Forex' and 'Spreadbet' transactions to be input in the correct sequence the 'time' field can be used. The time should be entered in the 24 hour format using the format "hour:minute:second", with each field separated by a colon e.g. "00:00:00" equals midnight and "23:59:59" equals 1 second to midnight. If the time field is not required set it to '00:00:00' i.e. midnight.


Step 4: Description

This field is typically left blank as descriptions will be automatically generated for transactions after they are imported. For income and expenditure transactions a personal description of the source of income or expenditure can be entered.


When importing historical member unit subscriptions or sales e.g. typeid equals 'unitpurchase' or 'unitsale', the name of the club member should be entered into the description field. Before trying to import club member subscriptions or withdrawals please first using the CLUB PROFILE page to invite the club members to join your club. Please ensure that when entering unit subscriptions or unit sales that you accurately type the name of the club member in the description field, using the same spelling as the name displayed in the CLUB PROFILE page, which is located in the PROFILE drop down menu. If the member name can not be matched with a CLUB PROFILE member name, an error will be generated.


Step 5: Type ID

The 'typeid' field is used to identify the transaction type associated with each line item in the spread sheet, for example Buy or Sell shares. The following provides a list of the typeid transaction types that are supported by TIMETOTRADE. Please note that it is important that you use the correct transaction typeid as this is required for general accounting and preparing capital gains and income tax calculations:


typeid type description
adjustexpenditure expenditure This field is used to balance accounts by adding an expenditure.
adjustincome income This field is used to balance accounts by adding income.
advertising expenditure Used for expenditures on advertising
bankcharge expenditure Used for general bank charges
bonus_issue income Used to identify share reorganisation bonus issues.
brokercharge expenditure Should be used to identify broker charges relating to monthly, quarterly or annual account administration or inactivity fees
buylong expenditure Used for a long 'Buy' share transaction i.e. make money by selling at a higher price
buytoclose expenditure Used to close a short option position e.g. covered call.
buytocloseforex expenditure Used to close a short (sell) forex position
buytoclosespreadbet expenditure Used to close a short (sell) spreadbet position
buytoopen expenditure Used to open a long option position e.g. buying an option with the view to selling at a higher price
buytoopenforex expenditure Used to open a long (buy) forex position e.g. buying with the intention selling for a profit at a higher price
buytoopenspreadbet expenditure Used to open a long (buy) spreadbet position e.g. buying with the view to selling for a profit at a higher price
calledout income Used to call out an option e.g. if you sold a covered call and were called out
cap_reorg income Used in association with capital reorganisations
cash income Used to identify cash received from share reorganisations.
cashdeposit income Used to identify cash that has been deposited into your account
cashwithdrawal expenditure Used to identify cash that has been withdrawn from your account
consolidation income Used to identify share consolidation reorganisations
covershort expenditure Used to close a short share position e.g. buy back shares that you had sold short
demerger income Used to identify demerger share reorganisations
dividend_dom income Used for domestic dividends i.e. dividends from UK listed companies
dividend_os income Used for overseas dividends e.g. dividends from US or European listed companies
expire income Used to expire an option position e.g. if you sold a covered call and it expired worthless
fund_buy expenditure Used to identify the purchase of a fund e.g. Unit Trust or OEIC
fund_dividend_dom income Used to identify a domestic dividend received from a fund e.g. if you are a UK resident and received a dividend from a UK based fund, it would be classified as a domestic dividend
fund_interest income Interest received from a fund e.g. Unit Trust or OEIC
fund_notional_dividend_dom income Notional dividends from a domestic fund. A notional dividend is not received in cash as it is re-invested, however as a source of income there is a related tax liability.
fund_notional_interest_dom income Notional interest from a domestic fund. A notional interest payment is not received in cash as it is re-invested, however as a source of income there is a related tax liability.
fund_reinvest expenditure Used to identify a dividend of interest payment that is re-invested and used to purchase additional units in a fund
fund_sell income Used to identify a closing sell fund transaction e.g. used to identify the sale of units in a Unit Trust or OEIC
fund_tax_credit_refund income Used to identify a tax credit refund from a fund.
gross_interest_dom income Used to identify gross domestic interest received i.e. interest that has not been taxed from an account held in your country of residence
gross_interest_os income Used to identify gross overseas interest received i.e. interest that has not been taxed from an overseas account
income_other_dom income Used to identify other sources of domestic income i.e. income from sources other than interest from a source within your country of residence
income_other_os income Used to identify other sources of overseas income i.e. income from sources other than interest from an overseas source
merger income Used to identify a merger share transaction.
net_interest_dom income Used to identify net interest received from a domestic account i.e. UK interest that has been taxed at 20%
net_interest_os income Used to identify net interest received from an overseas account i.e. interest that has been taxed in an overseas account
openingbalance income Used to identify an Opening Cash balance
open_offer expenditure Used to identify an opening offer share reorganisations
otherexpenditure expenditure Used for a general expenditure type were no other typeid is suitable
postage expenditure Used to identify expenditures on postage
premises expenditure Used to identify expenditures on hiring premises e.g. the cost of hiring a room for an investment club meeting
professionalfees expenditure Used to identify expenditures on Professional Services e.g. paying an accountant to audit your accounts
putto expenditure Used to identify options transactions where options are 'put to' you
rights_issue income Used to identify a rights issue share reorganisation
selllong income Used to close a long share position by selling e.g. 'sell' shares that you own
sellshort income Used to open a short share position by selling e.g. short selling shares in a company
selltoclose income Used to close an option position by selling e.g. if you bought options then sold them to close the position
selltocloseforex income Used to close a forex long (buy) position by selling
selltoclosespreadbet income Used to close a spreadbet long (buy) position by selling
selltoopen income Used to open an option position such as selling a covered call option
selltoopenforex income Used to open a short (sell) forex position
selltoopenspreadbet income Used to open a short (sell) spreadbet position
software expenditure Used to identify expenditures on software
split income Used to identify a split share reorganisation
stationary expenditure Used to identify expenditures on stationary
telephone expenditure Used to identify expenditures on telephone calls
transferin income Used to identify money that has been transferred into an account from another. Please leave blank and use the account cash transfer function.
transferout expenditure Used to identify money that has been transferred out of an account to another. Please leave blank and use the account cash transfer function.
unitbrokerage income Used to identify a brokerage charge that is applied to the sale of a club member's units
unitpurchase income Used to identify a the purchase of units by a club member
unitsale expenditure Used to identify a the sale of units by a club member


If you have used alternative typeid or letters to describe your transactions, for example 'BUY' to identify a 'buylong' transaction or 'SELL' to identify a 'selllong' transaction, you can use the 'Find and Replace' function or alternatively the 'IF' Excel function to change your typeid descriptions. For example assume that your spread sheet typeids are BUY and SELL, which you will need to change to buylong and selllong.


To do this using the 'Find and Replace' Function - click on the 'Edit' button on your spreadsheet. Go to 'Find'. A text box appears. Click on the Replace tab. Next to 'Find what' type in the word you wish to find, in this case BUY. We want to replace all references to the word BUY with buylong, so next in the 'Replace with:' box type buylong. Click the 'Replace All' button underneath .. and that's it. All occurances of the word BUY have been replaced with buylong.


The following is an example of how the IF function can be used to change the typeid from BUY to buylong and SELL to selllong:


A B
1 typeid IF function
2 BUY =IF(A2="BUY","buylong", IF(A2="SELL","selllong","Type not defined"))
3 SELL =IF(A3="BUY","buylong", IF(A3="SELL","selllong","Type not defined"))

In plain English the IF statement reads as follows:

If the typeid equals BUY, then change the typeid to buylong; if the typeid equals SELL, then change the typeid to selllong; if the typeid is not equal to BUY or SELL, then display the message "Type not defined".


Please note that you can add multiple IF statements to translate a variety of different typeids.


After you have changed the typeids, as per the examples in row 'B' above, cut and paste the new typeids into the new spread sheet that you are preparing for import into TIMETOTRADE. When pasting the data into the new spread sheet, use the 'paste special' function and paste the new typeid data as 'values'. To do this, when pasting right click, then select 'Paste Special...' then select the 'Values' paste option.


Step 6: UVS

The 'uvs' field is used to identify transactions that are included or excluded from the Unit Valuation System (UVS). By default all transactions should be included by setting the uvs field to '1' (i.e. true). Unit Cancellation and Unit Addition income or expenditure transactions are identified by setting the uvs field of '0' (i.e. false). If the uvs field is set to 0, then TIMETOTRADEwill determine if the units should be added or cancelled based on the typeid being an expenditure or source of income.


Step 7: Value field

The value field is the total income or expenditure associated with the transaction. For member subscriptions or withdrawals it is the total cash amount associated with the club unit transaction. The value field should be denominated in Pounds, Dollars or Euro with support for up to 6 decimal places e.g. an expenditure of £152.123456 would be entered 152.123456 or an income of 28 pence would be entered 0.28


All expenditure or income values must be represented as positive numbers.


The cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 6 decimal places.


Step 8: Currency field

Enter the currency symbol associated with the transaction, for example if you purchase shares in the UK the currency would be GBP, in the US it would be USD and for Europe it would be EUR. The list of currencies available include:

EUR Euro
GBP British pound
USD US dollar
AUD Australian dollar
CAD Canadian dollar
HKD Hong Kong dollar
JPY Japanese yen
NZD New Zealand dollar
SGD Singapore dollar
CHF Swiss franc
ZAR South African rand
MXN Mexican peso
SEK Swedish kronor
CZK Czech koruna
DKK Danish krone
NOK Norwegian krone
RUB Russian Ruble
HUF Hungary Forint
ILS Israel Shekel
PLN Poland Zloty
THB Thailand Baht
TRY Turkey Lira


Step 9: Symbol field

Ticker symbols or full company names can be imported into TIMETOTRADE. It is recommended that you use ticker symbols when importing your investment transactions as this will enable TIMETOTRADE to identify the investment and look up market data such as current and historical price performance. Using ticker symbols as opposed to the full name also reduces errors relating to typos when recording transactions; this is important as to implement share identification a standard format must be used to identify each investment transaction.


As TIMETOTRADE has been designed to support international exchanges, we have adopted the Reuters symbol format. Therefore .L most be added to UK EPICs e.g. the EPIC for Barclays is BARC and this should be entered into TIMETOTRADE using the symbol BARC.L


If you already using EPICs however do not include the .L then you can use the & Excel function to add the .L to your EPICs. The following Excel Spread sheet example demonstrates how to use the Ampersand (&) Excel function:


A B
1 EPIC & function
2 BARC =A2&".L"
3 VOD =A3&".L"

When pasting the symbols into the new spread sheet, use the 'paste special' function and paste the new typeid data as 'values'. To do this, when pasting right click, then select 'Paste Special...' then select the 'Values' paste option.


If you have historically recorded your share transactions using the Company name only, then it is recommended that you convert the name format into a ticker symbol format. For example the ticker symbol for the company VODAFONE is VOD.L Alternatively you can simply use the company name and add it to the Symbol field; please ensure that you use a consistent reference to a given company e.g. if you have entered Vodafone sometimes as "Vodafone" then "Vodafone plc", change all references to Vodafone to a standard format. Please note that TIMETOTRADE can not identify investments that do not have a ticker symbol and as a result it can not provide live price updates or calculate historical performance, identify what sector that company is in, etc.


To identify symbols that are supported by TIMETOTRADE, please use the symbol lookup feature on the 'charts' page as illustrated:


Import 3-1.png


Step 10: Quantity field

The quantity field defines for example how many shares or options are associated with the transaction. For example if you bought 100 shares in Vodafone, the quantity would be 100. It is also used to identify the number of units associated with a 'unitpurchase' or 'unitsale' made by an investment club member.


The quantity cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 6 decimal places.


Step 11: Price field

The price information must be entered in Pounds, Dollars Euros etc. If for example you paid 325 pence for Barclay shares, that price field data should be entered as 3.25


The price cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 6 decimal places.


Step 12: Tax field

The tax field information must be entered in Pounds, Dollars Euros etc. If for example you paid £25.04 in Stamp Duty the data should be entered as 25.04


The tax cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 6 decimal places.


Step 13: Commission field

The commission field information must be entered in Pounds, Dollars, Euros etc. If for example you paid £12.95 in Commission after you bought or sold a share, the data should be entered as 12.95


The tax cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 6 decimal places.


Step 14: Cash Received

The cash received field should be used to enter cash received from share reorganisations. The cash value should be entered in Pounds, Dollars, Euros etc. If for example you received £50 of cash as part of a share reorganisation enter 50.

The cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 6 decimal places.


Step 15: Asset Type

The asset is used to identify business (non-listed) and non-business (listed) share transactions. The assettype field values should be one of the following when entering share transactions:


value description
business used to identify 'business' or 'non-listed' shares as defined by the HMRC
non-business used to identify 'non-business' or 'listed' shares as defined by the HRMC
not applicable the default state, which assumes that the shares are of the type non-business


Step 16 Transfer

The Transfer field is used to identify shares that are transferred 'in' and 'out' of an account. If a trade is flagged as a transfer, it will increase or decrease the open position, without changing the cash balance. If transferring shares out of a broker account, then enter a sell order at the cost associated with the opening order and set the transfer field to 'transferOut'. If transferring shares into a broker account, then enter a buy order at the cost associated with the original opening order and set the transfer field to 'transferIn'. Please note that the Capital Gains Calculator ignores transfer In and transfer out transactions. You will need to create the original order in an account that the shares where transferred out of, in order to match the final disposal in the account the shares where transferred into.


Step 17: Margin field

The Margin field is used for leveraged products such as Forex and Spreadbet transactions. The values must be entered in Pounds, Dollars Euros etc. If for example £12.95 was allocated in Margin, the value should be entered as 12.95


The cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 6 decimal places.


Step 18: Rollover field

The Rollover field is used for leveraged products such as Forex and Spreadbet transactions; it is used to track the interest paid or received on open positions. The values must be entered in Pounds, Dollars Euros etc using a minus sign "-" for expenditures. If for example you received £1.55 in rollover interest, the value should be entered as "1.55"; if however you had to pay £1.55 in interest, the value would be entered as "-1.55".


The cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 6 decimal places.


Step 19: Point Size field

The point size determines what range of price movement equals one point. It is primarily used in calculating profit on leveraged products such as spreadbet transactions. For example if you have a spread bet position on a UK stock the you bought at 255 pence and an increase in 1 pence to 256 pence represents one point, then the point size field would be set to "1". If for example you had a spread bet on a US stock, which you bought at $19.25, if your bet is one point per cent the point size would be "0.01". Typically when spreadbetting on a currency such as GBPUSD the point size is 0.0001.

For legacy reasons opening and closing forex transactions require that the point size value be set to "1" for all currency pairs. This historically was used to identify JPY transactions, however we now use the symbol to identify the 'pip / point size'. Please set the point size field for all forex opening or closing transactions to "1".


Step 20: Option Symbol field

When entering option transactions, you must enter the company Symbol associated with the option transaction. If for example you sold a covered call against Taiwan Semiconductor Manufacturing (symbol = TSM), then please enter the TSM in the symbol field. In the Option Symbol field you then enter the option symbol that you sold. In the TSM example a valid option symbol would be TBD JB with a space between the route option symbol and the month and quantity letter ie. JB


It is recommended that you create some example option transactions in TIMETOTRADE and export the associated account to familiarise yourself with how to import options transactions.


Step 21: Contract Size

The contract size should state either:

  • 100
  • 1000

The contract size field is used to identify the number of shares associated with the option contract. American style options typically have 100 shares, and European style options typically have 1000 shares associated with them.


The contract size cells should be formatted to the type 'Number'. To do this, select the value cells in your new spread sheet that you will be importing into TIMETOTRADE, and right click. When the 'Format Cells' pop-up menu appears, select the Category Number and adjust the decimal places up to 0 decimal places. TIMETOTRADE only support whole number quantities therefore the decimal places should be set to zero. The values used should either be 100 or 1000.


Step 22: Equalisation Date

The equalisation date is used to identify the date that an equalisation payment from a fund such as a Unit Trust or OEIC is based on. The date must be saved in the following format: yyyy-mm-dd e.g. 2007-03-05.


Step 23: Group 2 Units

Enter the number of Group 2 Units associated with the equalisation payment. The number should be formatted to 6 decimal places.


Step 24: Equalisation Payment

Enter the value of the Equalisation payment received from the return of capital on the Group 2 Units. Format the number to 6 decimal places.


Step 25: Save your Spread Sheet as a csv file

To import your historical investment transaction, save your spread sheet as a csv (comma separated variable)


Before saving your spread for importing into TIMETOTRADE, please ensure the following guidelines have been meet:


  • The first line should be the headings i.e. "date, taxdate, time, description, typeid, uvs, value, symbol, quantity, price, tax, commission, margin, rollover, point_size, option_symbol, contract_size, equalisation_date, group_2_units, equalisation_payment"; the following lines should contain a entry for each heading, with the exception of the description field. If a field is blank, please enter the number zero and ensure that the number zero is formatted as a number. Blank fields may work depending on how you created the csv file; if zeros are not used commas are still required for the blank entries. e.g. 4,1,,,,,,,
  • Field entries should not be preceded or followed by spaces or quotes
  • Excel reformats dates and figures based on localisation settings; Word reformats some characters and will insert other characters on editing; to prevent reformatting after creating your csv file use a plain text editor such as Notepad to edit it or alternatively if you use Excel ensure that the date format is correct.
  • Sometimes you can accidentally create blank cells that are outside of the fields defined. To prevent commas being added to the csv file when using a spread sheet, please delete the cells to the right and below the data that you have entered. If you view the csv file with notepad, there should be no commas after the last field.
  • After you have imported your data into TIMETOTRADE, please cross check the 'total' fields to ensure that the data was entered correctly. TIMETOTRADE calculates the totals from the price, quantity, commission and tax fields associated with the import data and does not use the value field.


Step 26: Import your csv file

You can import your csv (comma separated value) file as discussed at the top of this help section.


Step 27: Understanding Error Messages

If your data has not been formatted correctly you will receive an error message. The following table provides a list of the common error messages and how to resolve them:


Error Message Resolution
First line must be headings - 'date, description, typeid, value, symbol, quantity, price, tax, commission, option_symbol, contract_size'. Check that you have correctly typed the header titles and they are in first row of the spread sheet, starting at cell A1. Ensure that their are no spaces either before or after the text.
Line has n fields, should be 11. n will be a number that represents the number of fields being imported. You must have field headers for all 11 fields and zeros in the Option Symbol and Contract Size fields when there are no values to be imported.
Line has an invalid 'date' field, must be yyyy-mm-dd. Please save the date in the correct format as discussed above; year-month-day
Line has an invalid 'value' field. 'invalid' means missing or not a number.
Line has an invalid 'typeid' field Please ensure that you have used a valid typeid as discussed above.
Line has an invalid 'contract_size' field - n. The contract size should either be 0, 100 or 1000 as discussed above. n is the current field value. For blank fields enter a zero.
Line has an invalid 'option_symbol' field. Option symbol has not be entered in the correct format. For blank fields enter a zero.
Line has an invalid 'symbol' field. The symbol format is not valid.
Line has an invalid 'quantity' field. The quantity field is not valid. Ensure that your quantity is saved in the 'number' format as discussed above
Line has an invalid 'price' field. The price field is not valid. Ensure that your price is saved in the 'number' format as discussed above


Contact Us

If you are having any difficulty importing your transactions, please contact us



It has never been easier to execute your trading strategy. Our Trigger Trading Technology ® means you can now automatically execute your trades directly in the world’s global markets.


You need never miss a trading opportunity again!


Do you want to:

  • buy when your technical analysis chart conditions are met? Really buy, not just get an email or sms alert?
  • or sell when a support trend line is broken?
  • or back-test your strategy going back as far as 30 years?


TimeToTrade's Trigger Trading Technology™ is truly game changing. It gives you a trading advantage. The power to take your trading to a new level.


Open a FREE TimeToTrade account today to:


  • Trade UK, US and European Shares - apply now
  • Execute trades when your Price, Candlestick, Trend Line, Volume and Technical Analysis chart conditions are met using the Trigger Trading Technology® - learn more - help video
  • Email and SMS Trigger Trading™ Alerts - learn more
  • Trade Off The Chart - learn more
  • Back Test Trading Strategies with up to 30 years of historical data - learn more
  • Create Simulated Trading Accounts to test your Trigger Trading™ Strategies - learn more
  • Real time Forex, UK, European and US stock market data - learn more
  • 170+ Technical Analysis and Candlestick Pattern Indicators - learn more
  • All the tools you need to set up and run a successful investment club - learn more
  • Manage your Portfolio and calculate UK HMRC Capital Gains liabilities and SA 108 CGT Tax Returns - learn more
  • Create Trading Competitions for you and your friends - learn more
  • Apply for a trading account today to get the Live Account Features - apply now


Apply now to try our superb platform and get your trading advantage.



The information and data provided is for educational and informational purposes only. Interpretation and use of the information and data provided is at the user's own risk. All information and data on this website is obtained from sources believed to be accurate and reliable. However, errors or omissions are possible due to human and/or mechanical error. All information and data is provided "as is" without warranty of any kind. We make no representations as to the accuracy, completeness, or timeliness of the information and data on this site and we reserve the right, in its sole discretion and without any obligation, to change, make improvements to, or correct any errors or omissions in any portion of the services at any times. Past performance is not a guarantee of future results. Trading carries a high level of risk to your capital and can result in losses that exceed your deposits. It may not be suitable for everyone so please ensure you fully understand the risks involved.


All services are provided by TigerWit Limited. TimeToTrade is a trading name of TigerWit Limited (a company registered in England and Wales under number 9479466). Our Registered address is TigerWit, 7th Floor, Augustine House, 6A Austin Friars, London, EC2N 2HA, England. TigerWit Limited is authorised and regulated by the Financial Conduct Authority number 679941.


The trading services offered by TigerWit Limited are not available to residents of the United States and are not intended for the use of any person in any country where such services would be contrary to local laws or regulations. Subscriptions to TimeToTrade products are available if you are not eligible for trading services.


Spread bets and CFDs are complex instruments and come with a high risk of losing money rapidly due to leverage. 77% of retail investor accounts lose money when trading spread bets with this provider. You should consider whether you understand how spread bets and CFDs work, and whether you can afford to take the high risk of losing your money. All clients should be aware that trading involves risk.

Retrieved from "?title=Import_Manual&oldid=37342"