\n Module II: Excel Assignment – Part 1\n <\/p>\n
\n Part 1: Analyzing “stock market condition”. (Note: Collect S&P500 index prices using Yahoo! Finance.)\n <\/p>\n
\n 1)\u00a0From\u00a0Nasdaq\u00a0(https:\/\/www.nasdaq.com\/market-activity\/index\/spx\/historical), download S&P500 daily index prices over the period from Dec. 31, 2019, to Jun 30, 2021. (Note: Select 5Y and find the data range.)\n <\/p>\n
\n 2) Calculate daily S&P500 index returns and daily cumulative returns over the sample period.\n <\/p>\n
\n 3) Plot the cumulative returns and analyze the plot.\n <\/p>\n
\n Module II: Excel Assignment – Part 2\n <\/p>\n
\n Part 2: Analyzing “TED Spread”. (Note: Use FRED Economic Research Data.)\n <\/p>\n
\n 1) Download daily\u00a0 “3-month London Interbank Offered Rate (LIBOR), based on U.S. Dollar” over the period from Dec.31, 2019, to Jun 30, 2021. ( https:\/\/fred.stlouisfed.org\/series\/USD3MTD156N )\n <\/p>\n
\n 2) Download daily “3-month Treasury Constant Maturity Rate”\u00a0from Dec.31, 2019, to Jun 30, 2021. ( https:\/\/fred.stlouisfed.org\/series\/DGS3MO)\n <\/p>\n
\n 3) Calculate daily TED spreads over the sample period.\n <\/p>\n
\n 4) Plot the spreads and analyze the plot.\n <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Module II: Excel Assignment – Part 1 Part 1: Analyzing “stock market condition”. (Note: Collect S&P500 index prices using Yahoo! Finance.) 1)\u00a0From\u00a0Nasdaq\u00a0(https:\/\/www.nasdaq.com\/market-activity\/index\/spx\/historical), download S&P500 daily index prices over the period from Dec. 31, 2019, to Jun 30, 2021. (Note: Select 5Y and find the data range.) 2) Calculate daily S&P500 index returns and daily cumulative […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/302776"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=302776"}],"version-history":[{"count":1,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/302776\/revisions"}],"predecessor-version":[{"id":322885,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/302776\/revisions\/322885"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=302776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=302776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=302776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}