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

  Consider a bond with par value of eur 1000 and maturity in

consider a bond with par value of eur 1000 and maturity in three years and that pays a coupon of 5 annually. the spot

  Wat price must japanese motors charge for the same model

japanese motors exports cars and trucks to the u.s. market. on november 15 2001 its most popular model was selling

  What is the mrp

Although no liquidity premium is associated with Treasury securities, there is a maturity risk premium (MRP) for Treasuries with maturities equal to one year or greater. What is the MRP?

  The entertainment system vendor has offered to finance the

the adam limousine company wants to purchase a car entertainment system for one of its automobiles. the entertainment

  Calculate how liquid a firm is and whether it can pay bills

Execute an investigation into whether the firm's managers are generating adequate operating profits on the company's assets. Calculate how liquid a firm is and whether it can pay its bills

  What is the expected annualized yield on the bonds

What is the expected annualized yield on the bonds over the next year, assuming they are to be sold in one year?

  Evaluate the positioning of each brand

Pick a category basically dominated by two main brands.- Evaluate the positioning of each brand. Who are their target markets?

  The most appropriate discount rate to use when applying a

1. the most appropriate discount rate to use when applying a fcfe valuation model is the .required rate of return on

  Identify the section of the constitution or its amendment

review the constitution in appendix a and choose one of the following sections of the u.s. constitution or a specified

  Prepare the general journal entries

Posting Journal entries into a worksheet - Prepare the general journal entries or enter into a worksheet the adjustments necessary at the end of February

  Designing value-based service

As the rate of innovation increases, companies face expanding product/service lines, shorter product and service lifecycles, and more frequent product/service transitions. All of these can bring tremendous value but also pose enormous challenges a..

  Three steps process for estimating a firms wacc

Three steps process for estimating a firms WACC

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