How To Pull Stock Data Into Excel

There are various websites and apps which provide us Market Data for all the securities, and bolt traded in the stock marketplace. But it would exist very handy if we could get all this data directly into our Excel Workbook. This would help us for better calculation, analysis, and visualization of the data, in course of tables, charts, and graphs.

Excel provides us with the characteristic to fetch and display the latest stock marketplace information easily with built-in tools.

In this tutorial, we will guide you pace-by-footstep, and so you can easily fetch stock market data in your Excel canvass.

What Stock Market Data can be fetched in Excel?

Excel's built-in 'Stock Market' tool supports many data parameters which can exist fetched directly. These parameters are listed below:

01. 52 week high	02. 52 week low
03. Beta	04. Currency
05. Alter	06. Change (%)
07. Modify Extended Hours	08. Change (%) Extended Hours
09. Name	10. Clarification
eleven. Official proper name	12. Exchange
xiii. Exchange abbreviation	xiv. Headquarters
15. Industry	16. Instrument Type
17. Employees	18. Last traded fourth dimension
nineteen. Market cap	xx. Ticker symbol
21. Open	22. Close
23. High	24. Low
25. Price	26. Previous Close
27. Price (Extended Hours)	28. P/Due east
29. Shares outstanding	thirty. Volume
31. Volume average	32. Year incorporated

All Data Options of Stock Market using Excel

Important Points to Note:

You demand to have an active Net Connexion to fetch data direct into your Excel canvass.
Disclaimer: Financial market information is provided "as-is" and not for professional or trading purposes or advice.

Steps to fetch Fiscal Market Data in Excel

Let's get started with using the Stock Market Data add-in to pull stock market data in Excel

Stride i. Organize the Data – Ticker Symbol

Type the particular Ticker Symbol or company proper noun for which you want to fetch data

Note: We are hither using the Ticker symbol and recommend y'all to practise the same, because they are easy to write and too gives less possibility to error as compared to entering the visitor name

Stock Market Data in Excel - Sample data — Stock Market Information in Excel – Sample data

In our example to a higher place, we are finding fiscal data of these companies, traded on dissimilar exchanges across the globe —

AAPL – Apple Inc.
TSLA – Tesla Inc.
TCEHY – Tencent Holdings Ltd.
RELIANCE -Reliance Industries Ltd.
TCS – Tata Consultancy Services

Step 2. Select Ticker and Catechumen To Stock

Select the Ticker symbol or symbols to get data.
Navigate to 'Information' in the above tools tab (Home tab)

Converting Ticker Symbols to Stocks in Excel — Converting Ticker Symbols to Stocks

Click on 'Stocks' to convert the input ticker symbols to Stocks. [as show below the Excel volition automatically convert and map the data to the exchange which is most popular in case of multiple substitution trading/list]

Converted Ticker to Stocks in Excel — Converted to Stocks

Unable to convert to Stocks

In case, after following the above pace, your ticker symbol wasn't converted to stock, information technology's probable because the stock is registered on multiple exchanges. In this case, yous encounter an info symbol before the ticker.

Then click on the info symbol to reveal a side pop-upward where you will be presented with choice to select the particular commutation.

Stride three. Select the Stock parameter for Data

Excel supports diverse Finance Market information parameters to select from, which are shown in the above tabular array hither.
To select particular data parameter like Loftier, Low, Volume, Toll, etc.
Select all the ticker symbols (converted to stocks) and on hovering over them you volition exist presented with a symbol of data (of somewhat like a volume)
Click on the icon and select the parameter you want to fetch information of.

Selecting Stock Market Data Parameter in Excel — Selecting Stock Market Data Parameter

Final Sheet with all the required data. [You may choose any number of data parameters as per your requirement]:

Y'all may find in our above example that 52-week loftier for Reliance is given every bit #FIELD! – this means that Excel congenital-in tool cannot fetch information for this item field. You can verify if the stock ticker is right or if you need to add the substitution data before the ticker symbol past going through the information that Excel has on your market.

Conclusion

That's It! You can get Finance or Stock Marketplace data in diverse parameters easily by following the above step-by-stride procedure now in your Excel sheets.

We promise yous learned and enjoyed this lesson and we'll exist back soon with another awesome Excel tutorial!