FIN 3080代做、Python/c++语言编程代写

日期：2024-04-16 09:25

FIN 3080 Investment Analysis and Portfolio Management

Spring 2024 | CUHK (SZ)

Assignment III

Due: 23:59, April 19, 2024

Disciplines

? A delayed or incomplete submission before the suggested solution is released will result in a deduction

of few points. No submission or submission after the suggested solution is released will result in a

deduction of all points.

? A complete submission must include two files: (i) a typed PDF file (1.5-spaced, 11pt, no longer than

5 pages) including your arguments, tables and figures in English (excluding your codes), and (ii) a

compressed package named “YourID_YourName” containing one or multiple code files that generate

the empirical results in your PDF file.

? You may discuss with your peers but plagiarism and fabrication are strictly prohibited and will be

directly reported to the Registry Office.

? You may choose any programming languages to finish the assignment. Excel is not considered as a

programming language.

Problems

1. Please download daily Closing Index for the CSI 300 index from China Stock Market Series/Stock

Trading/Market Index table over 2004/1/1 to 2023/12/31, and finish the following tasks.

(a) Manually derive monthly CSI 300 index returns and provide summary statistics on mean, standard deviation, skewness and kurtosis for monthly CSI 300 index returns.

(b) Plot a histogram for CSI 300 monthly returns.

(c) Discuss whether returns of the CSI 300 index follow a normal distribution.

2. Since Jensen, Black, and Scholes (1972, hereafter BJS) , there have been many attempts to empirically

test the relation between asset risks and expected returns. Chen et al. (2019) conduct a simplified

version of BJS’s test on the Chinese market. Please carefully read through Chen et al. (2019) and

finish the following tasks.

(a) Download weekly Returns Without Cash Dividend Reinvested for all A-share mainboard stocks

from China Stock Market Series/Stock Trading/Individual Stock Trading table from the first week

of 2017 to the last week of 2022.

1

(b) Calculate weekly market returns as the mean value of weekly returns of all mainboard stocks .

(c) Load weekly risk-free return data from “weekly_risk_free_rate.xlsx” or “weekly_risk_free_rate.dta”.

(d) Follow section 4 in Chen et al. (2019) to replicate Table 2 and 3 with data obtained from (a) - (c).

In other words, you reproduce two tables with the original methology yet with different data.

Hints

1. When the number of observations of requested data is very large, CSMAR may split your data into

mutiple files. Do remember to concatenate all raw data files.

2. Denoted by Rk,t

the returns for index k at time t. You may calculate Rk,t as follows:

Rk,t =

Ik,t

Ik,t?1

? 1,

where Ik,t

is the closing index for k at t. In other words, you do not have to worry about issues like

dividends or changes in tradable shares when calculationg index returns.

3. The file “weekly_risk_free_rate” contains weeklized returns of 1-year government bonds sourced

from CBIRC. You can directly use “risk_free_return” therein as weekly risk-free returns.

4. You may find the combination of bysort and asreg in Stata helpful to run regressions by group and

store coefficients as new columns correspondingly.

5. In an empirical replication, you do not necessarily have to generate exactly the same coefficients or

t-statistics (nor is it possible) but you should follow the original design and find comparable results or

slightly different results with solid justifications.

References

Chen, Yifan et al. (2019). “Empirical test of CAPM in Shanghai securities market”. In: Finance 9, pp. 28–33.

Jensen, Michael C, Fischer Black, and Myron S Scholes (1972). “The capital asset pricing model: Some

empirical tests”. In: Studies in the Theory of Capital Markets.

2