Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Get Current Stock Price of India in Excel

The persons who invest their money in the stock market have to always check the latest stock price to gain profit from them. As a result, they go to the stock exchange market to get the update. However, you can easily check the latest stock price of a company using Microsoft Excel from your home. Today, in this article, we’ll learn four quick and suitable ways to get current stock price of India in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Ways to Get Current Stock Price of India in Excel

Let’s say, we have a dataset where several Indian stock company names, current price, and the percentage of change are given in columns B, C, and D respectively. Now we will get the current stock price of the Indian stock market. To do that, we will apply the STOCKHISTORY, TODAY functions, built-in Stocks command, and so on. Here’s an overview of the dataset for today’s task.

get current stock price in excel india


1. Use STOCKHISTORY Function to Get Current Stock Price of India

In this section, we will use the STOCKHISTORY and TODAY functions to get the current price in the stock market of India. This is an easy and time-saving task. Let’s follow the instructions below to learn!

Step 1:

  • First of all, we will apply the TODAY function in cell D15 to get today’s date. For that, write down the following formula in the cell:
=TODAY()

Use STOCKHISTORY Function to Get Current Stock Price in India

  • Hence, write down the below Mathematical formula in cell D13 to get the previous date:
=D15-1

  • After that, simply press ENTER on your keyboard, and you will get the return of the Mathematical The return is 8/16/2022.

Use STOCKHISTORY Function to Get Current Stock Price in India

Step 2:

  • Now, we apply the STOCKHISTORY Function to get the current price of the Indian stock market. To do that, select cell C5 and write down the STOCKHISTORY Function in that cell. The STOCKHISTORY function is,
=STOCKHISTORY(B5,$D$13,$D$15,0,0)

  • Further, again, simply press ENTER on your keyboard, and you will get the current price of that corresponding date. The current price is ₹ 2,817.00.

Use STOCKHISTORY Function to Get Current Stock Price in India

  • Hence, AutoFill the STOCKHISTORY function in the rest of the cells in column D to get the current price of the Indian stock market.

Use STOCKHISTORY Function to Get Current Stock Price in India

Read More: How to Get Historical Data of NSE Stocks in Excel (2 Effective Ways)


Similar Readings


2. Apply Stock Command to Get Current Stock Price of India

In this method, we will use Excel’s built-in Stocks command to get the current stock prices in India. Let’s follow the instructions below to learn!

Steps:

  • First of all, select the entire range of cells B5:B11. After that, from your Data ribbon, go to,

Data → Data Types → Stocks

Apply Stock Command to Get Current Stock Price in India

  • You will see the companies’ name patterns will change, and it will get the complete name structure. Besides it, you will see a small widget pop-up icon appear at the right corner of the selected names.

  • If you click on it, you will get several fields listed there. We are going to add only the Price and Change(%) fields according to our desire.
  • For that, click on the widget pop-up icon, scroll down in the Field list with your mouse and select the Price option.

Apply Stock Command to Get Current Stock Price in India

  • As a result, you will see the Price of all seven companies will add in the range of cells C5:C11.

  • Similarly, add the Change(%) field in column D.

Apply Stock Command to Get Current Stock Price in India

  • To get the latest update on the stock market, from your Data ribbon, go to,

Data → Queries & Connections → Refresh All Connections

Read More: How to Get Live Stock Prices in Excel (4 Easy Ways)


3. Using Power Query to Get Current Stock Price of India

The Power Query of Excel can help us to get the stock prices from any external website. In this process, we will show how to do it. Let’s follow the instructions below to learn!

Steps:

  • First of all, from your Data ribbon, go to,

Data → Get & Transform Data → From Web

Using Power Query to Get Current Stock Price in India

  • A small dialog box titled From Web will appear.
  • Then, choose the Basic option and paste the website link into the empty box. We are pasting a link from Yahoo Finance.
  • Click OK. keep patience, it will take a while.

  • Then, the Navigator window will appear in front of you.
  • After that, select Table 0 and click on the Load. The panel will also show you a visual representation of that dataset.

Using Power Query to Get Current Stock Price in India

  • You will see that within a few seconds, the current stock price list will be in your Excel spreadsheet. Format the key columns to get a better outlook of your dataset.

Using Power Query to Get Current Stock Price in India

Read More: How to Import Stock Prices into Excel from Yahoo Finance


Things to Remember

➜ You can perform method 1 and method 2 in Microsoft Office 365 only. You can use Power Query in Excel 365 and any other version.

➜ While a value can not found in the referenced cell, the #N/A! error happens in Excel.

#DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.


Conclusion

I hope all of the suitable methods mentioned above to get current stock price in excel India will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

4 Comments
  1. Update function work work in Google sheets itself or have to go to linked excell sheet in window

    • Hello, AMIT!
      I’m really sorry to say that the STOCKHISTORY function won’t work in Google Sheet as google sheet has limited functions to perform but the TODAY function will work adequately. You need to work on an Excel sheet.

  2. Hi sir, Stocks option is only showing NASDAQ index. how do I get Indian scrips there?

  3. Reply
    Md. Abdur Rahim Rasel Oct 4, 2022 at 1:40 PM

    Hello VADAKKUS!
    To get the Stocks of the Indian Index instead of the NASDAQ Index, please use the below link in Method 3. The link is: https://www.moneycontrol.com/markets/indian-indices/
    Thank you for your comment.
    Regards
    Md. Abdur Rahim Rasel (Exceldemy Team)

Leave a reply

ExcelDemy
Logo