1. Write a brief summary in WORD.
2. Make an EXCEL spreadsheet supporting your summary.
USE YAHOO FINANCE TO GET THE DATA.
[url removed, login to view] daily adjusted close price for the following two ETFs:
from Jan 1 2004 to today. Make sure the dates from both tickers are aligned.
2. Create daily simle returns for both tickers. Note first "flip" the data that old data appear first and new date at the end.
3. Calculate mean and standard deviation of daily returns for both tickers using average() and stdev() functions.
4. Create two new columns of data, converting daily returns of SPY and EEM into their respective z-score. (note z-score = (return - mean_ret) / stdev(return).)
5. Using excel percentile() function, to calculate the return corresponds to 1% to 99% percentiles, with 1% increment, for both tickers.
6. Graph both percentile returns in the same chart. Note the horizon axis is 1% to 99%. The vertical axis is the percentile returns for SPY and EEM.
7. Using excel percentile() function, to calculate the z-score corresponds to 1% to 99% percentiles, with 1% increment, for both tickers.
8. Graph both percentile z-scores in the same chart. Note the horizon axis is 1% to 99%. The vertical axis is the percentile z-score for SPY and EEM.
Dear employer I am top 2 freelancer in Finance skill, Accounting skill. I always deliver good service with low price. I have done many task like this. Let me help you complete this task. I am an ACCA member with 5 Plus
11 freelance font une offre moyenne de $33 pour ce travail
"Thanks for looking our proposal!! I understood your requirement. Among all freelancer we are one of best right person for this project. **Check our reviews to confirm our work quality(100%completion rate) ***From las Plus
Hi there, I'm experienced in Financial Analysis, Accounting and Economics, Project Management and Academic writing. Ready to complete your projects: 1) Writing Business Reports - Business Plan, Investment Memorandum, F Plus
I have experience in these tasks. I have already completed a few. I can do it quickly and accurately.
It is my fist offer That I submit and I will try to do good job as well as i try to build a reputation,
Hi, Greetings! I am a qualified financial modelling consultant and have been practising for the past two years. I can help you with the required analysis along with the documentation supporting the analysis in additi Plus
Dear Employer, I have understood your requirements and I am eager to work on this project. I have completed Master of Business Administration (MBA) with specialization in Finance from a reputed and AACSB accredited Plus