Excel file import

<< Click to Display Table of Contents >>

Navigation:  Import > LightSpeed >

Excel file import

• 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.