Homework Answers
The match function that should be applied is
=MATCH(G2,A4:A23,0)
It will return answer = 8 because day 20 lies at the 8th row from A4(including A4).
The match function is used to get the relative position in an array for a specific lookup value.
Hence, using MATCH function in cell G3, day 20 returns the row 8
Add Answer to:
The accompanying data for the S&P 500 provides open, high low, and close values for the...
Calculate the return for June 21st based on the data below: Date Open High Low Close...
Calculate the return for June 21st based on the data below: Date Open High Low Close Dividend 20-Jun 13.2 15.4 12.8 14 21-Jun 13.3 15.3 12.2 15.2 0.6 22-Jun 14.8 17.5 14.5 16 12.86% 30.33% 18.80% 8.57%
Data File from excel Date Open High Low Close Adj Close Volume 2019-02-25 111.76 112.18 111.26...
Data File from excel
Date
Open
High
Low
Close
Adj Close
Volume
2019-02-25
111.76
112.18
111.26
111.59
110.1329
23750600
2019-02-26
111.26
113.24
111.17
112.36
110.8928
21536700
2019-02-27
111.69
112.36
110.88
112.17
110.7053
21487100
2019-02-28
112.04
112.88
111.73
112.03
110.5671
29083900
2019-03-01
112.89
113.02
111.67
112.53
111.0606
23501200
2019-03-04
113.02
113.25
110.8
112.26
110.7941
26608000
2019-03-05
112.25
112.39
111.23
111.7
110.2414
19538300
2019-03-06
111.87
112.66
111.43
111.75
110.2908
17687000
2019-03-07
111.4
111.55
109.87
110.39
108.9485
25339000
2019-03-08
109.16
110.71
108.8
110.51...
Futures Contracts Contract Open High o Low Worldoc 12000 s par 12 50 122 Domesticocs-12000 sper...
Futures Contracts Contract Open High o Low Worldoc 12000 s par 12 50 122 Domesticocs-12000 sper Open Og Hont Sttle Metal & Petroleum Futures Contract High to Low 1242 1254 1264 1235 1254 Open Og test 1263 Opm Copper Hgh (0-25000 per 23760 2975 2040 3.0240 Gold c-100 troya.Spertroyo Settle May July March May 29760 2995 0.030 29775 30 00305 150261 - 12 24 35 24 Cotton C--50000bsntspart 277 7.92 Orange Juice 0uS15000 Bsantspert 13810 135 25.05 2542 March Apr...
1) Use the following corn futures quotes: Corn 5,000 bushels Contract Month Open High Low Settle Chg Open Int...
1) Use the following corn futures quotes: Corn 5,000 bushels Contract Month Open High Low Settle Chg Open Int Mar 455.125 457.000 451.750 452.000 −2.750 597,913 May 467.000 468.000 463.000 463.250 −2.750 137,547 July 477.000 477.500 472.500 473.000 −2.000 153,164 Sep 475.000 475.500 471.750 472.250 −2.000 29,258 Suppose you buy 20 of the September corn futures contracts at the last price of the day. One month from now, the futures price of this contract is 462.75, and you close out...
TABLE 3-1 Stock Market Quote, July 22016 (1) 6) (6) Close (9) Vol Symbol Open High Low ao Low AAR Corp. Aaron's, I...
TABLE 3-1 Stock Market Quote, July 22016 (1) 6) (6) Close (9) Vol Symbol Open High Low ao Low AAR Corp. Aaron's, Inc AIR AAN 22.98 22.86 40.83 18.08 23.15 22.50 22.72 29.55 22.70 415740.80 41.36 18.39 18.05 18.22 10.45 10.16 10:20 62,85 61.7561.92 Boos Abbott Laboratories Abercrombie & Fitch ACCO Brands EI. DuPont de Nemours Eli Lilly El Paso Electric MeDonald's -0.15 -0.66 79.163 -0.14 -0.61 667,029 0.531230122196,628 0.13 0.7 1,878,642 -0.06 425,836 0.07 0.113.994,283 (1) 52 Week High...
Consider historical data showing that the average annual rate of return on the S&P 500 portfolio...
Consider historical data showing that the average annual rate of return on the S&P 500 portfolio over the past 90 years has averaged roughly 8% more than the Treasury bill return and that the S&P 500 standard deviation has been about 20% per year. Assume these values are representative of investors' expectations for future performance and that the current T-bill rate is 5%. Calculate the utility levels of each portfolio for an investor with A = 2. Assume the utility...
B с D E F G H Close Call Trading 2 Internal Audit Inspection 1111 Davidson...
B с D E F G H Close Call Trading 2 Internal Audit Inspection 1111 Davidson 3/4/17 Sales Invoices 31/3/17 Invoice No Product Unit Price Customer 4 Employee 5 Employee Name 6 Date Performed 7 8 Audit Type 9 Prepared on 10 11 Analysis 12 Sales Invoices Date Shipped 13 14 31/3/17 15 31/3/17 16 31/3/17 17 31/3/17 18 31/3/17 19 31/3/17 20 31/3/17 21 31/3/17 22 31/3/17 23 Total 24 101101 101101 101101 101 102 101102 101103 101104 101104...
Og revest Futures Contracts Metal & Petroleum Futures Contract Open Hgh to low Settle Copperh onco...
Og revest Futures Contracts Metal & Petroleum Futures Contract Open Hgh to low Settle Copperh onco 25.000s.Sperti 2700 275 297 22915 2004 20 2.072S LOS Gold D-100 ty pertroyer - U TISKO TON TON 1922 1100 15 TO WO 1150 115 17. 1150.00 DL 1100 DM UM noms-Strypto EI EGÉSes S&S ESSE Contact Open Hy belo Se Og Het Sugar-World 112000 sparta May 1242 123 1235 1294 2 993 120 22 129 J Sugar-Domesticos-us-112000 h.cosper 245 245 246 25 -...
1)The TARP program allocated $500 million to individuals who defaulted on their mortgages. provided $25 billion...
1)The TARP program allocated $500 million to individuals who defaulted on their mortgages. provided $25 billion of debt relief to citizens who owed federal taxes. provided low-interest-rate loans for students attending college. provided low-interest-rate loans for new homeowners. allocated $700 billion to keep banks from failing. Question 12 The interest rate of a bond is computed as a(n) difference. sum. absolute value. multiplication. growth rate Question 13 If the interest rate of a one-year bond is 15 percent and its...
Write a C++ program that will input data from a Comma-separated values (.csv) file and output som...
Write a C++ program that will input data from a Comma-separated
values (.csv) file and output some information about it. This
program uses a csv file from Yahoo Finance
(.csv) filename : SBUX.csv
1. Output the name of the ticker to the console screen (without
the “.csv”)
2. Output the start date and end date that was found in the
file
3. Output how many trading day(s) existed in the file
4. Prompt the use to input a number of...
Data File from excel
Date
Open
High
Low
Close
Adj Close
Volume
2019-02-25
111.76
112.18
111.26
111.59
110.1329
23750600
2019-02-26
111.26
113.24
111.17
112.36
110.8928
21536700
2019-02-27
111.69
112.36
110.88
112.17
110.7053
21487100
2019-02-28
112.04
112.88
111.73
112.03
110.5671
29083900
2019-03-01
112.89
113.02
111.67
112.53
111.0606
23501200
2019-03-04
113.02
113.25
110.8
112.26
110.7941
26608000
2019-03-05
112.25
112.39
111.23
111.7
110.2414
19538300
2019-03-06
111.87
112.66
111.43
111.75
110.2908
17687000
2019-03-07
111.4
111.55
109.87
110.39
108.9485
25339000
2019-03-08
109.16
110.71
108.8
110.51...
Futures Contracts Contract Open High o Low Worldoc 12000 s par 12 50 122 Domesticocs-12000 sper Open Og Hont Sttle Metal & Petroleum Futures Contract High to Low 1242 1254 1264 1235 1254 Open Og test 1263 Opm Copper Hgh (0-25000 per 23760 2975 2040 3.0240 Gold c-100 troya.Spertroyo Settle May July March May 29760 2995 0.030 29775 30 00305 150261 - 12 24 35 24 Cotton C--50000bsntspart 277 7.92 Orange Juice 0uS15000 Bsantspert 13810 135 25.05 2542 March Apr...
TABLE 3-1 Stock Market Quote, July 22016 (1) 6) (6) Close (9) Vol Symbol Open High Low ao Low AAR Corp. Aaron's, Inc AIR AAN 22.98 22.86 40.83 18.08 23.15 22.50 22.72 29.55 22.70 415740.80 41.36 18.39 18.05 18.22 10.45 10.16 10:20 62,85 61.7561.92 Boos Abbott Laboratories Abercrombie & Fitch ACCO Brands EI. DuPont de Nemours Eli Lilly El Paso Electric MeDonald's -0.15 -0.66 79.163 -0.14 -0.61 667,029 0.531230122196,628 0.13 0.7 1,878,642 -0.06 425,836 0.07 0.113.994,283 (1) 52 Week High...
Consider historical data showing that the average annual rate of return on the S&P 500 portfolio over the past 90 years has averaged roughly 8% more than the Treasury bill return and that the S&P 500 standard deviation has been about 20% per year. Assume these values are representative of investors' expectations for future performance and that the current T-bill rate is 5%. Calculate the utility levels of each portfolio for an investor with A = 2. Assume the utility...
B с D E F G H Close Call Trading 2 Internal Audit Inspection 1111 Davidson 3/4/17 Sales Invoices 31/3/17 Invoice No Product Unit Price Customer 4 Employee 5 Employee Name 6 Date Performed 7 8 Audit Type 9 Prepared on 10 11 Analysis 12 Sales Invoices Date Shipped 13 14 31/3/17 15 31/3/17 16 31/3/17 17 31/3/17 18 31/3/17 19 31/3/17 20 31/3/17 21 31/3/17 22 31/3/17 23 Total 24 101101 101101 101101 101 102 101102 101103 101104 101104...
Og revest Futures Contracts Metal & Petroleum Futures Contract Open Hgh to low Settle Copperh onco 25.000s.Sperti 2700 275 297 22915 2004 20 2.072S LOS Gold D-100 ty pertroyer - U TISKO TON TON 1922 1100 15 TO WO 1150 115 17. 1150.00 DL 1100 DM UM noms-Strypto EI EGÉSes S&S ESSE Contact Open Hy belo Se Og Het Sugar-World 112000 sparta May 1242 123 1235 1294 2 993 120 22 129 J Sugar-Domesticos-us-112000 h.cosper 245 245 246 25 -...
Write a C++ program that will input data from a Comma-separated
values (.csv) file and output some information about it. This
program uses a csv file from Yahoo Finance
(.csv) filename : SBUX.csv
1. Output the name of the ticker to the console screen (without
the “.csv”)
2. Output the start date and end date that was found in the
file
3. Output how many trading day(s) existed in the file
4. Prompt the use to input a number of...
Most questions answered within 3 hours.
-
An ideal toroidal solenoid (Figure 1) has inner radius r1 = 15.5
cm and outer radius...
asked 2 hours ago -
A student sees her physical science professor approaching on the
sidewalk that runs by her dorm....
asked 3 hours ago -
I need to make up a critical incident report for client with
PTSD
asked 4 hours ago -
A champion athlete can produce one horsepower (746 W) for a
short period of time. If...
asked 5 hours ago -
Accidents_Daily_(X)
P(X)
0
0,26
1
0,29
2
0,17
3
0,11
4
0,08
5
0,06
6
0,03...
asked 5 hours ago -
1. Discuss how users can be authenticated by the operating
system to connect to the Oracle...
asked 5 hours ago -
The future value of $580 eight years from now at 6 percent.
(Round your FV factor...
asked 5 hours ago -
[16] According to the textbook, few Hong Kong Chinese
believe that outcomes are determined by joss,...
asked 5 hours ago -
Program Language: PYTHON
Consider the following file structure: each line of the file
contains a word....
asked 5 hours ago -
Write down the balanced chemical equation for the reaction between
KMnO4 &C2H2O4?
Please show work
asked 5 hours ago -
A new drug is thought to lower cholesterol. Nine individuals
were matched to nine other individuals...
asked 5 hours ago -
Suppose that the demand for wheat (measured in bushels) is given
by:
Qw = 90 –...
asked 6 hours ago