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

3 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

      • Olufemi7's avatar
        Olufemi7
        Iron Contributor
        Mar 09, 2026

        Hello OferP2023​,

        Thank you for the clarification.

        The message “We couldn't authenticate with the credentials provided” commonly occurs when Power Query has stored credentials for the website that are not compatible with the authentication method required by the site.

        You can resolve this by clearing the stored permissions and reconnecting.

        Open Excel and go to Data > Get Data > Data Source Settings. Locate the website used in the query, select it, and choose Clear Permissions. After that, run the query again. When Excel prompts for authentication, select Anonymous. Public financial data pages typically require Anonymous access.

        Power Query stores credentials at the domain level. If an incorrect authentication method was selected earlier, the query may continue to fail until the stored permissions are cleared.

        For Tokyo Stock Exchange data, you can maintain a list of tickers in Excel such as 7203.T for Toyota and then use Data > Get Data > From Web to retrieve the information. Once configured, the query can be refreshed to update multiple stocks automatically.

        Microsoft documentation about connecting to web data with Power Query is available here:
        learn.microsoft.com/en-us/power-query/connectors/web/web

        Please also note that some financial websites restrict automated queries. In those cases Power Query may not be able to retrieve the data even though the page opens normally in a browser.

        If this information helps resolve the issue, please consider marking the reply as the answer so it may assist others in the community.