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.