En cours

Finance One

Task:

1. Write a brief summary in WORD.

2. Make an EXCEL spreadsheet supporting your summary.

Requirements:

USE YAHOO FINANCE TO GET THE DATA.

[url removed, login to view] daily adjusted close price for the following two ETFs:

a. SPY;

b. EEM,

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.

Compétences : Comptabilité, Excel, Finance, Marchés Financiers, Recherche Financière

Voir plus : yahoo-finance, make a graph chart, daily finance, end date task must completed taskrabbit, sugarcrm task start date, set windows scheduler task end date, input popup calendar start date end date disable java script, calendar booking start date end date database mysql, php mysql kalender start date end date, start date end date featured listings oscommerce, perl picker calendar start date end date, start date end date average coldfusion example, display start date end date bar javascript extjs

Concernant l'employeur :
( 11 commentaires ) utha, Guyana

N° du projet : #8540137

Décerné à :

cuongtn

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

25 $ USD en 1 jour
(163 Commentaires)
5.9

11 freelance ont fait une offre moyenne de 33 $ pour ce travail

venkatesh1312

A proposal has not yet been provided

35 $ USD en 1 jour
(17 Commentaires)
4.5
SBITServices

"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

24 $ USD en 1 jour
(28 Commentaires)
4.9
PHDThesis

A proposal has not yet been provided

24 $ USD en 1 jour
(19 Commentaires)
4.9
RafNancy

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

105 $ USD en 3 jours
(4 Commentaires)
3.9
kalchevatanas

I have experience in these tasks. I have already completed a few. I can do it quickly and accurately.

25 $ USD en 1 jour
(3 Commentaires)
1.9
zshan05

A proposal has not yet been provided

30 $ USD en 1 jour
(0 Commentaires)
0.0
klick2st

A proposal has not yet been provided

25 $ USD en 1 jour
(0 Commentaires)
0.0
petricaescu

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,

25 $ USD en 3 jours
(0 Commentaires)
0.0
SKarthika

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

25 $ USD en 2 jours
(0 Commentaires)
0.0
bsouvikb

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

20 $ USD en 3 jours
(1 Commentaire)
0.0
yassinewafaa

Aucune proposition n'a encore été fournie.

30 $ USD en 2 jours
(0 Commentaires)
0.0