...
Press the Trigger Report macro button. You should see a message saying that the CSV file has been emailed. Contact Canopy Support in case of any issues
Output
Output is in the format of a CSV file
...
The various fields in the report are:
ticker
requested_date - date for which
child_username
outstanding_qty
Client Px Date
Client Px Clean
Client Px Close(A)
CS Px Date
CS Px Clean
CS Px Close(B)
Diff (B)-(A)%
Default Px Date
Default Px Clean
Default Px Close(C)
Diff (C)-(A)%
ticker | ticker of the relevant security |
requested_date | date for which the report is generated(it will be the preceding Friday in case report is generated for a Saturday or Sunday) |
child_username | username of the child account |
outstanding_qty | quantity as of requested date |
Client Px Date | date of the price used for that child account |
Client Px Clean | price of a bond without accrued interest, blank for all other securities |
Client Px Close(A) | closing price (for bonds this is price including accrued interest) |
CS Px Date | price date for custodian source |
CS Px Clean | |
CS Px Close(B) | |
Diff (B)-(A)% | |
Default Px Date | |
Default Px Clean | |
Default Px Close(C) | |
Diff (C)-(A)% | |
blank |