Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer this question using excel sheet and please provide the formula and explain it to step by step permno date ticker 10026 11/1/2019 JJSF 10026
Answer this question using excel sheet and please provide the formula and explain it to step by step
permno date ticker 10026 11/1/2019 JJSF 10026 11/4/2019 JJSF 10026 11/5/2019 JJSF 10026 11/6/2019 JJSF 10026 11/7/2019 JJSF 10026 11/8/2019 JJSF 10026 11/11/2019 JSF 10026 11/12/2019 JJSF 10026 11/13/2019 JJSF 10026 11/14/2019 JJSF 10026 11/15/2019 JJSF 10026 11/18/2019 JJSF 10026 11/19/2019 JJSF 10026 11/20/2019 JJSF 10026 11/21/2019 JJSF 10026 11/22/2019 JJSF 10026 11/25/2019 JJSF 10026 11/26/2019 JJSF 10026 11/27/2019 JSF 10026 11/29/2019 JJSF 10026 12/2/2019 JJSF 10026 12/3/2019 JJSF 10026 12/4/2019 JJSF 10026 12/5/2019 JJSF 10026 12/6/2019 JJSF 10026 12/9/2019 JJSF 10026 12/10/2019 JJSF 10026 12/11/2019 JJSF 10026 12/12/2019 JJSF 10026 12/13/2019 JJSF 10026 12/16/2019 JJSF 10026 12/17/2019 JJSF 10026 12/18/2019 JJSF 10026 12/19/2019 JJSF 10026 12/20/2019 JJSF 10026 12/23/2019 JJSF 10026 12/24/2019 JJSF 10026 12/26/2019 JJSF 10026 12/27/2019 JJSF 10026 12/30/2019 JJSF 10026 12/31/2019 JJSF 10028 11/1/2019 DGSE 10028 11/4/2019 DGSE 10028 11/5/2019 DGSE 10028 11/6/2019 DGSE 10028 11/7/2019 DGSE 10028 11/8/2019 DGSE 10028 11/11/2019 DGSE 10028 11/12/2019 DGSE 10028 11/13/2019 DGSE 10028 11/14/2019 DGSE 10028 11/15/2019 DGSE 10028 11/18/2019 DGSE 10028 11/19/2019 DGSE comnam prc vol ret J & J SNAC 189.78 107487 J & J SNAC 189.36 111578 J & J SNAC 188.16 111746 J & J SNAC 190.23 101942 J & J SNAC 190.58 92586 J & J SNAC 180.93 111676 J & J SNAC 183.62 61209 J & J SNAC 181.7 111150 J & J SNAC 183.64 76016 J & J SNAC 183.09 60206 J & J SNAC 186.08 70227 J & J SNAC 185.35 74436 J & J SNAC 186.83 64752 J & J SNAC 188 89389 J & J SNAC 187.92 71220 J & J SNAC 185.51 82664 J & J SNAC 186.72 84790 J & J SNAC 187.62 75245 J & J SNAC 186.29 110131 J & J SNAC 185 38235 J & J SNAC 184.25 121203 J & J SNAC 186.94 112357 J & J SNAC 188.1 63753 J & J SNAC 188.01 93226 J & J SNAC 188.8 65086 J & J SNAC 185.41 85903 J & J SNAC 186.32 86150 J & J SNAC 187.1 78627 J & J SNAC 185.02 65718 J & J SNAC 185.03 47324 J & J SNAC 184.42 76179 J & J SNAC 182.46 89534 J & J SNAC 183.12 87603 J & J SNAC 184.49 J & J SNAC 187.22 310370 J & J SNAC 186.31 72755 J & J SNAC 185.61 50732 J & J SNAC 186.18 83631 J & J SNAC 186.63 124342 J & J SNAC 185.93 65837 J & J SNAC 184.27 89104 DGS E CO 1.25 30074 DGSE CO 1.2601 14080 DG SECO 1.28 12654 DGS E CO 1.28 35504 DG SECO 1.27 17195 DGS E CO 1.29 39795 DG SECO 1.39 104186 DGSE CO 1.6 855115 DGSE CO 1.5326 129354 DGSE CO 1.5501 195299 DGSECO 1.5369 94461 DGSE CO 1.48 97389 DG SECO 1.5 289060 85720 Download the file Price.xls and open using excel. Read the dictionary carefully. Calculate the return for each security each day (return is the percentage change in price and is calculated as [(Price - Price t-1)/Pricet- 1) and answer the following questions: 1. Which permno recorded the lowest daily return in the time period? (enter the permno associated with the company name) 2. Which day in December had the highest average return? (enter the day of the month for example if the answer if Dec 20th, enter 20 in the answer box). 3. What was the total volume of shares traded on December 31st, 2019? (treat any missing vol observations as zero - enter the number with no separators for example 1000000 for 1 million shares traded) permno date ticker 10026 11/1/2019 JJSF 10026 11/4/2019 JJSF 10026 11/5/2019 JJSF 10026 11/6/2019 JJSF 10026 11/7/2019 JJSF 10026 11/8/2019 JJSF 10026 11/11/2019 JSF 10026 11/12/2019 JJSF 10026 11/13/2019 JJSF 10026 11/14/2019 JJSF 10026 11/15/2019 JJSF 10026 11/18/2019 JJSF 10026 11/19/2019 JJSF 10026 11/20/2019 JJSF 10026 11/21/2019 JJSF 10026 11/22/2019 JJSF 10026 11/25/2019 JJSF 10026 11/26/2019 JJSF 10026 11/27/2019 JSF 10026 11/29/2019 JJSF 10026 12/2/2019 JJSF 10026 12/3/2019 JJSF 10026 12/4/2019 JJSF 10026 12/5/2019 JJSF 10026 12/6/2019 JJSF 10026 12/9/2019 JJSF 10026 12/10/2019 JJSF 10026 12/11/2019 JJSF 10026 12/12/2019 JJSF 10026 12/13/2019 JJSF 10026 12/16/2019 JJSF 10026 12/17/2019 JJSF 10026 12/18/2019 JJSF 10026 12/19/2019 JJSF 10026 12/20/2019 JJSF 10026 12/23/2019 JJSF 10026 12/24/2019 JJSF 10026 12/26/2019 JJSF 10026 12/27/2019 JJSF 10026 12/30/2019 JJSF 10026 12/31/2019 JJSF 10028 11/1/2019 DGSE 10028 11/4/2019 DGSE 10028 11/5/2019 DGSE 10028 11/6/2019 DGSE 10028 11/7/2019 DGSE 10028 11/8/2019 DGSE 10028 11/11/2019 DGSE 10028 11/12/2019 DGSE 10028 11/13/2019 DGSE 10028 11/14/2019 DGSE 10028 11/15/2019 DGSE 10028 11/18/2019 DGSE 10028 11/19/2019 DGSE comnam prc vol ret J & J SNAC 189.78 107487 J & J SNAC 189.36 111578 J & J SNAC 188.16 111746 J & J SNAC 190.23 101942 J & J SNAC 190.58 92586 J & J SNAC 180.93 111676 J & J SNAC 183.62 61209 J & J SNAC 181.7 111150 J & J SNAC 183.64 76016 J & J SNAC 183.09 60206 J & J SNAC 186.08 70227 J & J SNAC 185.35 74436 J & J SNAC 186.83 64752 J & J SNAC 188 89389 J & J SNAC 187.92 71220 J & J SNAC 185.51 82664 J & J SNAC 186.72 84790 J & J SNAC 187.62 75245 J & J SNAC 186.29 110131 J & J SNAC 185 38235 J & J SNAC 184.25 121203 J & J SNAC 186.94 112357 J & J SNAC 188.1 63753 J & J SNAC 188.01 93226 J & J SNAC 188.8 65086 J & J SNAC 185.41 85903 J & J SNAC 186.32 86150 J & J SNAC 187.1 78627 J & J SNAC 185.02 65718 J & J SNAC 185.03 47324 J & J SNAC 184.42 76179 J & J SNAC 182.46 89534 J & J SNAC 183.12 87603 J & J SNAC 184.49 J & J SNAC 187.22 310370 J & J SNAC 186.31 72755 J & J SNAC 185.61 50732 J & J SNAC 186.18 83631 J & J SNAC 186.63 124342 J & J SNAC 185.93 65837 J & J SNAC 184.27 89104 DGS E CO 1.25 30074 DGSE CO 1.2601 14080 DG SECO 1.28 12654 DGS E CO 1.28 35504 DG SECO 1.27 17195 DGS E CO 1.29 39795 DG SECO 1.39 104186 DGSE CO 1.6 855115 DGSE CO 1.5326 129354 DGSE CO 1.5501 195299 DGSECO 1.5369 94461 DGSE CO 1.48 97389 DG SECO 1.5 289060 85720 Download the file Price.xls and open using excel. Read the dictionary carefully. Calculate the return for each security each day (return is the percentage change in price and is calculated as [(Price - Price t-1)/Pricet- 1) and answer the following questions: 1. Which permno recorded the lowest daily return in the time period? (enter the permno associated with the company name) 2. Which day in December had the highest average return? (enter the day of the month for example if the answer if Dec 20th, enter 20 in the answer box). 3. What was the total volume of shares traded on December 31st, 2019? (treat any missing vol observations as zero - enter the number with no separators for example 1000000 for 1 million shares traded)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started