Need a formula for profit/loss that can reference different rows of data

I am trying to find a formula for the "P/L" column that I can drag down to new cells, but will check to see which opening data it should reference. When opening data and closing data are both on the same row it works nicely, but if closing transactions get split across different dates I'm not sure how to get it to check the appropriate row without manually changing the formula. I would like to find something that can just be dragged down to duplicate. Each opening transaction should have a unique combination of Symbol, Strike, and Exp so I was thinking maybe I could use those variables to match things up, but I'm not sure how or if there is a simpler way to accomplish what I'm trying to do. Thanks!

Originally Posted by bebo021999

Your template is empty.
Try to input few rows with data manually.

Hmm... I'm sorry I'm not sure what I did wrong? When I download the example template I posted it my OP it has data in it... , here is a screenshot of the spreadsheet if that helps imgur. com/a/N8tAvCU