+3 votes
104 views
share prices in Excel - this is how it works

in Retrieve Office by (551k points)
reopened | 104 views

1 Answer

+4 votes
Best answer

How to get stock quotes in Excel
1st step:
2nd step:
3rd step:
4th step:
5th step:
quick start Guide

This article will teach you how to get stock quotes in Excel..

image image

Microsoft Excel is an indispensable spreadsheet software in the home office and at work. Most PC users have already worked with the tool and were able to get to know the basic functions. But did you know that you can even query the current value of stocks in Excel with just a few clicks of the mouse? This article explains how to import current stock prices into Microsoft Excel.

How to get stock quotes in Excel

Please note that the retrieval of the share information only works if there is a connection to the Internet.

Follow our step-by-step instructions or take a look at the quick start guide .

1st step:

image
Open Excel and insert the companies whose share prices you want to query. You can use the company name , the fund name or the ticker symbol for this. Enter only one name per cell.

2nd step:

image
Select the cells you have created and create a table under " Insert " and " Table " in order to simplify the export of the data later. Querying the share prices also works without a table.

3rd step:

image
Now highlight the table or the stock names you created and switch to the " Data " tab and then click on " Stocks " to convert the text to the "Stocks" data type.

4th step:

image
If you have done everything correctly, the names you entered will now be displayed as share names and a share symbol will be placed in front of each company.

5th step:

image
Click the stock icon to view the company's stock prices. In addition to the share price, further information on the share and the company is displayed here.

quick start Guide

  1. First, you need to enter text into a cell that includes a company name, fund name, or ticker symbol. For example, we use the name " msft " for information about Microsoft . You should use one name per cell.
  2. You should then create a table so that you can later export the data more easily. To create an Excel table, select the " Table " option under " Insert ".
  3. Now select the cells for which you want to get the rates.
  4. Under " Data ", click " Stocks ". The names entered are automatically converted to the data type "shares" and a share symbol is placed in front.
  5. For more information about the stock price, click the stock icon .

by (3.5m points)

Related questions

+5 votes
1 answer
asked Dec 30, 2021 in Office by backtothefuture (551k points) | 84 views
+3 votes
1 answer
asked Jan 3, 2022 in Office by backtothefuture (551k points) | 136 views
+3 votes
1 answer
asked Dec 29, 2021 in Office by backtothefuture (551k points) | 76 views
+5 votes
1 answer
asked Dec 24, 2021 in Office by backtothefuture (551k points) | 102 views
+3 votes
1 answer
Sponsored articles cost $40 per post. You can contact us via Feedback
10,632 questions
10,764 answers
510 comments
3 users