The naming convention of the Exercise Trades Report is F_TR02__DDMMYYYY.CSV.gz. The report is available in the directory /FAOFTP/F/REPORTS.
The records in the trades report are as follows:
Trade Number
Trade Date
Activity Type
Market Type
Instrument Type
Symbol
Expiry Date
Strike Price
Option Type
Corporate Action level
Buy Broker
Sell Broker
Trade Price
Trade Date Time
Trade Volume
Trade Token No
Trade Buy Branch
Buy CM Code
Sell CM Code
Trade Sell Branch
Buy Custodial Participant
Buy Side Confirmation
Sell Custodial Participant
Sell Side Confirmation
Buy Covered Uncovered Flag
Sell Covered Uncovered Flag
Buy Old Custodial Participant
Buy Old CM Code
Sell Old Custodial Participant
Sell Old CM Code
Trade Buyer
Trade Seller
Buy Order No
Sell Order No
Buy Account No
Sell Account No
Buy Remarks
Sell Remarks
Buy Position
Sell Position
Buy Proprietor Client Flag
Sell Proprietor Client Flag
Control Flag
Trade Execution Date Time