I am building a Google Finance Spread Sheet for my portfolio and curious about a few things.
Generally, I am trying to calculate the monthly returns for each month and essentially outputted the beginning and ending market values for each stock and summed them together.
First, there are stock splits that can occur over time. While Google Finance adjusts the share price for these splits, the number of shares that I own has been manually entered in a set of cells in the above described computation. How do I adjust this for select time periods? More generally, is there a seamless way to calculate the market value as I have described accounting for the fact that sometimes my assets might change? I realize you can do this on a month to month basis manually, adjusting the assets, but wondering if this is the only way?
Second, how do I incorporate dividend data into my spreadsheet?