Usage
Download a copy of the Excel Trigger spreadsheet if you do not have it already. Go to a tab called Price Forensics Report. Fill in the required fields as mentioned below
Authentication: Use one of the following methods
Username + Password + OTP (if enabled) .. OR
Token from the Excel Front End menu option of the Canopy Visualizer
Email Address: The generated report (a CSV file) will be emailed to this address. Please check it carefully
Date: This is the date for which the report is required. In case the chosen date is a Saturday or Sunday, the preceding Friday will be used
Login As (optional): Ignore if you are not an administrator
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 |