samuraisam83
New member
- Joined
- Jan 14, 2015
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2013
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.
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.