| Title |
Finance #2 (portfolios)
Development of a prototype software system for an Indepent Financial
Adviser (IFA). The system downloaded fund information from the internet
and stored it in their Client / Portfolio Management System.
|
| |
|
| Previous System / Environment |
IFA Client / Portfolio Management System
- Our client had a software package for managing information relating
to their clients (contact details, portfolio fund names and values).
- The software package calculated the value of each portfolio in the
system if the current value of the underlying funds had been entered.
|
| |
|
| Requirements |
- To provide a process for retrieving fund information from the internet.
- To provide a process for automatically updating their Client / Porfolio
Management System.
|
| |
|
| New System Diagram |
 |
| |
|
| Technologies / Components
Used |
- Software: Java programming language
– core packages, JFC / Swing, XML (DOM / XSLT), java.net, javax.crypto,
JNI, Java Help
- Software: C++ programming language
- Software: C programming language
- Software: Microsoft Access Database
- Hardware / Operating System: PC, Microsoft
Windows 2000 Professional
|
| |
|
| Implementation Summary |
Project details
- We analysed the database schema of the Client / Portfolio Management
System.
- We developed "data provider" components to retrieve fund
information from different internet web sites.
- We reformatted all downloaded data to have the same format.
- We created a data loader to store the downloaded data into a fund
administration database.
- We created a "mapping" component to associate fund names
in the Client / Portfolio Management System to fund names in the downloaded
data.
- We created an "update" component to copy the latest fund
values from the fund administration database into the Client / Portfolio
Management System.
|
| |
|
| Post Installation Notes |
None. |
