Uploading a Watchlist to CA Web
Viewing and Exporting Watchlists
Parameters for Uploading a Watchlist
CA Web provides you with a helpful tool to upload lists of securities in order to perform simple searches and/or a very specific, advanced search on specific CUSIPs.
Once you have compiled a list of securities that you wish to specifically inquire about, you can upload this list to CA Web. You can upload a maximum of 20 watchlists.
On the menu bar, hover your mouse over Announcements and click Watchlist.
This brings you to the Watchlist page.
Enter a name for this watchlist in the Description field.
Click Browse to select a file for upload.
Note: Prior to uploading a watchlist, you must have already created a watchlist document based on the Watchlist Parameters.
Click Upload.
Note: You can choose a new file instead by clicking Reset or cancel the upload by clicking Cancel.
Once you have successfully uploaded a watchlist, a confirmation message appears at the bottom of the Watchlist page.
Note: It is important to verify that the number of securities uploaded on your file matches the number of securities uploaded.
You can view a watchlist once it has been added to CA Web.
On the menu bar, hover your mouse over Announcements and click Watchlist.
This brings you to the Watchlist List page.
Click the name of the watchlist you want to open.
The Upload page opens for that watchlist.
Click the here link to open the spreadsheet.
Excel opens and displays your exported spreadsheet.
Note: The column heading Security ID is generated systemically. This column heading does not need to be added during the initial upload of securities.
After a watchlist has been uploaded, you can begin to perform searches on the securities within this watchlist to inquire about any Corporate Actions events concerning them that have been announced.
On the menu bar, hover your mouse over Announcements and click Event Search.
The Event Search page appears.
Notes:
Use the Custom Search tab for a quick search. Use the Advanced Search tab for a more granular search.
When using the Advanced Search, you must select Date Criteria as part of your search.
For groups of radio buttons/check boxes such as Event Group, Composite Record Status, and DTC Mandatory/Voluntary, it is important that you understand what specifically you are searching for. If you are not looking for a specific event, select “All” in order to get as many results as possible.
Please see the Quick and Custom Search topic for more information on using the Search functionality.
In the Limit to section, select a watchlist to use for your search.
Note: All of your saved
watchlists will appear in the Watchlist
drop-down menu. You can only search by one watchlist at a time.
If you want to limit your search further, use the checkboxes below
the watchlist drop-down menu.
Click Search.
Your search results will contain matching items from your watchlist. If there are no matching items, a message appears at the top of the search page.
The following watchlist rules apply to files being uploaded to CA Web:
The files must be
in Excel format with a .csv or .xls
(version 1997-2003) file extension. If you use any other format, you
will get an error message such as the following :
A maximum of 3000 securities can be uploaded to a watchlist.
A maximum of 20 separate watchlists can be maintained for a single account.
The spreadsheet file will need only one column (no heading needed):
Security
number (e.g. 023663AB3)
A CUSIP is the only acceptable security type for inclusion in a watchlist.
CA Web validates that each CUSIP in the watchlist meets the required criteria. It does not validate the CUSIP itself. For example:
ISIN “12345678” is not a valid format for CUSIP, which requires 9 alphanumeric characters. It will not be uploaded.
The particular CUSIP “123456789” is not a valid CUSIP. However, it will still be uploaded as part of your watchlist, as it meets the format requirements of a CUSIP (i.e., nine alphanumeric characters).
You will be notified whenever a security is not accepted. For example :
Now you are ready to upload your watchlist (see Uploading a Watchlist for more information).