Google Finance Stock Portfolio Tracker Template

If you just want to download a copy scroll to the bottom of this page.

Google finance stock portfolio tracker template. Google spreadsheet portfolio tracker. Stock portfolio tracking template. Here is a video tutorial which teaches you how to get the data on google sheets using google finance create your portfolio and then track it. Whether you re a novice to stocks or an experienced trader this integration is the easiest way to import and monitor stock data in a spreadsheet. It has since become rather popular.

For stocks or indices the corresponding google finance symbol must be entered. You can monitor transactions like purchases sales dividend and stock splits monitor your stocks in a portfolio and manage and consolidate data. Nse tcs for tcs and so on. Before you can begin editing the spreadsheet and adding your own accounts you have to make a copy of it for yourself. I created a stock portfolio tracker 5 years ago that allows you to track your portfolio based on transactions and update their prices automatically.

I chose google sheets because it can query google finance to pull market data. This multi page template by oldschoolvalue is perfect for tracking a stock portfolio. Monitor the market with google finance. You can get this from google finance. You will not be able to add your own stocks to the spreadsheet until you do this.

S p 500 0 65 0 94. Nifty for nifty price. Dummy portfolio using google sheets real time updation video tutorial. Get free stock quotes and up to date financial news. I use a google sheet to track my stock portfolio.

Using google spreadsheet to track a stock portfolio. Stock portfolio tracker is investment moats attempt at creating an online spread sheet that will let a stock investor 1 monitor your stocks in a portfolio 2 track stock purchase by transactions 3 transactions compatible includes purchase sale dividend and stock splits 4 aggregate transactions to individual stocks. Google finance portfolio allows investors to add an investment portfolio or stock watchlist and track the day to day performance of current holdings and get individual charting. Choose file and then either make a copy or add to my drive. While there are other more robust tools you can use to track securities google finance is the only one that can effectively integrate with google sheets.

How to create and track your stock portfolio in google sheets.