multiply numbers by corresponding price on given day for a large array of numbers

I am trying to create daily values of a portfolio through time given transactions which are made and then left in the portfolio before being sold 6 months later.(although you do not need to be able to understand this)

I think it will require a function like sumproduct, sumif, index or match.

I have a list of the number of shares transacted which I need to sum after multiplying each with its corresponding share price for an individual day (I have another work book which has a list of entity keys along the top, and the dates down with the daily share price for each entity key so you would need to match the entity key with the entity key in the shares table.). This must only be done if the date on the output lies between the purchase date (trandate) and the sale date (trandate+6 months)

the entity key will correspond to the code next to the number of shares within the data worksheet.

please see the attached spreadsheet for the details

another way of phrasing the question (its complex)
as the output, for each day, i need the total value of the portfolio and hence i need the sum of the number of shares for all transaction multiplied by the corresponding share value (from the sheet stocks) on that day and for that stock. i then need some kind of if statement to only include the transact if it between the purchase and sale date of the share.

hope you can help!