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.