Here's what i needed to do. We have to follow a company for 15 weeks. Every
friday starting on Aug 21, 2009 we had to write down the closing price for
the stock that week. Based on the closing prices he wants us to calculate
the weekly return for each stock and the whole porfolio. We are also supposed
to calculate the total return for each stock and portfolio. And lastly
calculate the risk of each stock and the whole portfolio.

"Joe User" wrote:

"Robbins" wrote:
Oh ok i thought that's what it was but our book and notes
don't really explain it as easily.

Perhaps you should tell us how your book and notes explain it. There are
several ways to express periodic returns. Perhaps your instructor is
expecting you to follow the method described in your book and notes.

In particular, should weekly returns be expressed as percentage change per
week (Fred's formula), or an annualized percentage change?

Also, it is unclear what you mean by "do the weekly return ... for 15
weeks". If you will be doing some statistical analysis, especially
computing volatility, you might be interested in the log return, not the
arithmetic return (Fred's formula).


----- original message -----

"Robbins" wrote in message
...
Oh ok i thought that's what it was but our book and notes don't really
explain it as easily.

"Fred Smith" wrote:

If you bought something for $100, and one week later sold it for $110,
what's your return on investment? Hopefully, you were able to answer
instantly that it's 10%. If not, maybe finance is not for you.

It's the same with returns on a stock price. The return on investment is
always:
=(EndingValue - BeginningValue) / BeginningValue

Hopefully you can take it from here. But if you need more help, post
back.

Regards,
Fred.

"Robbins" wrote in message
...
i'm doing a project in my finance class and i need to do the weekly
return
of
the closing price of the companies stock for 15 weeks. Is there a
function
for this, and if not does anybody know how i can calculate the weekly
return

.


.