Use Yahoo Finance to download one year’s worth of weekly prices for the following two stocks: Tesla (ticker: TSLA) and Alphabet Inc. (ticker: GOOG).

by | Jul 12, 2021 | Uncategorized | 0 comments

I ALREADY GOT THE ANSWERS BUT DO NOT KNOW HOW TO ENTER IT IN EXCEL. PLEASE DO IT IN ExCEL AND IF ANY MISTAKES NOTED PLEASE FIX THANK YOU. I HAVE ATTACHED THE LECTURE LINK AS WELL.

ASSIGNMENT
1) Use Yahoo Finance to download one year’s worth of weekly prices for the following two stocks: Tesla (ticker: TSLA) and Alphabet Inc. (ticker: GOOG). Be careful to sort the data depending on how you want the data to be displayed. Use the dates: 6/1/2020 through 5/31/2021.
Based on the adjusted closing prices, calculate each stock’s: weekly mean return (continuously compounded), and weekly standard deviation (for a sample). Then annualize the return and standard deviation.
Next, calculate the weekly covariance and annualize it. Also solve for the correlation between the two stocks.
What return (for each of the two stocks) is the cutoff for which 10% of the returns lie above it? (HINT: I’m looking for you to use the PERCENTILE function).
2) Use the LINEST function to describe the relationship between these two stocks. Treat TSLA as the Y variable and GOOG as the X variable. If GOOG stock rises by 5%, what can we expect TSLA’s stock return to be? How reliable do you think this result is?
3) Use VLOOKUP to find both stock’s prices for any day that falls within the week of your birthday (2/14 -Feb 14)

Our Guarantees

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university, or professional, and we will assign a writer who has a respective degree.

 

Professional certified writers

We have hired a team of professionals who provide expert academic help. Most of them are native speakers and PhD holders who are able to take care of any assignment you need help with.

 

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support team.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all sources and in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24/7 and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

 

About us

We are a team of like-minded people who established Wileyscholars.com to help students all over the world. It all began a few years ago when we, as students, helped each other complete our own assignments. Shortly after, we discovered that other students need help too: that is when Wileyscholars was created. It is an online service that provides help with academic assignments all over the world. Our main aim is to help hundreds of students pass their tests and home assignments by giving advice and helping to get to know the subject better.

 

 

Let’s Start a Conversation