Note: Support for this is discontinued. I'm now using Stocks Cafe instead. You should check it out! (Disclaimer: This link uses my referral code).
A completely free stock portfolio tracker using Google Sheets that allows you to key in ticker symbols and transactions to get comprehensive summaries on your portfolio with automatically updating prices, dividends, splits and more.
- One click setup button that automatically sets up the portfolio for you, ready to use
- Automatically updating stock prices and other meta data (name, dividend yield, 200 day average etc.)
- Add new transactions easily and specify the type of transaction (buy/sell/dividend etc.)
- Automatic portfolio history logging for your portfolio's own historical data and summary graphs
- Automatic logging of dividends and splits and historical price/units correction
- Comprehensive portfolio summary with sector holdings, asset holdings, returns and gains
- Supports most exchanges globally, with stocks shown in their respective currencies
- Automatic conversion to your local currency for a more relatable view in your portfolio summary
- Locality support for both US and UK (for all those MM/DD versus DD/MM users)
- Custom menu and over 1000 lines of fully commented appscript code
- Go the base spreadsheet: LINK
- Do not request edit access. In the top menu, go to File > Make a copy to import a copy into your own Google Drive.
- In the Setup page of the spreadsheet, click the blue setup button.
- Change the user settings to your preferred locale and currency.
- You're done! It's that easy. Read on for detailed instructions on usage.
The spreadsheet has a few main sheets: Setup, Portfolio Summary, Cash Flows, Stock Summary and Transactions. For explanations on each page, mouse over the header in each sheet within the spreadsheet itself. You can also mouse over most of the headers in the sheets for explanations on the data within that column.
In this user guide, we will cover the basic flow of how the spreadsheet is supposed to work. If you would like to see the inner workings and add your own things, you can find the source code in Tools > Script Editor.
The first step is to enter transactions. This can be done in the Transactions sheet. You will have to fill in all yellow cells.
In the top menu, go to Portfolio Menu > Transactions > Add New Transaction/Add New Buy Transaction. A new transaction row will appear for you to key in your transaction details.
New Transaction: Adds a single new transaction row. Useful for transactions like selling and cash outs.
New Buy Transaction: Adds two new transaction rows, one for cash in (to fund the buy transaction) and one for a buy transaction.
Note: You must have money in your account to be able to buy shares (for tracking purposes). Therefore, you must make sure to have enough cash balance to cover your share purchase. You can see your cash holdings in the Cash Flows sheet.
If you purchased a new asset you didn't own before, you will have to add it to the Stock Summary sheet. Just head on over and click an empty dropdown box under the Stock Symbol column to add your new asset. Only assets you have not added will be shown.
Fill in all yellow cells, including the sector type and asset type of the asset.
And honestly... that's about it! Everything else is automated. Note that this is an incomplete work, and the full version will be released shortly with its own website. It will still be completely free, so don't worry! Enjoy!