Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the following excel file, I want to know how to get the %change of CP and %change of FP Function Library

image text in transcribed

I need help with the following excel file, I want to know how to get the %change of CP and %change of FP

image text in transcribed
Function Library Defined Nam E129 X U LL I I Cash Price Futures Price Date ACP %ACP AFP AFP Contract (cents/lb.) (cents/lb. ) N LC2020Z 2/14/2020 142.00 135.98 m LC2020Z 2/18/2020 143.00 1.00 136.83 0.85 LC2020Z 2/19/2020 143.00 0.00 135.95 -0.88 + in LC2020Z 2/20/2020 143.00 0.00 136.05 0.10 LC2020Z 2/21/2020 142.00 -1.00 135.75 -0.30 LC2020Z 2/24/2020 145.28 3.28 135.70 -0.05 8 LC2020Z 2/25/2020 145.28 0.00 136.20 0.50 9 LC2020Z 2/26/2020 145.28 0.00 136.63 0.43 10 LC2020Z 2/27/2020 150.23 4.95 136.88 0.25 11 LC2020Z 2/28/2020 151.52 1.29 136.90 0.03 12 LC2020Z 3/3/2020 151.52 0.00 137.48 0.57 13 LC2020Z 3/4/2020 151.52 0.00 139.20 1.72 14 LC2020Z 3/5/2020 151.52 0.00 138.28 -0.92 15 LC2020Z 3/6/2020 148.13 3.39 138.03 0.25 16 LC2020Z 3/7/2020 147.97 0. 16 138.65 0.63 17 LC2020Z 3/10/2020 148.34 0.37 139.03 0.38 18 LC2020Z 3/11/2020 146.00 2.34 138.50 0.53 19 LC2020Z 3/12/2020 146.00 0.00 139.10 0.60 20 LC2020Z 3/13/2020 146.00 0.00 139.03 -0.07

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Options Futures and Other Derivatives

Authors: John C. Hull

10th edition

013447208X, 978-0134472089

More Books

Students also viewed these Finance questions