Google finance considers as a great tool and application for retail investors all over the world. It works as an efficient personal portfolio manager at Free of Cost. Besides act as a portfolio builder, it plays a crucial role as an excellent stock screener. With the help of google finance, one can get the entire stock market details in a single google sheet. In the article, you will get step by step basic tutorial of Google Finance for Indian Stocks. Google sheet is almost similar to excel but with more advanced features.
Basic Tutorial of Google Finance for Indian Stocks
Though Google finance product was mainly meant for united states of America, later it has extended the services to India, France, China, Germany, UK, Australia, Singapore etc, overall 37 countries in the world. Let’s get into the steps of how to create google sheets from the drive.
Step #1 How to Create Google Sheets?
Firstly, one must have a Gmail account under Google. From there open the google drive, if you don’t have an account, then create it. In order to find google drive, look at the right-top corner of the window, you will find google drive option. If you already have an account under Google, the drive will automatically be opened.
After clicking on the Drive, a new window will be opened. There left-up corner, you will find a NEW option, just behind the Drive. Under the new option, there are google sheets. There you can find a blank spreadsheet option. From there, you may open the sheets.
Step #2 How to Get the Symbols for Google Sheets?
From the google finance, copy the code and simply put it in the Google sheet. According to your requirements, you can add and update data and information. In order to clarify the subject more accurately, I have attached some pictures below:
As from the above window pic, we can see the symbols. You can get entire details of high, low, open price, volume, etc.
Step #3 How Can we Add Symbol in Google Sheets?
In the above page, for example, purpose, I show you an example of the CMP symbol, (=GOOGLEFINANCE(B2, “price”).
This is an example of Open Price. Like this, you can put symbols of high, low. volume, PE, EPS etc.
Step #4 Update the Data
Static data without any automated update is almost valueless. Google sheets can be updated automatically. From the file, you have to go to the spreadsheet settings, there you will get a small window which contains general and calculation settings. In general, select your country and, time zone and in calculation select the update setting.
However, these are the basic concept of Google Finance for Indian Stocks. It works as an analytical tool for the stock market.
Ankita is a graduate in English language and she has also done her MBA from the Calcutta University. She has a high knack in the stock markets. She is a NISM certified Research Analyst. An experienced stock market content writer Ankita is also trading successfully on her own account.