Google Finance Sheet NSE. Google Sheets comes with a built-in function known as GOOGLE FINANCE that gives current or historical securities information from Google Finance to a Google Sheet. Google Sheets is used by many people to achieve their spreadsheet data needs. Instead of using Excel to work most individuals prefer using Google Sheets.
This will enable them to retrieve historical and real-time stock prices for all NSE-listed equities. Keep reading on Google Finance Sheet NSE to gather more information on this article.
CHECK THESE OUT: New Google Finance: Getting Started with Google Finance
Google Finance Sheet NSE
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 is 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 USD 3 trillion 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.
The Basic Syntax
This function that is used in Google Sheets is the GOOGLE FINANCE function. Therefore, to retrieve real-time and historical prices using Sheets, the function layout is as follows: FORMULA = GOOGLE FINANCE (TICKER, [ATTRIBUTE], [START_DATE], [END_DATE|DAYS], [INTERVAL]).
Now to retrieve the real-time and historical prices, you need to keep all the fields empty after the mandatory TICKER field. Let’s use the various attributes that make up the function.
Ticker Symbol
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 extracting 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, their 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” 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).
Also, suppose you want to retrieve all end-of-day (EOD) prices of stock for Reliance Industries from the current calendar year (2020) use these steps below:
- First, go to https://finance.google.com.
- And search for RELIANCE.
- The ticker to use is “NSE: RELIANCE”.
- Take note of the following: first, it’s compulsory to specify both the exchange symbol and the ticker symbol. Google will approximate the best result and return it to you. Second, Reuter’s instrument Codes are no longer accepted by Google.
Attribute
This is an optional field. (All optional fields are marked by the “[]” brackets). The Attribute function at default will fetch the latest real-time price quote delayed just 20 minutes (the prices attributes)
Start Date
This is an optional field too. This is only for historical prices. This is the first date you want to push up prices for MM/DD /YYYY format.
End Date
This is the last date you wish to pull up prices for. It’s also an optional field for only historical prices.
Num Days
You can use this field to either specific END DATE or NUM_ DAYS for historical prices. It is the number of days you want to pull up the prices for.
Interval
This is the last field and it’s also optional. It is the frequency of data; this can be either be set to “DAILY” or “WEEKLY”, but also it can be set to either “1” or “7”.
How to Get NSE Real-Time Price on Google
Let’s see how to get NSE real-Time Prices in Google Sheets. 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, 1 year, and so on or the whole life span of the selected company.
The page shows the company’s name, price change, and 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 closest.
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.
