Calculate a 3-day moving average

Assignment Help Finance Basics
Reference no: EM131453823

Assignment #1

Raw Data and Moving Averages

In this assignment you will study a particular pair of moving averages applied to historical data for the settlement prices of the futures contract being studied. You will pick a contract to study in class from a selection provided.

Collect the settlement prices from all the trading days in February 2017 through March 25, 2017from https://www.barchart.com/futures/major-commodities For example, the circled close price (a.k.a. settlement price) of CCK17 on Feb. 1, 2017 is 2112. You will need to move the cursor and point it to the stick on the chart to collect the last price for a particular business day for a time period from Feb 2017 through March 25, 2017.

CCK17means Cocoa, May, 2017. Use June (M) contract for your project.

Start a worksheet listing the dates and the settlement prices. Make sure you list the data starting with February 1 and going down to the March 25 data.

Calculate a 3-day moving average, 3-day MA, for the settlement prices in the column next to the settlement prices.

[Example: =sum(b9.b11)/3]

Note that the 3-day MA will have two missing points in the beginning. Format the averages to the same precision as the original data.

Then calculate another moving average in the column next to the 3-day MA. Use 6-day, 8-day, 10-day as you selected.The 6-day MA will have five missing points in the beginning, etc.

Note that you are not using the moving averages to make forecasts. You are using them to describe past and current data. Therefore the moving average formula in any cell should include the data for the same date next to it (not the previous date as would be done for forecasting). See the example below for what your data and moving averages should look like.

You will be adding more columns of calculated data to the right of the moving average data.

Create a line chart (without markers) on a separate worksheet which shows the settlement prices, 3-day moving average, and the specific other moving average.

When selecting the columns of data you have to include the empty cells with missing data (don't put zeros in the cells) when you specify the data series so that the plot of the moving averages is not shifted to the left. Also, copy cell contents to the end of March.

Use the Layout menu under Chart Tools to modify the chart. Don't just accept Excel's default settings and format; the defaults in Excel can be fairly crude, even awful, and make for poor presentations. Make your chart resemble the chart in the example.The same format makes comparing the charts to each other in class much easier. Use a two-line title, label the axes.Some futures contracts do not have units; they are simply an index.

Use a solid line for the settlement prices, a dashed line for the 3-day MA, and a dotted line the other MA.Right clicking on a line will allow you to format the data series. Use dashed gridlines and do not shade the plot area.

Put the legend on the bottom. Put a border around the plot area. Use major and minor tick marks. Have "Feb" and "Mar" show up on the horizontal axis scale.

In your charts emphasize the plot areas and not the titles and labels. Fill up the page with the chart. Paste as a picture, not an Excel object, into the Word document.

Create a report in Word. Include a cover sheet, the display of each dataset (without gridlines), a printout of the cell formulas(with border row and column headings and gridlines), and the chart. Use portrait for the display of data and cell formulas and landscape for the charts. The report must be presentable and effective, and deficiencies will be graded.

Drop off the report to dropbox along with the spreadsheetsthemselves.

The following images are examples using old data to demonstrate excel work you should do for your futures contract.

Attachment:- Financial Futures and Options.rar

Verified Expert

Futures contracts is the standardized contract which can be traded between the two parties in place. Japanese yen currency enable traders to buy and sell the product at the agreeable price.

Reference no: EM131453823

Questions Cloud

Calculate the new levered beta : St. Louis Brewing Co. has an unlevered beta of 1.1 , however, they want to add debt until their debt-to-equity ratio is 2.9. Calculate the new levered beta.
What is red bull success formula : What is Red Bull's success formula? For which kind of product/beverage categories will this formula work?
Modify the bscall and bsput functions : As shown in this chapter, Merton (1973) shows that for the case of an asset with price S paying a continuously compounded dividend yield k.
Analyze opportunities provided by technology for businesses : Describe the opportunities provided by technology for businesses. Apply principles of quantitative and qualitative research to business cases.
Calculate a 3-day moving average : BADM 418 - Financial Futures and Options - Spring 2017 - Calculate a 3-day moving average, 3-day MA, for the settlement prices in the column next to the settlement prices.
What should be the price of a call and a put : On 12 July 2007 call and put options to purchase and sell 10,000 euros at $1.37 per euro are traded on the Philadelphia options exchange.
What is the difference between denominator and numerator : What is the difference between denominator and numerator? Why do you need to know the difference between the two
Category of knowledge management systems : Transaction processing systems. Executive support systems. Management information systems.
Different coupon rates-different required rates of return : You are trying to price two bonds that have the same maturity and par value but different coupon rates and different required rates of return.

Reviews

inf1453823

4/24/2017 6:22:04 AM

This is an assignment of only 20 points and I am getting charged for just 20 points. The link to download the data is not friendly. I mean you can't filter the data in terms of date. Can I receive my order before the due date, please? I really don't understand what you talking about because that's the whole assignment including the attachment below. for the below futures contracts, I selected #8 (Coffee KC17). I listed several futrues contracts below that you can choose from for your futures project. First come, First served. Somebody else has already picked #8 futures contract, so I selected #4 (Dow Jones DJ17). Sorry about that, please let me know ahead of time that way I can start working on what I know. I don't have enough time.

len1453823

4/7/2017 2:33:46 AM

The following is part of the assignment: I listed several futrues contracts below that you can choose from for your futrues project. First come, First served. You will determine which pair of moving averages produced the greatest profit. The first part of the project is now available in the dropbox. 1. Eurodollar ED17 (Remington) 2. Gold GC17 3. T-Bond US17 4.Dow Jones DJ17 5. Yen JY17 6. S&P 500 SP17 (Kyle) 7. Natural Gas NG17 8. Coffee KC17 9 Crude oil WTI CL17 (Keri) 10. Mexico Peso M6 17 11. Live Cattle LE 17 (Cole) In every case, you use the or June contract (which ever is available). If both months are available for the same underlying asset, pick the June contract)

Write a Review

Finance Basics Questions & Answers

  Required return for type of bond

AF Inc. issued a bond with an annual coupon rate of 10% with interest paid annually. The bond matures in 15 years. The par value of the bond is $1,000. If your required return for this type of bond is 15%, what is the price you are willing to pay..

  Discuss how investors arrive at a desired rate of return

Briefly discuss the relationship between the formulas used to calculate (a) the after-tax yield, and (b) the taxable equivalent yield of a bond

  Summer tyme inc is considering a new 5-year expansion

summer tyme inc. is considering a new 5-year expansion project that requires an initial fixed asset investment of 1.296

  What is the external financing needed

Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year's sales are projected to be $ 5,967. What is the external financing needed?

  Computation the price of the bonds

Computation the price of the bonds N is the number of years to maturity and i is the interest rate

  How did the federal reserve rescue bear stearns

What is the debt-deflation process? Does this process provide any insight into why the Federal Reserve rescued Bear Stearns?

  What effect will this lie have on his insurance contract

What effect will this lie have on his insurance contract? What action should the insurer if the misstatement is found out after Buster dies?

  Distinguish between money and capital markets

Types of Markets Distinguish between primary and secondary markets. - Distinguish between money and capital markets.

  Peparing a statement of retained earnings clints

preparing a statement of retained earningsclints stonework corporation was organized on january 1 2011. for its first

  Explain the similarities and differences of the two budgets

Write a description of how management should use an activity based budget instead of an operating budget

  A buyer with a yearly gross income of 45000 is considering

a buyer with a yearly gross income of 45000 is considering a property with annual taxes of 1450. what is the maximum

  Earthquake endorsement-inflation guard endorsement

Briefly describe the following endorsements that can be added to a homeowners policy: a. Earthquake endorsement

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd