How can I provide my transaction data when filing a claim online?

There are two different options when filling out the online claim form, you can either (a) manually enter all transaction information; or if you have over 25 transactions you can, (b) upload a CSV file containing your transaction information.

Please note that with both options below; dividend reinvestments should be listed as purchases.

Option A: I WOULD LIKE TO ENTER MY TRANSACTION INFORMATION USING THE ONLINE CLAIM FORM

This option will allow you to enter all your transactions directly into the form and your data will be formatted for processing. The form will also assist you in making sure your beginning holdings, purchases/acquisitions, sales, and ending holdings all balance, which will assist the administrator in processing your claim.

Option B: I HAVE MORE THAN 25 TRANSACTIONS AND I WOULD LIKE TO UPLOAD MY TRANSACTION INFORMATION AS A CSV FILE

If you have a large number of transactions (greater than 25) and you can obtain your transaction information from your financial institution in CSV (comma separated values) format, you can upload it directly to us. You will still need to provide your documentation as proof at a later step in the process.

The CSV should include your beginning holdings, purchases/acquisitions, sales and ending holdings information. The purchases/acquisitions and sales transactions should include the trade date, number of shares, price per share and total amount/cost (excluding commissions, taxes and fees).

If you have online access to your brokerage account; in order to obtain this data you will need to log into your financial institution website and look for the option to export your transaction data for Silver Wheaton common stock between the dates of March 29, 2011 and July 6, 2015. If you need assistance acquiring this data, you should contact your financial institution directly. Our office will unable to assist you in getting this information as we do not have any access to your account information or your financial institution.

If the file from your broker opens as a spreadsheet but is not a CSV file, you will need to open the file in your spreadsheet editor (ie. Microsoft Excel) and “Save As” a .csv (referred to as command delimited or comma separated values) file.

If you have your transaction data in another format and would like to create your own CSV formatted file, below is the information required to create that file:
The header row of the file should be:
TYPE, DATE,SHARES,PRICE,COST
(All numerical data should NOT contain commas; ie. 1,000 should be entered as 1000)

Here are the definitions for each of the columns:
TYPE = BH beginning holdings, P for purchases, S for sales, and EH for ending holdings.
DATE = The trade date of the transaction, this can be left blank for the types BH and EH
SHARES = The number of shares held, purchased or sold
PRICE = The price per share, this can be left blank for types BH and EH
COST = The total cost (excluding commissions, taxes, and fees), this can be left blank for the types BH and EH

Example Data:
TYPE,DATE,SHARES,PRICE,COST
BH,03/29/2011,1000,,
P,04/04/2012,500,30.96,15480.00
P,11/20/2012,100,35.00,3500.00
S,11/20/2012,1500,37.00,55500.00
EH,07/06/2015,100,,

Categories: