#1
|
|||
|
|||
How do I calculate the gains/loses made from buying and selling a stock?
If I bought and sold the same stock for many years, how can I calculate the total gains/loses made from all of the transactions assuming that I have a column containing all of the stock's prices, a column containing all of the buy dates, and a column containing all of the sell dates?
Cross posts: http://www.mrexcel.com/forum/excel-q...ing-stock.html http://www.excelforum.com/showthread.php?t=1168071 I attached a sample from my large spreadsheet. Essentially, any time you see a "1," that is the date I bought the stock. I would need to calculate the percent change of the stock price from that date until the date the stock was sold, which is represented by a "-1." As you can see, the stock was bought and sold many times over the years. So I would need to calculate all of the gains/loses to determine whether the decisions would have yielded an overall positive result (gain). |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Renewed Office 365 by buying at another store | RandWald | Office | 0 | 11-14-2016 01:34 PM |
changes made in track changes advanced option are made to all saved documents | Procwriter | Word | 4 | 04-11-2015 02:17 AM |
Any way to test Office 2013 RT before buying Surface 2? | leemoreau | Office | 0 | 05-15-2014 05:28 AM |
Suddenly attachments won't open without buying new Office | AJIMMO | Office | 1 | 11-19-2013 03:17 AM |
Stock levels | RobertH | Excel | 5 | 01-24-2011 01:02 PM |