Tech

Display stock exchange rates in Excel – PC-WELT


In Excel, cells can be populated with current stock market prices. In this way, you can keep an overview of your portfolio and interesting stocks regardless of your bank and apps.

In earlier versions of Excel, you had to use services such as

www.ariva.de/dax-30
or

www.msn.com/dede/finanzen
go. There is a more convenient function for this purpose in the current version of Excel.

That’s how it’s done:

1. In a cell, insert the name or the stock code of the company whose price you want to call up. You can also fill several cells in a column with company names.

The Microsoft 365 version of Excel offers a convenient way of displaying current share prices and other data on listed companies.

Enlarge

The Microsoft 365 version of Excel offers a convenient way of displaying current share prices and other data on listed companies.

© IDG

2. Select the cell or cells with the name and select “Data” in the ribbon menu and then the “Shares” command in the “Data types” area. If Excel was able to clearly identify the company, it replaces the cell contents with the official company name including the stock exchange and stock exchange abbreviation. For example, the entry “Paypal” is replaced by “PAYPAL HOLDINGS, INC. (XNAS: PYPL) “. In the event that Excel cannot clearly assign the name to a stock corporation, it inserts a question mark in the cell and opens the “Data selection” area on the right. There you can usually select the one you are looking for from several companies. Excel obtains this data from the service company

Refinitive.
This suggests that the dataset of public companies is large. So you should find a course for most companies. If the selection is successful, Excel places a stock market symbol in the cell.

3. Select the cell you have just edited and now click on the data selection field which is then displayed directly next to the cell. In a context menu, you can choose from around 30 dates, which are, however, named in English. For the company’s current market price, select “Price”. You can also choose from data such as 52-day high or low, the price change since the start of the stock market in percent or absolute and many other data. Excel inserts the selected data into the next free cell on the right. A naming of the data, such as “course”, is not inserted. The stock exchange prices come with a delay of 15 minutes, which is the usual time span for free offers.

You can also use the “data selection” function to select the stock exchange for the price display for many companies.

Enlarge

You can also use the “data selection” function to select the stock exchange for the price display for many companies.

Select stock exchange:

If Excel automatically recognizes the company name when you click on “Shares” (step 1), it also automatically selects a stock exchange. If this does not meet your expectations, just try again. Before doing this, add any addition to the company name, such as Frankfurt. Excel then does not find a suitable company and shows a search option on the right under “Data selection”. Here you can often select different stock exchanges for the same company.

Update courses:

With the key combination Ctrl-Alt-F5 you update all data fields in the worksheet and get new courses.

Tip:

The free stock market software

Daxa chart private
analyzes selected stock exchange prices for you and manages your share portfolio.

Tags

Related Articles

Back to top button
Close
Close