When advising clients on market risk, we often need to check multiple organisations for their details. However, sometimes the information is missing or incorrect. Therefore, we want a way to easily check a stock market (the NZX in New Zealand) and find out which company details are available or missing. For each company on the Main board market we gathered data on the follwing:
- Chief Executive officer
- Media contact information
- Auditor
- Solicitor
- Chief Finacial officer
- Website
- Screenshot of the website homepage
This data was then input into a Excel spreadsheet and a PDF report was created to summarise the data.
-
Download UIPath Extension for Microsoft Edge
-
Make sure all Microsoft Edge Browsers are closed
-
Set number of companies you wish to extract data from. Variable is in
Main.xaml
.MINIMUM VALUE: 2
-
In UIPath Select "Run"
-
Wait for the application to finish running. This process can take a very long time! Do not manually close anything opened untill its finished.
NOTE: If an error occurs at "Source: Add Picture" this may be due to Add-In installed on Word, such as Grammarly.
- Data extracted from NZX is stored in
NZXData.xlsx
- Report of companies can be found in
Final Report.pdf