Write a program which analyzes the Amsterdam stock exchange market situation on 18th January
The program has to read data from 3 files: the AEX composition AEX.txt, the share values from 17 january, AEX-17jan.txt and the share values from 18 january, AEX-18jan.txt.
1. The program has to calculate the AEX index for 18th January, indicating its relative change compared with 17 January (for example AEX= 351 +0.37 %)
2. The program has to write for each company the absolute and relative change of its shares price.
3. The program has to determine the top riser and the top faller company (Highest riser, highest faller in relative difference).
Assignment 2.
The Amsterdam Exchanges Index (AEX) is a weighted index based on the prices of shares in 24 leading Dutch companies. AEX index is calculated as the value in euros of a basket with shares from the 24 participating companies. Each company fund participates in the stock exchange with a certain volume of shares. This volume determines with how many shares each company participates in the basket (the relative weight of the company in AEX index).
The compositions of the AEX index and the relative weights for the participating companies are fixed each year. As for May 2008 the AEX index has the following composition (AEX composition) showing the company fund and the number of shares participating in the AEX basket:
ABN AMRO: 198.00
Aegon: 205.00
Ahold: 210.00
Akzo Nobel: 38.00
ASML : 68.00
Buhrmann: 18.00
DSM: 13.00
Fortis: 175.00
Getronics: 69.00
Hagemeyer: 67.00
Heineken: 33.75
IHC Caland: 4.50
ING: 181.00
Koninklijke Olie : 90.00
KPN: 339.00
Numico: 23.00
Philips: 148.00
TPG: 49.00
Unilever: 61.00
Van der Moolen: 5.00
Versatel: 60.00
VNU: 34.00
Wolters Kluwer: 39.00
Table 1. The AEX index composition (file AEX.txt)
The share price for each fund fluctuates during the day according to the stock transactions, but the closing share price at the end of each trading day are published in the media.
For example Table 2 and Table 3 show extracts from the newspapers from 17 and 18 of January 2009 with the share closing values (in euro) for the AEX participating funds.
The AEX index is also recalculated every 15 seconds, but the last calculated value of the day is also quoted in the media (www.euronext.nl). In this period the AEX is around 350.
ABN AMRO: 20.11
Aegon: 10.22
Ahold: 6.35
Akzo Nobel: 32.06
ASML : 11.71
Buhrmann: 7.84
DSM: 47.58
Fortis: 21.15
Getronics: 1.66
Hagemeyer: 1.93
Heineken: 24.82
IHC Caland: 49.01
ING: 22.05
Koninklijke Olie: 42.63
KPN: 7.24
Numico: 27.04
Philips: 18.66
TPG: 19.67
Unilever: 49.50
Van der Moolen: 5.31
Versatel: 1.94
VNU: 22.93
Wolters Kluwer: 13.98
Table 2. The closing share prices for AEX funds (Het Parool-Aandelen AEX-index, 17 january 2009) (file AEX-17jan.txt)
ABN AMRO: 20.27
Aegon: 10.28
Ahold: 6.37
Akzo Nobel: 32.03
ASML : 11.86
Buhrmann: 7.93
DSM: 47.72
Fortis: 21.16
Getronics: 1.68
Hagemeyer: 1.93
Heineken: 24.61
IHC Caland: 49.77
ING: 22.07
Koninklijke Olie: 42.68
KPN: 7.30
Numico: 26.91
Philips: 19.06
TPG: 19.69
Unilever: 49.19
Van der Moolen: 5.27
Versatel: 1.92
VNU: 22.69
Wolters Kluwer: 13.90
Table 3. The closing share prices for AEX funds ( Het Parool-Aandelen AEX-index, 18 january 2009) (file AEX-18jan.txt)
Write a program which analyzes the Amsterdam stock exchange market situation on 18th January
The program has to read data from 3 files: the AEX composition AEX.txt, the share values from 17 january, AEX-17jan.txt and the share values from 18 january, AEX-18jan.txt.
1. The program has to calculate the AEX index for 18th January, indicating its relative change compared with 17 January (for example AEX= 351 +0.37 %)
2. The program has to write for each company the absolute and relative change of its shares price.
3. The program has to determine the top riser and the top faller company (Highest riser, highest faller in relative difference).
Notes on implementation: You should divide your program in subparts such as: obtaining input data, calculating and printing output data. Each small subtask should be implemented using functions.
Steps to calculate the AEX index:
1. Multiply for each company fund the share closing price (in euros) with the number of shares in the AEX basket. For example: ABN-AMRO 20.11 x
198.00
2. Add all the 24 products.
3. Divide the result by 100. This is the AEX index.