Automatically Calculate Profit & Loss For Stock Logbook

Hello Internet,

I am creating a logbook to track stock investments. I have a column that lists the Dates, one that lists Stock Symbols, a column that lists Entry Prices, one for Exit Prices, one for Quantity of Shares, one for Cost, and one for Profit/Loss.


I would like to be able to enter the Exit Price, and have the Profit/Loss automatically be calculated based on the Symbol's Entry Price and Quantity. I currently am trying to use VLOOKUP in the Profit/Loss formula.


I have attached a sample file to give you a better idea of what I'm trying to accomplish.

Thank you for any help that you might be able to give me.