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.
请加QQ:99515681 邮箱:99515681@qq.com WX:codinghelp
- 赛诺威盛:大孔径专科化CT领航者
- 网易硬刚腾讯 两大游戏玩家之间的口水仗不断
- 全球“最独特”的一台华为 nova 6 5G 版手机是什么样子的?
- 拼多多抖音淘宝京东,谁是真低价?
- 老杨第一次再度抓握住一瓶水,他由此产生了新的憧憬
- 丰田章男称未来依然需要内燃机 已经启动电动机新项目
- B站更新决策机构名单:共有 29 名掌权管理者,包括陈睿、徐逸、李旎、樊欣等人
- 苹果罕见大降价,华为的压力给到了?
- 三明列东又有房子要拆迁!住这里的人要发了!
- 放大招后,广州又忍不住了…
- 私募积极加仓,百亿股票私募仓位指数创出近八周新高
- 他,传闻中马云最想见的人
- 升级的脉脉,正在以招聘业务铺开商业化版图
- 如何经营一家好企业,需要具备什么要素特点
- 智慧驱动 共创未来| 东芝硬盘创新数据存储技术