Find Indexes, Yields, Commodities, and Currency Pairs in Excel Stock Data
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.

- 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.
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.
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.
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.
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.
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.
Choose Data > Refresh All to update supported linked values. Repeat the lookup for each index, yield, commodity, or currency pair you need.
Import unsupported market data from a financial provider
Use a provider or exchange feed when Excel's linked data types do not cover the required instrument or field.
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.

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.




