Question: How can I use Excel 's Averageif function , to compute the percentage average return of two days on stock returns ? Note it has

How can I use Excel 's Averageif function , to compute the percentage average return of two days on stock returns ?

Note it has to this function .

Say on day 1 , clcosing price is 1600.89

And on day 2 , closing price 1608.88

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable. We are given the information that...

Q:

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable. Please show how to do this in excel and...

Q:

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable. Please show excel formulas. We are given...

Q:

Backtesting In Lecture 5, we saw that the risk parity strategy would have performed very favorably in allocating funds across major asset classes, including bonds, stocks and commodities over the...

Q:

Stage 4: Developing Combined-Asset Portfolios You are going to develop two multi-asset portfolios from the stocks you chose. Place the information for these steps in the Portfolios worksheet. Step 1)...

Q:

1- As a store manger you would like to find out the average time it takes to unload the truck which delivers the merchandise for your store. For this purpose, you have taken a random sample of 35...

Q:

AutoSave OFF G Sv e : W YOExcel16Ch05PS1v2_Instructions - Saved to my Mac Q Search in Document Home Insert Draw Design Layout References Mailings Review View v Evv All Share ARBBCDE aabbccdde,...

Q:

PART 2: - OPTIMAL PORTFOLIO CONSTRUCTION: (9 marks) In its simplest form, portfolio theory is about finding the balance between maximizing your return and minimizing your risk. The objective is to...

Q:

I need help completing this project. i am only required to complete just one major firm in the us for the portfolio. The instructions for the project is below 1.Identify the three or four major firms...

Q:

In this project, you will find and discern the appropriate data to determine a realistic assessment of the weighted average cost of capital for a firm of your choosing. You will need to search for...

Q:

Free Cash Flow You are considering an investment in Crew Cut, Inc. and want to evaluate the firm's free cash flow. From the income statement, you see that Crew Cut earned an EBIT of $23.17 million,...

Q:

Slim Pavarotti set up a small company to operate the 'Messa Dornum' restaurant from September 2018 Although a demon with the pasta sauces, Slim is inexperienced in business management and profit...

Q:

you have just taken out a five - year loan from a bank to buy an engagement ring. the ring costs $ 6 2 0 0 . show the timeline of the loan from your perspective

Q:

Exponential smoothing with an alpha of one will yield identical results to which other type of forecast? Delphi method forecast Last period (naive) forecast. 3-week moving average forecast Perfect...

Q:

6. List one and only one societal role that you wish you had performed better in. Spend the next month on a small push to improve your personal performance within this role. At the end of the month,...

Q:

9. Imagine that you have achieved the goal you set for yourself in task 8. a. What do you see in the past? b. How do you feel? c. What do you hear? d. How does this change your roles? e. How does...

Q:

8. Set a goal that you really want to achieve in the near future, lets say 12 years. How does this goal fit in relation to the form roles and values above? What role and what value was it that...