![]() You would enter =GoogleFinance("BCE.TO" "PRICE") in the appropriate cell to obtain the current market price, which updates every 20 minutes or so. If you want to build a more robust spreadsheet, Google Docs can also track the market price of your shares. You can click "Help" at any time if you get stuck. To do this, in a new box at the bottom of column four enter the following formula: =SUM(A:Z) where A and Z refer to the co-ordinates of the first and last cells containing the annual dividend amounts from each stock. ![]() Once you've done that for each of your stocks, the final step is to add up all of your dividends to get your total income. With Google Docs, the formula you would enter is: =PRODUCT(X Y) where X and Y refer to the co-ordinates of the cells containing the number of shares and annual dividend, respectively. Income," we'll get the spreadsheet to calculate the annual income that you receive from each of your companies by multiplying the previous two numbers together. In the fourth column, which we'll call "Div.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |