Forum Discussion

OferP2023's avatar
OferP2023
Copper Contributor
Mar 09, 2026

Tokyo Stock Exchange data

Does any one know, and can share, a sample excel file that can import updated information (ticker, name, last price, dividend yield, daily high and daily low and analysts average target price) for ~5...
excel
office 365
Office Scripts
Olufemi7's avatar
Olufemi7
Iron Contributor
Mar 09, 2026

HelloOferP2023​,

Excel’s Stocks data type does not include all exchanges or financial metrics, and some Tokyo Stock Exchange tickers or fields such as dividend yield and analyst target price may not be available.

This feature is available in Microsoft 365 versions of Excel. If the required data is not supported, a common approach is to keep a list of tickers in Excel (for example 7203.T for Toyota) and use Data > Get Data > From Web with Power Query to retrieve information from a financial website. The query can then be refreshed to update the data for multiple stocks.

If additional metrics are required, some users also use third party Excel add ins that provide financial data functions, but those are optional and not Microsoft services.

If this helps, please consider marking the reply as the answer so it may assist others with a similar question.