Results 1 to 3 of 3

Automatically Calculate Stock Profits In Logbook

Threaded View

SamuraiSam83 Automatically Calculate Stock... 03-01-2015, 08:30 PM
FDibbins Re: Automatically Calculate... 03-01-2015, 09:17 PM
SamuraiSam83 Re: Automatically Calculate... 03-01-2015, 09:58 PM
  1. #1
    Registered User
    Join Date
    12-31-2014
    Location
    US
    MS-Off Ver
    Microsoft Office Home and Student 2013
    Posts
    7

    Automatically Calculate Stock Profits In Logbook

    Hi,

    I have a logbook that I am using to keep track of investments. I have found a formula that calculates the Profit/Loss, but it requires me to manually select the Cost value in the Profit/Loss formula for it to work. I would like to know if there is a way to automate this so that it automatically selects the Cost value. I don't know how well I can explain what I am trying to do, but I have uploaded a sample of my workbook.

    Regards,
    Sam
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] A complex formula to calculate the profits
    By shimaa01234 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-29-2015, 03:44 PM
  2. How to calculate the stock
    By mrzura in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2013, 09:13 AM
  3. Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  4. Replies: 0
    Last Post: 09-25-2012, 09:39 AM
  5. Calculate Gross and Net Profits
    By monkfunk in forum Excel General
    Replies: 5
    Last Post: 10-18-2009, 06:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1