Студопедия
Случайная страница | ТОМ-1 | ТОМ-2 | ТОМ-3
АвтомобилиАстрономияБиологияГеографияДом и садДругие языкиДругоеИнформатика
ИсторияКультураЛитератураЛогикаМатематикаМедицинаМеталлургияМеханика
ОбразованиеОхрана трудаПедагогикаПолитикаПравоПсихологияРелигияРиторика
СоциологияСпортСтроительствоТехнологияТуризмФизикаФилософияФинансы
ХимияЧерчениеЭкологияЭкономикаЭлектроника

Part I. Using the option add trendline

Читайте также:
  1. A clutch centre holding tool can easily be made using two strips of steel bent over at the ends and bolted together in the middle
  2. A few common expressions are enough for most telephone conversations. Practice these telephone expressions by completing the following dialogues using the words listed below.
  3. A. Rewrite the sentences without using the underlined words. Keep the meaning the same.
  4. Act as Sally. Answer the questions using the conversational formulas trained.
  5. Agree or disagree with the statements using the following
  6. Answer the questions using the information from the text.
  7. B Turn the engine clockwise using a 14 mm socket on the alternator bolt

LABORATORY WORK № 5

Quantitative Risk Analysis

PART I. USING THE OPTION ADD TRENDLINE

There are two types of stocks.

For each of them is known Adjusted close price. It is required to choose the variant of investments to provide the best combination of expected yield and degree of risk.

 

For doing the laboratory work we need to:

1. For each of the types of stocks calculate net return over month Rt and gross return over month (1+Rt)

2. Calculate unbiased point estimators of the net return over month Rt:

¨ the expected value(mean);

¨ Variance;

¨ Standard deviation;

¨ Coefficient of variation.

3. Calculate semi-characteristics:

¨ Semi-Variance;

¨ Semi-Standard Deviation;

¨ Semi-Coefficient of Variation.

4. By comparing the calculated indicators for two types of stocks, choose which of them provide the best combination of expected profit and degree of risk.

 

1. Sequentially get the original data (Historical Prices) about two stocks from the site Finance.yahoo.com. For this:

- specify the first letters of any company's ticker and choose some of them (for example, try start to enter the first letters of your surname);

- receive the historical data on returns (the section on historical prices in left-hand side of the page);

- set Date Range (not less than over 12 years);

- specify, that you want to work with monthly data and Get Prices;

- Download this data to Spreadsheet (bottom Download to Spreadsheet) and save it as a Microsoft Excel Comma Separated Values File (.csv);

- create new blank Workbook;

- get external data form file with your historical data (tab Data / group Get external data / icon From text);

- in the first step of the Text Import Wizard specify the value of the parameter "Start import at row" – 8;

- in the second step of the Text Import Wizard specify the value of the parameter "Delimiter" – Comma;

- in the third step of the Text Import Wizard specify the value of the parameter "Column data format" for column Date – Date;

- delete all columns except Date and Adjusted Close;

- sort the data by Date from Oldest to Newest.

2. Design original data for each stock separately as follows:

 

WEEKLY HISTORICAL PRICES BY "______________________"

Date Adjusted close price (at the end of month) Net return over month Gross return over month
t PAt Rt (1+Rt)
    -  
       
       
       
       
       
       
       

 

3. Calculate the simple returns:

· net return over month Rt:

· gross return over month 1+Rt:

 


Дата добавления: 2015-10-26; просмотров: 121 | Нарушение авторских прав


Читайте в этой же книге: Laboratory work № 1.2 | Лабораторная работа № 2 | A Simple Calculation | Defining a Function | Creating a vector or matrix | Setting the format of a single result | Playing a Previously Saved Animation | Exercise 3. To display on a screen the value of system constantpand to set the maximal format of her displaying locally. | Finding Roots | Linear/ Nonlinear System Solving Solve Blocks |
<== предыдущая страница | следующая страница ==>
Symbolic calculations.| Analyze the plots and explain the conclusion about comparative amount of expected volatility by each stock, which we can make visually.

mybiblioteka.su - 2015-2024 год. (0.006 сек.)