How to track your Stock Portfolio using GOOGLE SHEETS? [FREE TEMPLATE]
Quick Note: In case the ticker symbol is not showing the correct company, it may be because the symbol is already registered by another company in a foreign stock exchange (US, Europe, etc). That's why it will show the data for the other company. However, there is an easy solution to this issue.
For Indian companies, use (NSE or BSE) before the company symbol to fetch the right one. For example, in the case of Larsen & Toubro Limited, use -- NSE:LT
A few other examples:
ABB -- NSE:ABB
ITC -- NSE: ITC
In other words, use the prefix of the stock exchange before the ticker symbol where the company is registered to get the live stock quotes on google sheets.
Template discussed in video: https://docs.google.com/spreadsheets/d/1aPX6Bj8Tf46FoX0i-QKhO--pJjq-lZiFRk7jxoBOKXw/edit?usp=sharing
[FREE] Template: https://docs.google.com/spreadsheets/d/1u8LDPF-xliJ-HJoYBLhFG8ddPMn-AhGZWT65FATYM1Q/edit#gid=1115838130
Google Finance: https://support.google.com/docs/answer/3093281?hl=en
Track the live quotes of your stock portfolio using this simple google sheet. Easy tutorial and step-by-step.
Learn more here: http://www.tradebrains.in/
Music Credits: Alex Skrindo & Stahl! - Moments [NCS Release]
▽ Connect with NCS
Follow Alex Skrindo
Connect with Trade Brains:
Tags: how to track your portfolio using google sheets, track portfolio using google sheets, google sheets, google sheet portfolio, google finance functions on google sheets, how to build your own portfolio using google sheets, google finance functions, google finance stock tracker, google finance tutorial, create a goggle finance portfolio in google sheets, using google finance functions on google sheets, how to track your traders with google sheets, how to make a stock portfolio on google sheets, google finance, how to track portfolio using google finance, google sheets stock template, stock portfolio spreadsheet download, stock spreadsheet template, stock portfolio tracker excel, stock portfolio excel spreadsheet download, free excel investment portfolio spreadsheet, how to make a stock portfolio in excel, investment spreadsheet excel, google spreadsheet stock tutorial, live stock quotes on google sheets.