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 ~50 stocks traded on the Tokyo stock exchange, which is not covered by Microsoft?

excel
office 365
Office Scripts

2 Replies

  • 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.

    • OferP2023's avatar
      OferP2023
      Copper Contributor
      Mar 09, 2026

      Thanks for the reply.

      I have tried it, and for some reason received the following:

      “We couldn't authenticate with the credentials provided. Please try again.”

      I was not able to get the data, that is why I asked for is a working spreadsheet which I can use.

      Thanks again,

      Ofer