Volatility Calculation

Volatility Calculation

Professional Development

15 Qs

quiz-placeholder

Similar activities

Diwali Quiz 2

Diwali Quiz 2

Professional Development

20 Qs

Slope and Slope intercept

Slope and Slope intercept

KG - Professional Development

20 Qs

Options and Greeks

Options and Greeks

Professional Development

15 Qs

Form 2 - 6.4. Volume of Three-Dimensional Shapes

Form 2 - 6.4. Volume of Three-Dimensional Shapes

Professional Development

20 Qs

Graphing Reciprocal Functions Quiz

Graphing Reciprocal Functions Quiz

Professional Development

10 Qs

Correlation and Simple Linear Regression

Correlation and Simple Linear Regression

University - Professional Development

15 Qs

Q2M10 - PETA II - Easy Round

Q2M10 - PETA II - Easy Round

Professional Development

10 Qs

Week 5 Revision Quiz

Week 5 Revision Quiz

Professional Development

10 Qs

Volatility Calculation

Volatility Calculation

Assessment

Quiz

Mathematics

Professional Development

Medium

Created by

kanhu bhuyan

Used 1+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the first step to calculate volatility using Excel?

Calculate the average

Calculate the deviation

Calculate the square root of variance

Download the historical closing prices

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function in Excel is used to calculate the standard deviation of daily returns?

AVERAGE

SUM

STDEV

LN

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the approximate equation to calculate daily returns?

Return = (Ending Price / Beginning Price) - 1

Return = LN (Ending Price / Beginning Price)

Return = SQRT (Ending Price / Beginning Price)

Return = (Ending Price - Beginning Price) / Beginning Price

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you download historical closing prices from NSE India website?

Click on historical data and select the search option

Click on download file in CSV format

Fill in the required details and hit 'Get Data'

All of the above

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of calculating standard deviation manually in the previous chapter?

To show the mechanics behind the calculation

To demonstrate the use of Excel functions

To compare with NSE's calculation

To calculate annual volatility

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the daily volatility of WIPRO calculated using Excel?

0.0147%

1.47%

23.33%

25.5%

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you calculate the daily log returns of WIPRO in Excel?

Use the function SQRT

Use the function SUM

Use the function LN

Use the function AVERAGE

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?