How to Analyze Stock Performance
- 1). Gather your brokerage statements. Determine which period of time you want your analysis to cover. For an annual analysis, you would need the brokerage statements from the same month but consecutive years: for instance, May 2009 and May 2010.
- 2). Create a spreadsheet and list each stock you own on a separate line. You can do these calculations with a calculator, but a spreadsheet program is easier.
- 3). Enter the price of each stock from the earliest brokerage statement in the first column of the spreadsheet. Enter the price of the same stock from the later statement in the next column.
- 4). Subtract the earlier price of the stock from the later one. For instance, users of Microsoft Excel would enter "=B3-C3" if the earlier price was in cell B3 and the later price in cell C3.
- 5). Divide the result calculated in Step 4 by the initial price of the stock from the first brokerage statement. For instance, if the result from Step 4 is in cell D3, the formula would be "=D3/B3."
- 6). Multiply the result from Step 5 by 100 to get the percentage gain on the stock. Analyze the results on your spreadsheet to see which stocks have fared well and which have fared poorly.