Data Import & Export

Find Indexes, Yields, Commodities, and Currency Pairs in Excel Stock Data

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

Determine whether Excel can provide linked data for specific market indexes, Treasury yields, commodities, and currency pairs, and find alternatives for unsupported instruments.

Can Excel Stock Data Include Indexes, Yields, Commodities, and Currency Pairs?
Product
Microsoft Excel Stocks linked data type
Device & OS
not provided
Scenario
The user wants market information in a spreadsheet that can be updated without manually looking up each value.
Observed behavior
Excel's Stocks data type may not cover every requested instrument, including the Shanghai Composite, DXY, Russell 2000, Treasury yields, and corn prices.
Before you start

List the exact instruments and identifiers you need, including the exchange, maturity, or currency pair where relevant. Check whether your Excel version and account support linked data types and the data connections you plan to use.

Solution 1Recommended

Check Excel's linked data types for each instrument

Use Excel's data selector to see whether its available provider recognizes an instrument and exposes the field you need.

1
Enter an instrument

In an Excel worksheet, enter the instrument name or symbol in a cell. Include an exchange or other identifying detail if the name is ambiguous.

2
Apply a data type

Select the cell, then choose Data > Stocks. For currency pairs, check whether Data > Currencies is available in your Excel version and try that data type instead.

3
Verify the match and field

If the Data Selector opens, choose the correct match. Select the linked cell and use the Insert Data button to inspect available fields, such as price or another relevant value.

4
Refresh the data

Choose Data > Refresh All to update supported linked values. Repeat the lookup for each index, yield, commodity, or currency pair you need.

Coverage varies: A recognized name does not guarantee that the desired field is available. Check the instrument, units, source, and whether the value is current or delayed.
Free Microsoft Office alternative

Work with imported market data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format support, making it easier to move existing workbooks and review imported market data. It does not fix Excel's linked data coverage or guarantee equivalent market feeds.

Open CSV files containing exported index, yield, commodity, or currency dataCompatible with Microsoft Excel formats such as XLS and XLSXUse a familiar spreadsheet interface to organize and analyze valuesMove existing Office files into a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does Excel Stocks include every major index or commodity?

No. Coverage depends on Excel's available data provider and the instrument. Enter the name or symbol, select Data > Stocks, and check the Data Selector and available fields.

How can I check a currency pair in Excel?

Enter the pair in a worksheet and try Data > Currencies if that data type is available. Select the correct match and use the Insert Data button to see the available fields.

Can imported market data update with Refresh All?

A supported provider connection may update through Data > Refresh All. A static CSV download will not automatically obtain new values; you must replace or reimport it unless the source file is updated separately.

Where can I find Treasury yields or corn prices if Excel does not list them?

Check a reputable financial data provider, financial publication, or the relevant exchange for the specific yield or commodity contract. Confirm the maturity or contract, units, update frequency, and available export or connection options.