I am trying to complete an assessment where I have been provided with a dataset of securities.

In the Excel file there is a worksheet called "Data". This contains information about some trades between Jane Street and counterparties that occurred over 2 consecutive days. Assume you start with 100 shares of each security in each CSD.

1.Fill in the "Expected settlement date" column in the "Data" tab. Use details from the information sheets as you need.

2.The company BnL Corp. has an internal systems malfunction. This means all trades that BnL Corp. is trading in will fail to settle. With this in mind, calculate the end of day positions at each CSD in each separate security. There is more than one way to get the correct answers, please remember to show your working. Give your answers in the tables found in the "Answers" worksheet. (https://drive.google.com/file/d/1z-n-x06YEotueZHrXPjv4Z3SdVMnO3eA/view?usp=sharing)

How can I approach the second question?