| Excel Add-in > Performance Table |
You can analyze daily, weekly, monthly, 3-month, 12-month, and year to date price changes of the securities.
It is also possible to display the data in terms of different currencies, dates, and relative securities.
Performance Table Designer:
You can use this window from left to right as a wizard. Once you completed your selections in the Designer, you can view detailed list on the form.
Security/Group Selection: There are two options on the top left of designer. By selecting “Security” option on the top left of the designer, you can pick one security or more to analyze. If you choose “Group” option, you can analyze any group of securities such as an index, sector or MyList.
Date Selection: You can pick dates you are interested in.
Relative Security: Indicates the comparison security.
Currency: You can view the list in any currency. Default currency is the one you selected in the options. You can change the default currency on the SG icon>Options>Currency window.
Once you have made your selections and click the “OK” button, your final table will be created on Excel.