start date
12/31/2018
11/30/2018
10/31/2018 L
9/28/2018
8/31/2018
7/31/2018
6/29/2018
5/31/2018
4/30/2018
3/30/2018
2/28/2018
1/31/2018 H
last price
0.14538
0.1437
0.14335
0.14558
0.14638
0.14682
0.151
0.156
0.15788
0.15896
0.15795
0.15902
start date
12/30/2016 L
11/30/2016
10/31/2016
9/30/2016
8/31/2016
7/29/2016
6/30/2016
5/31/2016
4/29/2016
3/31/2016 H
2/29/2016
last price
0.14388
0.14498
0.14779
0.15006
0.14975
0.15064
0.15057
0.15192
0.1544
0.15506
0.15258
Bloomberg Assignment #1
Please type all responses in a Word document. You need to attach Excel worksheets for Part
#1. Remember to type your name within the document.
1. Find the month-end exchange rates between RMB and US$ from Bloomberg and
fill in the blanks in the following table.
a. For the year 2016:
Date
Jan-16
Feb-16
Mar-16
Apr-16
May-16
Jun-16
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
%
US$ per
Change
RMB
b. For the year 2018:
Date
%
US$ per
Change
RMB
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
2?(a) Then, compute the percentage change of the exchange rates.
(b) Then, compute the standard deviation of the percent changes for each of the two
periods.
(c) Which period is more volatile?
(d) What political, economic or financial factors made one period more volatile than the
other period?
Purchase answer to see full
attachment
Recent Comments