欢迎来到云奕文章网_教育信息

联系我们网站地图

导航菜单

首页 > 6579 Stock Price Quote > How to Get Stock Prices in Excel (3 Easy Methods)

How to Get Stock Prices in Excel (3 Easy Methods)

2024-11-09 09:31:240 次浏览投稿

Here’s a small sample dataset that demonstrates how you can extract stock prices in Excel.

Get Stock Prices in Excel

Method 1 – Combining STOCKHISTORY and TODAY Functions in Excel

Steps

Input the stock symbol or the company ticker symbols in Excel.Enter the symbol AAPL in cell D5 for the Apple corporation.

Combining STOCKHISTORY and TODAY Functions Get Stock Prices in Excel

Enter the symbol MSFT and SONY from Microsoft and Sony corporations, respectively, in cells D6 and D7.

Combining STOCKHISTORY and TODAY Functions Get Stock Prices in Excel

Enter the following formula in the cell E5:=STOCKHISTORY(D5,TODAY(),,2,0,1)

Combining STOCKHISTORY and TODAY Functions Get Stock Prices in Excel

Drag the Fill Handle icon to cell E7.

Combining STOCKHISTORY and TODAY Functions Get Stock Prices in Excel

Breakdown of the Formula

TODAY(): Returns today’s date.

STOCKHISTORY(D5,TODAY(),,2,0,1): This function returns the history of stocks, from a specific opening date to another specific closing date. If one single date is used, today’s date, it returns only that day’s stock price.

Note:

You can only get the price information of the Stock data.Need to be connected online in order to fetch data.This option is only available in Excel 365 or the online version of Excel.Method 2 – Get Stock Prices by Utilizing the Built-in Stocks Command

Steps

Select the company name and go to the Data tab.Click on the Stocks icon.

Utilizing Built-in Stocks Command to Get Stock Prices in Excel

All of the company names now change to their official full form with the Stock symbol or the Ticker symbol with them.The company may be listed in multiple exchanges in different parts of the world at once. Excel will open a sliding side menu in that case.Select the stock exchange you intend to use. We chose NYC here for example.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

The range of cells is now filled with the company’s name with the appropriate ticker symbol.There is also an Add-column icon on the top corner of the cell. You can use this to get various stock information about different companies.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

Click on the add column sign.Click on Price.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

You’ll get a new column to the right with the updated value of all stocks presented.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

Click on the add column sign and select Change.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

You’ll get a new column with a percentage change of stock values.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

Click on the add column and select the Beta option.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

You’ll get the information about the stock’s beta value.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

Clicking the stock icon on the left of each row in the company column provides more information.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

If you want to refresh the stock data, go to the Data tab and click the Refresh All command. After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

How to Choose a Different Stock Exchange

Select the cells of which companies exchange you want to alter, then right-click and select Data Type.Click on Change.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

In the options panel, delete the ticker symbol and the identifier at the end of the Company Name.Click the search icon.Choose an exchange and click on Select.

After clicking the stock icon, you will notice that all of the companies names now change to their official full form with the stock symbol or the Ticker symbol with them.

Here’s the result.

Note:

Beta value denotes the volatility of a stock. If a stocks’ beta value is above 1, then the stock is more volatile.

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

Method 3 – Using the Stock Connector Add-in to Get Stock Prices

Steps

Input the company names in the range of cell B5:B7.From the Insert tab, click on the Get Add-ins icon on the Add-ins group.

Using Stock Connector Add-ins to Get Stock Prices in Excel

You will be taken to the Office Add-ins store.Search for Stock.In the search result, look for Stock Connector.Click on the Add button on the corner of the Stock Connector add-in.

Using Stock Connector Add-ins to Get Stock Prices in Excel

The stock connector add-in is now available on your Excel sheet in the Home tab.

Using Stock Connector Add-ins to Get Stock Prices in Excel

Copy the contents of cells B5:B7 to cells C5:C7.

Using Stock Connector Add-ins to Get Stock Prices in Excel

In the Home tab, click on the Stock Connector Launch icon.The Stock Connector will launch in the side panel.Select the company name cells in the worksheet.Click on Connect.

Using Stock Connector Add-ins to Get Stock Prices in Excel

You will be asked where would be the output value will be placed.Select cell C5 and click OK.

The stock price of Microsoft Corporation is now showing in cell C5.

Using Stock Connector Add-ins to Get Stock Prices in Excel

Repeat the same process for other companies.For some companies, the add-ins may ask you which stock exchange value of the selected company you want to show.For example, in our case, Apple Inc is listing multiple stock exchanges. We selected the US stock exchange.

Using Stock Connector Add-ins to Get Stock Prices in Excel

We have the stock prices of different companies in the range of cells C5:C7.The values will update every 30 seconds automatically in the cells.In the sliding panel, we can also see the percentage of their stock price increase.

Using Stock Connector Add-ins to Get Stock Prices in Excel

Download the Practice Workbook

Get Stock Prices.xlsx

Related ArticlesHow to Get the Current Stock Price of India in ExcelHow to Import Stock Prices into Excel from Google Finance

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

4 Comments Reply

RobJan 24, 2023 at 11:48 AM

Please help me find the following funds Stock data link

INVESTEC WORLD AXIS PCC INVESTEC CORE FUND IWCFSatrix MSCI World ETFSWIXSatrix RESI ETFSATRIXRESICoronation Global Capital Plus [ZAR] Feeder CPLSZNinety One Equity Fund NINEQ

No amount of permutations workRob Davidowitz

Reply

Rubayed Razib SuprovJan 26, 2023 at 1:58 PM

Greetings Rob,Thanks a lot for commenting on this article. Unfortunately, we managed to find only the last three companies and the INVESTEC CORE FUND IWCF among the companies you metioned in the database. Rest of them are not enlisted in the database. I have given the dataset link containing the stock informations of the Satrix RESI ETF SATRIXRESI, Coronation Global Capital Plus [ZAR] Feeder CPLSZ, Ninety One Equity Fund NINEQ, INVESTEC CORE FUND IWCF etc.

Thanks and RegardsRubayed Razib

Dataset Link:https://www.exceldemy.com/wp-content/uploads/2023/01/Get-Stock-Prices-in-Excel.xlsx

Reply

jzJun 30, 2024 at 6:24 PM

Why would a NYSE ticker (SNOW for Snowflake) not be included in the excel database? Is there a way to get around this?

Reply

Shamima SultanaJun 30, 2024 at 8:57 PM

Hello JZ,

NYSE ticker SNOW for Snowflake is included in Excel database.To get the data follow the steps below.Insert SNOW in any cell then click on Stocks from Data tab.

You will get all the data by selecting the fields.

RegardsExcelDemy

Leave a reply Cancel reply

相关推荐：