You are the COO managing the operations of a robo-advisor and you need to ensure that...

 

Transcribed Image Text:

You are the COO managing the operations of a robo-advisor and you need to ensure that all the stock holdings in the portfolios under management are kept up to date. Given the following inputs in Figure 1, evaluate the number of stocks that are held in a target_pf for each month until query_date. import pandas as pd import numpy as np portfolios_fn = "portfolios.csv" price_fn = "price_data.csv" target_pf=299 query_date="2016-09-30" Figure 1: Python inputs Design and create code that will help you to evaluate the stock holding of the target_pf on query_date. Appendix A describe the operation of the robo-advisor and Appendix B describe the data format of portfolios.csv and price_data.csv. Print the stock holdings of target_pf on query_date clearly. You are reminded that your code must be driven entirely off the inputs in Figure 1. (15 marks) You are the COO managing the operations of a robo-advisor and you need to ensure that all the stock holdings in the portfolios under management are kept up to date. Given the following inputs in Figure 1, evaluate the number of stocks that are held in a target_pf for each month until query_date. import pandas as pd import numpy as np portfolios_fn = "portfolios.csv" price_fn = "price_data.csv" target_pf=299 query_date="2016-09-30" Figure 1: Python inputs Design and create code that will help you to evaluate the stock holding of the target_pf on query_date. Appendix A describe the operation of the robo-advisor and Appendix B describe the data format of portfolios.csv and price_data.csv. Print the stock holdings of target_pf on query_date clearly. You are reminded that your code must be driven entirely off the inputs in Figure 1. (15 marks)