Question

In: Finance

Hello, I was having trouble combining two stock data sets into excel. If you could please...

Hello, I was having trouble combining two stock data sets into excel. If you could please select a random stock and S&P 500 and conduct the following

A.1) From Yahoo Finance’s Historical Data feature, download 5 years of daily data. The measures include Date, Open, High, Low, Close, Adj Close, and Volume. You should download this data for both your stock as well as for the S&P500.

A.2) Combine the data in one Excel sheet. Add a prefix to each column header (except Date) as XYZ or SP500.

A.3) In Excel, define columns that calculate the daily return of the stock, as well as S&P500, as XYZ Return and SP500 Return. The daily return should be based on the Adj Close (not the Close), since this is restated to account for stock splits and dividends.

Solutions

Expert Solution

daily return = (current price - previous day price) / previous day price


Related Solutions

hello, I'm having trouble understanding how to do these two problems could you show me a...
hello, I'm having trouble understanding how to do these two problems could you show me a step by step. 1)Eight sprinters have made it to the Olympic finals in the 100-meter race. In how many different ways can the gold, silver, and bronze medals be awarded? 2)Suppose that 34% of people own dogs. If you pick two people at random, what is the probability that they both own a dog? Give your answer as a decimal (to at least 3...
Hello! I am having trouble starting this program in Java. the objective is as follows: "...
Hello! I am having trouble starting this program in Java. the objective is as follows: " I will include a text file with this assignment. It is a text version of this assignment. Write a program that will read the file line by line, and break each line into an array of words using the tokenize method in the String class. Count how many words are in the file and print out that number. " my question is, how do...
Hello, I am having trouble getting started on my project and building these functions. How do...
Hello, I am having trouble getting started on my project and building these functions. How do I build a function that continuously adds new "slices" to the list if they are below/above the size limit? I didn't copy the entire problem, but just for reference, when the code is run it will take user input for size limit (L), time cost for a random slice(R), and time cost for an accurate slice(A). Question: In real life, a steak is a...
If anyone could simplify this for me. I'm having trouble understanding the material and I just...
If anyone could simplify this for me. I'm having trouble understanding the material and I just need a keep it simple stupid approach Discuss the various non influential as well as influential investments that company may have on their financial statements. Also compare and contrast how they are treated/recorded on the companies financial statements.
I am having trouble with the entry to adjust accumulated depreciation, can you please explain.
I am having trouble with the entry to adjust accumulated depreciation, can you please explain.
Hello, I am having difficulty with this assignment. I chose Amazon as my stock, but I...
Hello, I am having difficulty with this assignment. I chose Amazon as my stock, but I am confused on what they're asking :             Choose a stock that interests you. Utilizing Bloomberg (or other financial websites) as a source of data, collect the following      information:                         a. The stock’s Beta                         b. The rate of return on the market (S&P 500 Index)                         c. The risk-free rate (rRF)                         d. The last dividend paid (D0)...
Hello, I am having trouble with my Advanced Accounting Ch 18 homework. Accounting for nonprofts. Here...
Hello, I am having trouble with my Advanced Accounting Ch 18 homework. Accounting for nonprofts. Here are a few questions: At the beginning of the year, Nutrition Now, a health and welfare not-for-profit entity, had the following equity balances: Net assets without donor restriction $400,000 Net assets with donor restriction $290,000 1. Unrestricted contributions (pledges) of $250,000, to be collected in cash in thirty days, before the end of the year, are received. 2. Salaries of $27,000 are paid with...
Please show work! I have the answers to these parts, but I am having trouble working...
Please show work! I have the answers to these parts, but I am having trouble working through the problem to find the answer. Find the solution of the IVP: d.) 5y" - y' = 0, y(0) = -1, y'(0) = -1 (answer: y(t)=4 - 5 et/5) e.) 3y" - y = 0, y(0) = 3, y(t) is bounded for 0 <= t < infinity (answer: y = 3 exp(-(1/3)sqrt(3)t) ) g.) y" + 2y' + y = 0, y(0) =...
Im just having some trouble using functions in visual basics. Could you please explain what Im...
Im just having some trouble using functions in visual basics. Could you please explain what Im doing wrong? I think it has to do with the calling of the function. Public Class Form1     Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click         Me.Close()     End Sub     Private Function Rsumation(ByVal intx As Integer) As Double         intx = CInt(Txtinput.Text)         If intx = 1 Then             Return 1         Else Return (intx + Rsumation(intx - 1))        ...
could you please explain constructive interference and destructive interference I'm having trouble wrapping my brain around...
could you please explain constructive interference and destructive interference I'm having trouble wrapping my brain around it I'm completely lost. thank you
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT