Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 2. Download, graph, and discuss historical exchange rate data a) Download daily direct spot exchange rates (i.e., XXX/USD) for one of these currencies --

image text in transcribed

Part 2. Download, graph, and discuss historical exchange rate data a) Download daily direct spot exchange rates (i.e., XXX/USD) for one of these currencies -- EUR, GBP, AUD, or NZD -. from www.investing.com/currencies from end-December 2019 to the present. Sort the dates and exchange rates in ascending date order (oldest to newest). Create a line graph of the exchange rate over time. The vertical axis should be formatted as USD \#.\#\# , with an appropriate and informative range and scale. Show a date axis formatted quarterly at quarter end (e.g., Dec-19, Mar-20, and so forth) with a maximum date of 31 Dec. 2022 (although your data won't extend to that date). Include a single data label for the most recent spot exchange rate. Title the graph "Exhibit 2a. XXX/USD end-2019 to 2022 Y'TD" replacing XXX with the symbol for the chosen currency. b) Download daily indirect exchange rates (i.e., USD/YYY) for one of these currencies - JPY, CHF, CAD, SEK, CNY, or another currency approved by Professor Anderson from www.investing.com/currencies from end-December 2019 to the present. Sort the dates and exchange rates in ascending date order. Create a line graph of the exchange rate over time. The vertical axis should be formatted with appropriate decimal precision for the exchange rate with the three-letter currency symbol, and with an inverted vertical scale with an appropriate range. Show a date axis formatted quarterly at quarter end (e.g., e.g., Dec-19, Mar-20, and so forth) with a maximum date of 31 Dec. 2022. Include a single data label for the most recent spot exchange rate. Title the graph "Exhibit 2b. USD/YYY end-2019 to 2022 YTD" replacing YYY with the chosen currency c) Select any cross-rate of interest (e.g., EUR/CNY, CNY/JPY, CAD/MXN, etc.) for which data is available from www.investing.com/currencies from end-December 2019 to the present. Create a line graph of the exchange rate over time. The vertical axis should be formatted with appropriate decimal precision for the exchange rate with the three-letter currency symbol with an appropriate range. Show a date axis formatted quarterly at quarter end (e.g., e.g., Dec-19, Mar-20, and so forth) with a maximum date of 31 Dec. 2022 . Include a single data label for the most recent spot exchange rate. Title the graph "Exhibit 2c. QQQ/ZZZ end-2019 to 2022 YTD" replacing QQQ and ZZZ with the currency symbols. d) Select any one of the three exchange rates graphed for further research regarding currency movements since end-2019, with an emphasis on the past year. Identify at least three (3) articles in the Wall Street Journal, Financial Times, or other media sources about movement in the chosen exchange rate. Describe and briefly explain the movement over the past year in a concise originally written paragraph (fewer than 300 words, single spaced), citing references consulted. Provide full bibliographic references and URLs for all sources consulted. Every word you write will be carefully read, so please write accordingly. Part 2. Download, graph, and discuss historical exchange rate data a) Download daily direct spot exchange rates (i.e., XXX/USD) for one of these currencies -- EUR, GBP, AUD, or NZD -. from www.investing.com/currencies from end-December 2019 to the present. Sort the dates and exchange rates in ascending date order (oldest to newest). Create a line graph of the exchange rate over time. The vertical axis should be formatted as USD \#.\#\# , with an appropriate and informative range and scale. Show a date axis formatted quarterly at quarter end (e.g., Dec-19, Mar-20, and so forth) with a maximum date of 31 Dec. 2022 (although your data won't extend to that date). Include a single data label for the most recent spot exchange rate. Title the graph "Exhibit 2a. XXX/USD end-2019 to 2022 Y'TD" replacing XXX with the symbol for the chosen currency. b) Download daily indirect exchange rates (i.e., USD/YYY) for one of these currencies - JPY, CHF, CAD, SEK, CNY, or another currency approved by Professor Anderson from www.investing.com/currencies from end-December 2019 to the present. Sort the dates and exchange rates in ascending date order. Create a line graph of the exchange rate over time. The vertical axis should be formatted with appropriate decimal precision for the exchange rate with the three-letter currency symbol, and with an inverted vertical scale with an appropriate range. Show a date axis formatted quarterly at quarter end (e.g., e.g., Dec-19, Mar-20, and so forth) with a maximum date of 31 Dec. 2022. Include a single data label for the most recent spot exchange rate. Title the graph "Exhibit 2b. USD/YYY end-2019 to 2022 YTD" replacing YYY with the chosen currency c) Select any cross-rate of interest (e.g., EUR/CNY, CNY/JPY, CAD/MXN, etc.) for which data is available from www.investing.com/currencies from end-December 2019 to the present. Create a line graph of the exchange rate over time. The vertical axis should be formatted with appropriate decimal precision for the exchange rate with the three-letter currency symbol with an appropriate range. Show a date axis formatted quarterly at quarter end (e.g., e.g., Dec-19, Mar-20, and so forth) with a maximum date of 31 Dec. 2022 . Include a single data label for the most recent spot exchange rate. Title the graph "Exhibit 2c. QQQ/ZZZ end-2019 to 2022 YTD" replacing QQQ and ZZZ with the currency symbols. d) Select any one of the three exchange rates graphed for further research regarding currency movements since end-2019, with an emphasis on the past year. Identify at least three (3) articles in the Wall Street Journal, Financial Times, or other media sources about movement in the chosen exchange rate. Describe and briefly explain the movement over the past year in a concise originally written paragraph (fewer than 300 words, single spaced), citing references consulted. Provide full bibliographic references and URLs for all sources consulted. Every word you write will be carefully read, so please write accordingly

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Finance questions

Question

What research background do you have?

Answered: 1 week ago