Google Finance India is a trading site for the Indian stock market. The National stock exchange of India Limited is owned by the government, it was the first dematerialized electronic exchange in the country.
Stocks trading and investment are very appealing to some traders while to some it’s a hobby, to some it’s a way of investment for the future, all having expectations of a better increase in value and in return.
The pattern of the stock price has always been unpredictable. This has to do with some factors, there are always fluctuations in price, high volume if stocks changing as often as possible. Therefore, a tool to monitor stock prices is needful to check on performance.
CHECK THESE OUT: GOOGLE YAHOO FINANCE – GETTING STARTED WITH GOOGLE FINANCE
Google Finance India
In order to view the stock data, Google offers Google Finance as a means to view stock data which includes charts that enable you to see company performance. It offers details for a given company’s stock performance. For multiple investments, checking each company individually will be difficult.
Google Finance uses a dedicated function called Google Sheet to enable you to import data straight from Google Finance. When you know how to insert data into a spreadsheet it allows you to operate it in a way that suitable for you.
This function is called the GOOGLE FINANCE function. It a strong function that allows you to effectively go live and historical data, currency exchange, and mutual fund data.
National Stock Exchange of India
National Stock Exchange has a total market capitalization of over $3 trillion USD making it outstanding as the world’s 9th largest stock exchange as of May 2021. The NSE flagship index is on the NIFTY 50, this 50-stock index is used very extensively by Indian investors around the globe as a barometer of the Indian capital market.
This index was launched in 1996 by NSE. It is recorded that only an estimated 4% of the Indian economy and GFP is derived from the stock exchange in India.
When you see the GOOGLE FINANCE function’s Syntax, what you will really see will be the ticker and Attribute parameters that are relevant to extract real-life data. Using the ticker parameters is the major important function.
A ticker symbol or stock symbol is an acronym used to uniquely identify traded securities like shares, stocks, currency, etc. It may comprise letters, numbers, or a number of both. As stated, the exchange symbol and ticker symbol must be used to achieve accurate results. However, there many ways to get the ticker symbol.
You can use Google search by typing out the company name supplemented by “stock price”. For instance, when you search with “google stock price” on google gives the following results; As you can see, the Google search method will give you both the exchange symbol and ticker symbol (NASDAQ: GOOGL). Another method is by using tools such as Yahoo Finance lookup and Google Finance.
How to Get NSE Real-Time Price on Google
Let’s see how to get NSE real-Time Price in Google Sheet. When you look at Google Finance website, you’ll see a large chart showing how stick prices fluctuate every day. The time interval of 1 day, 5 days, 1 month, 6 months, 1year, and so on or the whole life span of the selected company.
The page shows the company’s name, price change, Percentage change for each day. When you move downward you will see a key Stats section where most of the data the GOOGLE FINANCE function pulls. There is the market cap, low, high, Volumeavg, high52, and closeyest.
Lastly, a financial performance chart will be seen, that’s where quarterly or annual data are shown. Following the annual chart, the earnings for each share value that GOOGLE FINANCE pulls will be shown. The above analysis shows how Google Finance Functions.
For further reading and seeing of examples check at https://www.sheetaki.com/how-to-get-nse-and-bse-real-time-prices-in-google-sheets/.