Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Take monthly data of any 1 stocks from september 2018 to september 2019. calculate their rolling 12 month returns by taking an average of the

Take monthly data of any 1 stocks from september 2018 to september 2019.

calculate their rolling 12 month returns by taking an average of the previous 12 monthly returns and multiplying that average by 12.

Calculate these rolling average annualised returns for 24 months from November 2020 to October 2022, inclusively Show this in Excel.

please share the complete excel calculation of procedure

this is related to ETFs

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Technical Analysis Of Stock Trends

Authors: Robert D. Edwards, John Magee, W.H.C. Bassetti

10th Edition

1439898189, 978-1439898185

More Books

Students also viewed these Finance questions

Question

How did the authors avoid the post hoc fallacy?

Answered: 1 week ago

Question

Is this public actively seeking information on this issue?

Answered: 1 week ago

Question

How much loyalty does this public have for your organization?

Answered: 1 week ago

Question

How influential does the organization see this public as being?

Answered: 1 week ago