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