Get fast, custom help from our academic experts, any time of day.
Place your order now for a similar assignment and have exceptional work written by our team of experts.
Secure 100% Original On Time Delivery
The goal of this homework is to review and apply the material learned in the past two weeks including:
Market Participants and Non-Market Participants and their roles
Evaluation
Alpha/Beta
VaR
Sharpe Ratio
Instructions
Please use the following use the following template to complete the homework assignment: FIN 542 – Homework #2
When completing the homework please consider the following:
Show all your work and supporting steps in calculations
Use complete sentences and proper grammar when responding to qualitative questions
For quantitative questions, please highlight the final answer(s)
Include all relevant workbooks or files used to complete the homework
Please try to do this digitally, it is sometimes difficult to read handwriting
Submit either word, pdf, or excel files (when applicable), please no photographed work
The two attached excel files will be essential in completing the homework. You will use these files similarly to how we demonstrated in many of the calculations demonstrated in the learning materials using excel.
EWJ.xlsxDownload EWJ.xlsx
Eurekahedge Japan Index (EHFI 68).xlsxDownload Eurekahedge Japan Index (EHFI 68).xlsx
When working with excel and data in general, just some helpful hints and things to be cognizant of:
Be mindful if the dataset is being presented in chronological vs reverse chronological order
When comparing datasets, be mindful of the time range for each data set. Shorter data sets will the limiter of comparison; you can\’t compare one data set period to another which has no data
Yahoo data is weird. For monthly data, they may have a date 12/1/1999. This date actually implies data for the end of November 1999, or 11/30/1999\’s data point
Decimal and % are not the same in presentation for excel. If you see 25.31 it does not mean the same as 23.51% (that is unfortunately .2351). Be careful here as this can yield wildly different results
Be mindful of empty or missing data and removing them from the calculations
Get fast, custom help from our academic experts, any time of day.
Secure 100% Original On Time No AI Content
