Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Cost Accounting Principles

Authors: Kinney Raiborn

14th Edition

9788131521069

More Books

Students also viewed these Accounting questions

Question

differentiate the function ( x + 1 ) / ( x ^ 3 + x - 6 )

Answered: 1 week ago