Microsoft Excel使检索股票市场价格变得非常简单。它的Stock数据类型连接到在线数据源，允许您访问可以使用和刷新的丰富、有趣的信息。让我们看看如何在 Excel 中获取股票报价^{(Stock Quote in Excel)}。

在 Excel 中获取实时股票价格

您可以使用MSN MoneyCentral 网络查询在Excel中检索股票报价——但现在情况发生了很大变化。新系统提供了丰富、有趣的信息，您可以立即使用和刷新！这样做的方法是这样的：

1. 创建表
2. 输入股票代码
3. 让Excel为您的条目找到匹配项
4. 添加一列以提取更多信息
5. 将表中的条目隔开

由于像股价这样的数据是不断变化的，因此您始终可以通过刷新连接来获取最新数据。

1]创建一个表

为此，请转到“插入^(Insert)”选项卡并选择“表格^(Table)”。

要将股票价格添加到Excel工作表中，请将文本转换为“股票”数据类型。之后，您可以选择另一列来提取相关详细信息，例如股票价格、价格变化等。

在每个单元格中输入^(Enter)描述公司名称或基金名称的文本。或者，您可以输入股票代码。

选择单元格并转到“数据^(Data)”选项卡。然后点击“股票^(Stocks)”。

如果Excel发现您在单元格中输入的条目与其在线资源相匹配，它会很容易地将文本转换为Stocks数据类型。当您可以看到“股票的链接记录图标^{(Linked record icon for stock)}”时，可以验证这一点。

2]添加^(Add)列以提取更多信息

现在，选择一个或多个具有数据类型的单元格。应该会出现“添加列^{(Add Column)}”按钮。

看到后，单击该按钮，然后单击字段名称以提取更多信息。例如，对于股票，您可能有兴趣选择最重要的决定因素——价格^(Price)。

再次单击“添加列^{(Add Column)}”按钮以添加更多字段。例如，您可以跟踪股票在几周、几个月或几年内的表现。

要分隔表中的条目，请选择所有列并转到“主页^(Home)”选项卡。

然后，转到“单元格^(Cells)”部分并点击“格式^(Format)”向下箭头按钮。

选择“自动调整列宽^{(Auto-fit column width)}”，您就完成了！

非常酷！

Get real-time Stock Prices in Excel using Stock Quote

Microsoft Excel makes іt really simple to retrieve stock market prices. Its Stock data type is connected to an online data source that allows you to access rich, interesting informatiоn that you can work with and refreѕh. Let’s seе how tо gеt Stock Quote in Excel.

Get real-time Stock Prices in Excel

You can retrieve stock quotes in Excel by using the MSN MoneyCentral web query – but things have changed a lot now. The new system provides rich, interesting information that you can work with and refresh in an instant! The way to do it is like this:

1. Create a table
2. Enter a ticker symbol
3. Let Excel find the match for your entries
4. Add a column to extract more information
5. Space the entries in the table

Since data like the share price is constantly changing, you can always get the latest data by refreshing the connection.

1] Create a table

For this, go to ‘Insert’ tab and select ‘Table’.

To add a stock price to your Excel worksheet, convert text into the ‘Stocks’ data type. Following that, you can choose another column to extract relevant details, like the stock price, change in price, and so on.

Enter the text that describes the company name or fund name into each cell. Alternatively, you can enter a ticker symbol.

Select the cells and go to the ‘Data’ tab. Then click ‘Stocks’.

If Excel finds a match between the entries you’ve made in the cells, and its online sources, it will readily convert the text to the Stocks data type. This can be verified by when ‘Linked record icon for stock’ becomes visible to you.

2] Add column to extract more information

Now, choose one or more cells with the data type. The ‘Add Column’ button should appear.

When seen, click that button, and then click a field name to extract more information. For example, for stocks, you might be interested in picking up the most important determinant – Price.

Click the ‘Add Column’ button again to add more fields. For instance, you can track the performance of a stock over a period of weeks, months, or years.

To space the entries in the table, select all columns and go to ‘Home’ tab.

Then, go to the ‘Cells’ section and hit the ‘Format’ down-arrow button.

Select ‘Auto-fit column width’ and you are done!

So cool!

Related posts

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Excel中使用Automatic Data Type feature

• 如何在Excel中创建Organization Chart

• 如何在Microsoft Excel中使用HLOOKUP function

• 如何更改默认File Format，用于保存Word，Excel，PowerPoint

• 如何将一列拆分为Excel中的多列

• Microsoft Excel Tutorial，用于初学者

• 如何在Excel工作表中Freeze and Split Panes

• 如何在一页上打印Excel or Google Sheets中所选单元格

• 如何在Excel到Insert and Calculate Formulas和Functions

• 如何计算Excel中的百分比increase or decrease？

• 如何在Excel中添加Country or Area Code至Phone Number List

• 如何在Windows 11/10中创建Tournament Bracket

• 如何修复损坏的Excel Workbook

• 运行时error 1004，不能在Excel运行Macro

• Convert CSV至Excel（XLS or XLSX）在Windows 10中使用Command line

• 如何Merge and Unmerge cells在Excel