首页
网站开发
桌面应用
管理软件
微信开发
App开发
嵌入式软件
工具软件
数据采集与分析
其他
首页
>
> 详细
代写 data 编程、代做 Python 语言程序
项目预算:
开发周期:
发布时间:
要求地区:
DATA ANALYTICS & VISUALIZATION FOR FINANCE 2024-2025
Mission 3 (Individual) – Tableau and Python Deadline: December 16th 2024, 23:59 (CET)
In this individual assignment, you will have the opportunity to apply both your Tableau and Python skills by working individually with a stock price/return dataset and using the techniques learned across the Tableau and Python labs. The aim is to analyze the statistics, create interesting visualizations, build portfolios and analyze their performance so that you can embrace various tasks through your data visualization and analytical skills. For that, you are required to build a daily stock price dataset made of “3 stocks” (based on the choices assigned by your course professor) and spanning from October/2014 to October/2024. You will be able to create a dataset that you will use for this mission. To complete the project, you need to work on some “tasks” (please see below) and submit your individual work, accordingly.
Read the instructions below carefully and follow them closely.
Project Objective:
Imagine that you are now a junior data analyst with a decent experience in Tableau and Python. Your company manager needs your help for a top project about understanding the stock performance of U.S companies. To conduct such an assessment, you know that (as a good data analyst) analyzing and visualizing past historical data is key. Therefore, you received the mission tasks below that you need to follow step by step. Conduct all the visual and analytical methods that are requested and complete your report.
Task 1: Using Tableau, plot prices and returns of each stock. Use different visualization tools (colors, bars, line charts, etc). Create a dashboard and show how your price and returns data look like. Interpret the patterns and regularities, accordingly, taking into account important events.
Task 2: Now, use Python for the analytical assessment of your data. Carry out the following analyses: Plot prices and returns. Compute standard deviation and maximum drawdown (as conducted in the labs) and report the results. Compare the estimates across stocks. Compute the annualized Sharpe ratios, based on
different choices of risk-free rates (e.g., 0.01, 0.03 and 0.05). Compute VaR and CVaR and interpret the findings in your report.
Task 3: In this step, your task is to assess risk and return relationships. Again, use Python to generate different efficient frontiers, using your selected stocks. First, generate the covariance and correlations matrices to display the level of relationship among your stocks. Interpret the patterns. Then, generate the “two-asset” efficient frontier by choosing two stocks among all three. Plot the two-asset efficient frontier and interpret. Next, move to “N-asset” efficient frontier and thus use all three stocks to display the efficient frontier. What do you see? Do results change? If so, how and why? If not, think about why you do not observe differences, compared to two-asset case. Interpret these findings in your report. As a final job for this task, create MSR, EW and GMV portfolios and compare them. Do they look similar? What are the key differences that you can identify visually? Interpret the curves intuitively in terms of the risk- return relationships. What can you say about diversification? Based on your analysis and visual patterns coming from the efficient frontier, how would you make a decision in terms of achieving minimum volatility (risk) and/or maximum return?
Expected Outcome:
Your assessment will be evaluated based on creativity, clarity, and the depth of analysis presented in your work, as well as the quality and efforts you put into creating the Tableu dashboard and Jupyter Notebook. More specifically, the professor will assess your final pack following the instructions above: the strength of visual elements, creativity, clarity, soundness of the explanations, consistency of the study/storytelling, and evidence of your individual efforts. Innovative approaches to the Tableau and Python outputs/visuals, and presentation are more than welcome, provided the guidelines above are respected. Please also keep in mind that this is an individual work and hence no interaction with others is permitted (thanks for respecting the rule).
Deliverables:
1. Tableau file (.twbx) including the dashboard and all the worksheets containing the visuals you
created;
2. Jupyter Notebook file (.ipynb) including all the outputs;
3. Excel file(s) containing all datasets used based on the selected stocks (which you used to import
into Tableau and Jupyter Notebook);
4. Data analyst report: Single PDF document including insights and statements on the interpretation of the results of the tasks that have been carried out in the assignment:
5. ChatGPT/generative AI statement: Statement on the use of different generative AI tools in the project development (template below). Please add the statement at the end of your data analyst report.
Submit the above elements (in a zipped folder) by email to your professor.
Deliverables that are not submitted by December 16th 23:59 (CET) will be assigned a zero mark.
Statement on the Use of Generative AI tools in Project Development:
For each generative AI tool (e.g., ChatGPT) used, provide the following statement:
“I acknowledge that I made use of (specify the generative AI tool) as an aid in the development of this project. Specifically, (specify the generative AI tool) was used for:
- (list the specific tasks for which this tool was used)
I confirm that all final content was reviewed, edited, and verified to ensure accuracy, originality, and adherence to academic standards. I took care to critically assess and modify the output from (specify the generative AI tool) to align with my assignment’s goals and my own academic output.”
Final instructions:
Here is some extra advice for the development of you individual work:
• Read the instructions above carefully.
• Any additional elements that enhance the level, quality, and clarity of the final work are very
welcome and can be taken into consideration in your final evaluation.
• The above instructions are the general requirements to follow and are also meant to give you a
certain level of freedom to work on the project. So, be creative!
• We welcome and encourage you if you have an idea for how the outputs or visuals which served
as examples in the labs could be enhanced for a richer understanding on the performance of the
stocks and portfolios.
• This project and represents 30% of your final grade on this course. Therefore, we expect a project
which reflects a final work compatible with a relevant effort.
Good luck, and we look forward to seeing your innovative and insightful work!
软件开发、广告设计客服
QQ:99515681
邮箱:99515681@qq.com
工作时间:8:00-23:00
微信:codinghelp
热点项目
更多
代做 program、代写 c++设计程...
2024-12-23
comp2012j 代写、代做 java 设...
2024-12-23
代做 data 编程、代写 python/...
2024-12-23
代做en.553.413-613 applied s...
2024-12-23
代做steady-state analvsis代做...
2024-12-23
代写photo essay of a deciduo...
2024-12-23
代写gpa analyzer调试c/c++语言
2024-12-23
代做comp 330 (fall 2024): as...
2024-12-23
代写pstat 160a fall 2024 - a...
2024-12-23
代做pstat 160a: stochastic p...
2024-12-23
代做7ssgn110 environmental d...
2024-12-23
代做compsci 4039 programming...
2024-12-23
代做lab exercise 8: dictiona...
2024-12-23
热点标签
mktg2509
csci 2600
38170
lng302
csse3010
phas3226
77938
arch1162
engn4536/engn6536
acx5903
comp151101
phl245
cse12
comp9312
stat3016/6016
phas0038
comp2140
6qqmb312
xjco3011
rest0005
ematm0051
5qqmn219
lubs5062m
eee8155
cege0100
eap033
artd1109
mat246
etc3430
ecmm462
mis102
inft6800
ddes9903
comp6521
comp9517
comp3331/9331
comp4337
comp6008
comp9414
bu.231.790.81
man00150m
csb352h
math1041
eengm4100
isys1002
08
6057cem
mktg3504
mthm036
mtrx1701
mth3241
eeee3086
cmp-7038b
cmp-7000a
ints4010
econ2151
infs5710
fins5516
fin3309
fins5510
gsoe9340
math2007
math2036
soee5010
mark3088
infs3605
elec9714
comp2271
ma214
comp2211
infs3604
600426
sit254
acct3091
bbt405
msin0116
com107/com113
mark5826
sit120
comp9021
eco2101
eeen40700
cs253
ece3114
ecmm447
chns3000
math377
itd102
comp9444
comp(2041|9044)
econ0060
econ7230
mgt001371
ecs-323
cs6250
mgdi60012
mdia2012
comm221001
comm5000
ma1008
engl642
econ241
com333
math367
mis201
nbs-7041x
meek16104
econ2003
comm1190
mbas902
comp-1027
dpst1091
comp7315
eppd1033
m06
ee3025
msci231
bb113/bbs1063
fc709
comp3425
comp9417
econ42915
cb9101
math1102e
chme0017
fc307
mkt60104
5522usst
litr1-uc6201.200
ee1102
cosc2803
math39512
omp9727
int2067/int5051
bsb151
mgt253
fc021
babs2202
mis2002s
phya21
18-213
cege0012
mdia1002
math38032
mech5125
07
cisc102
mgx3110
cs240
11175
fin3020s
eco3420
ictten622
comp9727
cpt111
de114102d
mgm320h5s
bafi1019
math21112
efim20036
mn-3503
fins5568
110.807
bcpm000028
info6030
bma0092
bcpm0054
math20212
ce335
cs365
cenv6141
ftec5580
math2010
ec3450
comm1170
ecmt1010
csci-ua.0480-003
econ12-200
ib3960
ectb60h3f
cs247—assignment
tk3163
ics3u
ib3j80
comp20008
comp9334
eppd1063
acct2343
cct109
isys1055/3412
math350-real
math2014
eec180
stat141b
econ2101
msinm014/msing014/msing014b
fit2004
comp643
bu1002
cm2030
联系我们
- QQ: 9951568
© 2021
www.rj363.com
软件定制开发网!