Thread: Weekly Returns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Weekly Returns

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