Please enable JavaScript in your Internet Explorer Internet Options to view this documentation.

TradingDiary Pro

Navigation: Import > LightSpeed

Excel file import

Scroll Prev Top Next More

* * HELP & MANUAL PREMIUM PACK 3 DEMO VERSION * *

This documentation was styled with a demo skin from the Premium Pack 3 add-on for Help & Manual. The contents of the skin are encrypted and not configurable.

This version is copyright and may only be used for local testing purposes. It may not be distributed.

Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice.

Log into the Lightspeed website

Navigate to the Apex Clearing link

Go to the "trade activity" link in one of the tabs

Set the start date and end date (time frame) of the data that you need to retrieve and download the excel file.

 

Please make sure that the file format is the following:

 

AccountTypeDescription

TradeDate

SettlementDate

ExecutionTime

TradeNumber

CUSIPSymbol

ISIN

ShortDescription

BuySellCode

Quantity

Price

PrincipalAmount

CommissionGrossCalculated

OtherCommission

NetAmount

CurrencyCode

Trailer

EntryDate

 

Start TradingDiary Pro. Set 'LightSpeed' as the import module. For detailed information read the Import Introduction chapter.

Click on the Import/Import - LightSpeed menu and select the previously saved file.