+ Reply to Thread
Results 1 to 4 of 4

Insert real time currency exchange rates in Excel 2019

  1. 08-02-2022, 04:09 AM #1
    liekebreure
    liekebreure is offline
    Registered User
    Join Date
    07-20-2022
    Location
    Tilburg, Netherlands
    MS-Off Ver
    2010
    Posts
    25

    Insert real time currency exchange rates in Excel 2019

    Hello,

    Does somebody know how I can insert real time currency exchange rates in Excel 2019 (USD/EUR). On Google I can only find solutions for Office 365.

    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 08-02-2022, 04:11 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,068

    Re: Insert real time currency exchange rates in Excel 2019

    It might be possible with Power Query if you can find a suitable exchange rate website. Which do you use?

    Please go back and mark your other thread as solved. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-02-2022, 04:21 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,068

    Re: Insert real time currency exchange rates in Excel 2019

    So the attached uses this site:

    https://www.exchangerates.org.uk/Dol...sion-page.html

    The query is simply set up using Data | From Web ... and entering the URL, then loading the Handy Conversion Table to PQ. I have set the query to refresh once a minute and when the file is opened.

    Does this help?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-02-2022, 04:32 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,068

    Re: Insert real time currency exchange rates in Excel 2019

    I see you've marked this as solved - thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Function to obtain currency exchange rates - How do I make it work?
    By carlito2002wgn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2019, 10:57 PM
  2. Best source for importing currency exchange rates using PQ?
    By kao in forum Excel General
    Replies: 3
    Last Post: 11-30-2018, 12:52 PM
  3. [SOLVED] Pulling Exchange Rates into Excel in 2017? How?
    By jessdaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2017, 10:00 AM
  4. IF or TRUE statement for choosing the currency to calculate exchange rates
    By Bankolao in forum Excel General
    Replies: 2
    Last Post: 09-17-2016, 05:33 AM
  5. Match up currency exchange rates and calculate
    By zl068565 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2013, 02:46 PM
  6. Help in changing 4 currency rates in real time
    By mansell in forum Excel General
    Replies: 0
    Last Post: 07-23-2012, 02:33 PM
  7. matching dates and currency exchange rates
    By LoriL in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-08-2009, 06:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1