Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bloomberg: Download historical Cumulative Returns for Pfizer (ticker: PFE) and DAL. Get daily returns from 3/1/2020-1/14/2022. Using Bloomberg, you can type in the ticker symbol

image text in transcribed

Bloomberg: Download historical Cumulative Returns for Pfizer (ticker: PFE) and DAL. Get daily returns from 3/1/2020-1/14/2022. Using Bloomberg, you can type in the ticker symbol (i.e. PFE US Equity) and then select Security Description. Click on the Price Chart. From there you can set your time frame, and choose Total Return (Cumulative Gross) instead of PX Last. Then instead of a chart, choose to display a table. Now, from the Add Data box, simply add: Delta Airlines (by typing the ticker: DAL). This adds another column containing DAL's daily total returns over the same period. You can then left click within the data's column header to select the whole column (for where to click, see my circle over the screenshot image below). With the columns selected, right click to find "Copy. Copy these columns to a spreadsheet. 9 X Options GP PFIZER INC Equity x + Message GO F1 F2 F3 F4 PRINT HELP MEMC SEARCQUOTQUOT MON NEWS MSG MENU PG BA PG FW PFIZER INC Equity GP Related Functions Menu C. ? PFE US $ 1 53.98 +0.44 cm G53.97/53.98T 7x7 At 13:24 d Vol 17,228,212 0 53.96K H 54.255D L 53.07N Val 924.573M Equity 99) Suggested Charts 96) Actions - 97) Edit Line Chart 03/01/20200 - 01/14/20220 Cumul Tot Re Local CCY Mov Avgs Key Events YID TY SY MAX Chart + Quick-Add Add Data PFIZER INC Equity GP Related Functions Menu C. ? PFE US $ 1 53.98 +0.44 cm G53.97/53.98T 7x7 At 13:24 d Vol 17,228,212 0 53.96K H 54.255D L 53.07N Val 924.573M Equity 99) Suggested Charts 96) Actions - 97) Edit Line Chart 03/01/20200 - 01/14/20220 Cumul Tot Re Local CCY Mov Avgs Key Events YID TY SY MAX Chart + Quick-Add Add Data

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_2

Step: 3

blur-text-image_3

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

The Global Financial Crisis And The New Monetary Consensus

Authors: Marc Pilkington

1st Edition

0415524059, 978-0415524056

More Books

Students also viewed these Finance questions

Question

When it is good, what is different?

Answered: 1 week ago

Question

What are the stages of project management? Write it in items.

Answered: 1 week ago

Question

why do consumers often fail to seek out higher yields on deposits ?

Answered: 1 week ago