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.

Expert Solution

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

jeff jeffy answered 1 year ago

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.

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...

I have having trouble with data table 4 and i would like someone to double check...

I have having trouble with data table 4 and i would like someone to double check my work on the other tables. NaHCO3(s) + HC2H3O2(aq) → C2H3O2Na(aq) +H2CO3(aq) H2CO3(aq)→ H2O(l) +CO2(g) Note: 5 mL of 5% vinegar contains 0.25 mL of HC2H3O2 with a density of 1.0 g/mL which equals 0.25 g HC2H3O2. Data Table 4 Limiting Reactant Theoretical yield of CO2(moles) Theoretical yield of CO2(g) Reaction 1 NaHCO2 Reaction 2 NaHCO2 Reaction 3 HC2H3O2 Reaction 4 HC2H3O2 Data...

Hey. I am having trouble with a finance question: ----------------------------------------------------------------------------------------------------------------------------------------- Consider two bonds. The first is...

Hey. I am having trouble with a finance question: ----------------------------------------------------------------------------------------------------------------------------------------- Consider two bonds. The first is a 6% coupon bond with six years to maturity, and a yield to maturity of 4.5% annual rate, compounded semi-annually. The second bond is a 2% coupon bond with six years to maturity and a yield to maturity of 5.0%, annual rate, compounded semi-annually. Given the data for the first two bonds, now consider a third bond: a zero coupon bond with six years...

I was able to calculate (a) but I am having trouble with the calculations of (b)....

I was able to calculate (a) but I am having trouble with the calculations of (b). Thanks! The following are New York closing rates for A$/US$ and $/£: A$/$ = 1.5150; $/£ = $1.2950 (a) Calculate the cross rate for £ in terms of A$ (A$/£). (b) If £ is trading at A$1.95/£ in London (cross market) on the same day, is there an arbitrage opportunity? If so, show how arbitrageurs with £ could profit from this opportunity and calculate the arbitrage...

Question