Iress Automation Example
High Dividend Yields
 |
Download the Sample (Microsoft Excel Spreadsheet) |
This example spreadsheet contains VBA code which utilises a couple of the IRESS automation objects that collectively form the IRESS API. IRESS automation code can be written in any environment that supports Microsoft COM, but an Excel spreadsheet is very convenient due to Excel's ubiquitous nature, and the fact that every copy contains the code editing and executing environment.
This sample gets all stocks in the ASX200 and then loops through this collection. For every stock it obtains the most recently announced dividend (which may already be paid, or still payable), the total yearly dividend for the previous year, and the current price.
It then updates the spreadsheet with these values, and the spreadsheet has some calculated columns, such as dividend yield. The spreadsheet can be sorted on any of the columns to illustrate high yielders, next dividends by chronological order and so on.
This small example highlights the power of IRESS automation. Instead of being written in an Excel spreadsheet, the code could be written in a .NET environment, C/C++, VB 6, or any other COM compatible environment. The data could be loaded into a database, or made available to other clients. The code could run within a stand-alone GUI based application, or in a non-interactive server application.
Virtually anything that can be done directly in the IRESS and IOS applications, can also be done via automation code. Please don't hesitate to contact us with any queries about IRESS automation.