How can I keep prices updated at Excel

Mia Tone 20 Reputation points
2026-10-19T07:58:43.25+00:00

Hi everyone, I would like to create simple sheet to track cryptocurrency prices in Turkish lira (TL/TRY). I usually check prices on Paribu, but I’m unsure how to bring that data into Excel and refresh it.

Would Power Query’s “From Web” option work for this or would I need an API? I only need occasional updates not a live trading feed.

Microsoft 365 and Office | Excel | Other | Other
0 comments
Answer accepted by question author
TaoLi 119.5K Reputation points Independent Advisor
2026-10-19T14:26:41.61+00:00

Please try this API endpoint instead: https://api.paribu.com/market/ticker

You can also check Paribu's official API documentation here: https://docs.paribu.com/api

In Excel, go to Data >> Get Data >> From Web and enter the new URL.

Disclaimer: These links point to non-Microsoft websites. The pages appear accurate and safe, but please be careful with any third-party advertisements or download links.

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. TaoLi 119.5K Reputation points Independent Advisor
    2026-10-19T09:51:37.6066667+00:00

    Hi, Paribu may not display its prices as a table Excel can recognize.

    Try Excel >> Data >> Get Data >> From Web, then enter:

    https://www.paribu.com/ticker

    Disclaimer: These links point to non-Microsoft websites. The pages appear accurate and safe, but please be careful with any third-party advertisements or download links.

    Select Transform Data >> To Table, expand the Value column, and select last for the latest price. Then click Close & Load.

    You can update prices using Data >> Refresh All.

    Microsoft's guide: https://support.microsoft.com/en-us/excel/import-data-from-the-web-using-the-web-connector

    Was this answer helpful?

  2. Mia Tone 20 Reputation points
    2026-10-19T08:00:01.3466667+00:00

    I cant find it there :( Data is not showing at me.?

    Was this answer helpful?

    0 comments

  3. AI answer

    2026-10-19T07:59:00.8+00:00

    Yes. Power Query’s From Web option is designed for importing data from a website into Excel, and the imported data connection can be refreshed later to pull updated values.

    A practical approach is:

    1. In Excel, use Data > Get Data > From Web.
    2. Enter the website address that contains the cryptocurrency prices.
    3. Use the web connector’s table detection tools to select the data you want.
    4. Load the result into the workbook.
    5. Refresh it when needed:
      • Data > Refresh All to refresh all workbook data
      • Alt + F5 to refresh selected data
      • Ctrl + Alt + F5 to refresh the workbook

    If the website data is available in a table that Power Query can detect, From Web can be enough for occasional updates. If the site does not expose the data in a way the web connector can import cleanly, then an API would be the more reliable option.

    For occasional updates, Excel also supports automatic refresh options for external data connections:

    • Refresh when the workbook opens
    • Refresh every set number of minutes

    To configure that:

    1. Select a cell in the external data range.
    2. Go to Data > Queries & Connections > Connections.
    3. Right-click the query and select Properties.
    4. On Usage, enable Refresh data when opening the file and/or Refresh every.

    If the query is edited in Power Query Editor, Home > Refresh Preview updates the preview and local cache, but refreshing from the worksheet updates the worksheet query result.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.