Part One: Portfolio Return Collect data about SPY (US market), HSBC London Market) and Ooredoo(GCC Market), related to three years: 2017, 2018, 2019 for the following items: Price at the beginning of the year and price at the end of year Dividends declared during the year-both cash dividend and stock dividend. Check if there was any stock split, rights issue or bonus issue. Calculate HPR and HPY for each stock for each year. Calculate portfolio HPR and HPY for each year. Plot the portfolio HPY in the form a graph I _In part 1 you have selected stocks from three countries. For the same three countries collect data related to the stock market index in that country for the same period: Mention the name of the index for which you are collecting data Collect data for 2017, 2018, and 2019: Index at the beginning of the year and index at the end of the year Calculate HPR and HPY for each index for each year Plot the HPYs of the indexes in form of a graph Compare and comment on the performance of your portfolio which you created in part 1 with the performance of the three indexes Create another graph showing HPY of your portfolio and the HPYs of the three indexes. As an investor where would you make more money, investing in your portfolio or investing in any one of the indexes? Explain. Part One: Portfolio Return Collect data about SPY (US market), HSBC London Market) and Ooredoo(GCC Market), related to three years: 2017, 2018, 2019 for the following items: Price at the beginning of the year and price at the end of year Dividends declared during the year-both cash dividend and stock dividend. Check if there was any stock split, rights issue or bonus issue. Calculate HPR and HPY for each stock for each year. Calculate portfolio HPR and HPY for each year. Plot the portfolio HPY in the form a graph I _In part 1 you have selected stocks from three countries. For the same three countries collect data related to the stock market index in that country for the same period: Mention the name of the index for which you are collecting data Collect data for 2017, 2018, and 2019: Index at the beginning of the year and index at the end of the year Calculate HPR and HPY for each index for each year Plot the HPYs of the indexes in form of a graph Compare and comment on the performance of your portfolio which you created in part 1 with the performance of the three indexes Create another graph showing HPY of your portfolio and the HPYs of the three indexes. As an investor where would you make more money, investing in your portfolio or investing in any one of the indexes? Explain
