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

  Describe the assumptions used to make the estimates

Describe the assumptions used to make these estimates. Include an overview of the budget in the report, presenting the actual budget as an appendix with all data and calculations.

  The merger will result in incremental free cash flows

Volunteer Pizza, a regional pizza chain, is considering purchasing a smaller chain, Eastern Pizza, which is currently financed with 20 percent debt at a cost of 8%. Volunteer's analysts project that the merger will result in incremental free ca..

  What debt-equity ratio is needed for the firm

Phil's Carvings, Inc. wants to have a weighted average cost of capital of 9.2 percent. The firm has an aftertax cost of debt of 6.4 percent and a cost of equity of 12.8 percent. What debt-equity ratio is needed for the firm to achieve their target..

  Explain capital budgeting involves calculation of modified

Explain Capital budgeting involves calculation of modified internal rate of return and What is the project's modified internal rate of return

  Stock valuation suppose toyota has nonmaturing perpetual

stock valuation suppose toyota has nonmaturing perpetual preferred stock outstanding that pays a 1.00 quarterly

  What is the npv for each project

The Allied Group is considering two investments. The first investment involves a packaging machine, which can be used to package garments for shipping orders to customers. The second possible investment would be a molding machine that would be use..

  How many shares need to be sold

If the offer price is $45 per share and the company's underwriters charge an 8.25 percent spread, how many shares need to be sold?

  What standards must big city meet regarding the water

Who can be held liable for the cost of cleaning up the site and why? What standards must Big City meet regarding the Water?

  Calculate stock turnover ratio from the

calculate stock turnover ratio from the followingnbsprscost of goods sold600000opening stock100000closing

  Compute the market debt to equity ratio

Compute the market Debt to Equity ratio

  What are the direct quote and indirect quote of us dollar

What are the direct quote and indirect quote of the U.S. dollar versus a currency of your choosing. Relative to this currency, did the U.S. dollar appreciate or depreciate since the beginning of the year (YTD stands for Year to Date)?

  Determine the net receivables

Geisel, Inc. reported net sales revenue of $517,000 in 2015 and $620,000 in 2016. The company's average net receivables were 121,000 during 2014 and $134,000 during 2015. At December 31, 2016, the company had Accounts Receivable of $149,000.

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