AnsweredAssumed Answered

Gain or Loss on Stock

Question asked by on Aug 28, 2013
Latest reply on Aug 29, 2013 by philmodjunk


Gain or Loss on Stock


     I have a record for each stock and the amount I paid for it and the date of purchase.

     Another record is generated when the stock is sold.  Would like to have a formula to find how much money I lost or made on the transaction.

     My problem has been that these records are downloaded from the broker and they come separately  . . . so that is why I get two records.  Would like to combine the buy and sell in one record automatically.  

     If that can not be done . . . then one record has to be subtracted from the other record. 

     Would be grateful for any help.