Results 1 to 1 of 1

Thread: Automatically Calculate Profit & Loss For Stock Logbook

  1. #1
    Neophyte samuraisam83's Avatar
    Join Date
    Jan 2015
    Excel Version
    Excel 2013

    Automatically Calculate Profit & Loss For Stock Logbook

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts