How to Use NSE Data in Google Sheets
This guide will walk you through the process of downloading NSE data, importing it into Google Sheets, customizing the sheet, and using Google Finance to fetch real-time stock data.
Step 1: Accessing the NSE Data
To begin, you need to visit the official NSE India website. Once you're there:
- Look for Market Data.
- Click on Trading on Securities Available.
- Select the Equity Segment on the Securities Available link.
- By clicking this, you'll download a .csv file containing the list of all companies listed on the NSE.
Step 2: Importing Data into Google Sheets
After downloading the .csv file:
- Open the .csv file, and you’ll see a list of over 1800 companies trading on the NSE.
- Copy all the data (Ctrl + A to select all, and Ctrl + C to copy).
- Open a new Google Sheet and paste it using Ctrl + V.
- Now you should have a list of all the NSE companies in your Google Sheets, with columns for company symbol, series, market lot, and other details.
Step 3: Customizing Your Google Sheet
You can delete unnecessary columns and customize your Google Sheet to track specific information about each company, such as:
- Current Price
- 52-Week High
- 52-Week Low
- Market Capitalization (in Crores)
These are crucial metrics that can help you make better trading decisions.
Step 4: Using Google Finance to Fetch Stock Data
Google Sheets has built-in functions like Google Finance that allow you to pull real-time stock data directly into your sheet. Here’s how to use it:
- In any cell, type the formula
=GOOGLEFINANCE("symbol") where "symbol" is the stock symbol of the company (e.g., "TCS"). - You can use additional parameters such as
price, high52, low52, etc. to fetch more specific data. - Example:
=GOOGLEFINANCE("TCS", "price") will return the current price of TCS.
What is Google Finance?
Google Finance is a financial platform that provides real-time data, graphs, and news for stock markets, mutual funds, cryptocurrencies, and other investment instruments.
How to Use Google Finance?
- Type "Google Finance" in your web browser.
- Go to the homepage and select various options from the left-side menu.
- Use the search box to search for any stock, mutual fund, or currency.
- Add your favorite stocks to the watchlist or portfolio.
What Information is Available on Google Finance?
- Real-time stock data.
- Financial details of companies (such as income statements, dividends).
- Most Active Stocks.
- List of Gainers and Losers.
- Mutual funds, cryptocurrencies, and currency futures.
- Latest news and updates.
How to Create a Portfolio?
- Click on the "New Portfolio" option.
- Choose a name for your portfolio (for example, Grow).
- Add stocks, their quantity, and purchase price.
- Track and analyze your investment strategy.
Can Google Finance Track Cryptocurrencies?
Yes, on Google Finance, you can view real-time rates and news for Bitcoin, Ethereum, and other cryptocurrencies.
Does Google Finance Provide Access to Track Other Markets (such as America, Europe)?
Yes, on Google Finance, you can easily track indices from Indian, American, European, and Asian markets.
What Does "Most Active" and "Top Gainers" Mean on Google Finance?
Most Active: The stocks that are being traded the most.
Top Gainers: The stocks that have seen the highest increase in price.
Is Google Finance Available on Mobile?
Yes, you can easily access Google Finance on Android mobiles, laptops, and tablets.
Can I Read News on Google Finance?
Yes, Google Finance provides news updates from various reliable sources, keeping you informed about the status of stocks and markets.
Is Google Finance Useful for Investors?
Google Finance is highly useful for both beginner and experienced investors because it provides financial data, analysis, and news all in one place.
