Prepare a Python script that create and deliver information displayed in the format given in Table 1. The first three columns report the names, allocation and prices of the stocks in the portfolio on Report Date. The Units column reports the total units of the stocks held in the portfolio on the Report Date and the Invt ($) column prints the total amount of money used to acquire the respective stocks. The Mkt Value ($) column reports the market value of the stocks on Report Date while the Return (%) column prints the return of stock in the portfolio.
Given the following inputs to your Python script in Figure 1, and together with your Python script, generate the performance of portfolios with ID = 30 and 4502 on 31-Dec-2015 in the format given in Table 1. Hence, report the ID and return of the portfolio that has the highest return on the 31-Dec-2015.
TO BE SUBMITTED IN JUPYTER NOTEBOOK (.ipynb)
Dataset can be retrieved at
https://www.dropbox.com/s/ucvb4k1nz0qgnxf/portfolios.csv?dl=0
https://www.dropbox.com/s/ybt5iqj5ook09ss/raw_price_data.csv?dl=0
0 comments