Realtime Currency conversion

%3CLINGO-SUB%20id%3D%22lingo-sub-2073067%22%20slang%3D%22en-US%22%3ERealtime%20Currency%20conversion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2073067%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20first%20post%20here%2C%20is%20it%20possible%20to%20set%20a%20cell%20to%20retreive%20live%20data%20such%20as%20currency%20rates%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20be%20able%20to%20keep%20a%20track%20of%20current%20conversion%20on%20a%20sheet%20I'm%20biulding.%3C%2FP%3E%3CP%3EFor%20instance%2C%20I%20would%20like%20to%20display%20my%20total%20balance%20which%20is%20Dollars%2C%20in%20GBP%20alongside.%3C%2FP%3E%3CP%3EIs%20this%20possible%2C%20and%20if%20so%2C%20could%20someone%20help%20me%20do%20it%20plase%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2073067%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2075449%22%20slang%3D%22en-US%22%3ERe%3A%20Realtime%20Currency%20conversion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2075449%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F934054%22%20target%3D%22_blank%22%3E%40JollyRoger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20Stock%20data%20type%20is%20available%20for%20your%20version%20of%20Excel%20you%20may%20pickup%20current%20GBP%2FUSD%20exchange%20rate%20by%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2076046%22%20slang%3D%22en-US%22%3ERe%3A%20Realtime%20Currency%20conversion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2076046%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EI%20was%20informed%20the%20data%20is%20available%20here%2C%20by%20copy%20a%20URL%2C%20however%20I%20am%20unsure%20which%20to%20copy.%20Also%2C%20once%20copied%20URL%2C%20then%20back%20in%20XL%20click%20DATA%20and%20click%20%22From%20Web%22%20and%20paste%20the%20address%2C%20however%20I%20can%20find%20no%20%22From%20Web%22%20button%2C%20perhaps%20it%20doesn't%20exist%20in%20free%20version%3F%3CBR%20%2F%3E%3CBR%20%2F%3ECurrency%20data%20is%20available%20Here%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.x-rates.com%2Ftable%2F%3Ffrom%3DGBP%26amp%3Bamount%3D1%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.x-rates.com%2Ftable%2F%3Ffrom%3DGBP%26amp%3Bamount%3D1%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20is%20quite%20simple%20what%20I%20am%20trying%20to%20acheive%20I%20would%20have%20thought.%3C%2FP%3E%3CP%3EHere%20a%20test%20sheet%20I%20made%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JollyRoger_0-1611082470097.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247536i42F3181B54CE167F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JollyRoger_0-1611082470097.png%22%20alt%3D%22JollyRoger_0-1611082470097.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EObviously%2C%20I%20want%20to%20convert%20the%20GBP%20to%20USD%20using%20real%20time%20data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, first post here, is it possible to set a cell to retreive live data such as currency rates?

 

I would like to be able to keep a track of current conversion on a sheet I'm biulding.

For instance, I would like to display my total balance which is Dollars, in GBP alongside.

Is this possible, and if so, could someone help me do it plase?

5 Replies

@JollyRoger 

If Stock data type is available for your version of Excel you may pickup current GBP/USD exchange rate by it.

@Sergei BaklanI was informed the data is available here, by copy a URL, however I am unsure which to copy. Also, once copied URL, then back in XL click DATA and click "From Web" and paste the address, however I can find no "From Web" button, perhaps it doesn't exist in free version?

Currency data is available Here: https://www.x-rates.com/table/?from=GBP&amount=1

 

It's is quite simple what I am trying to acheive I would have thought.

Here a test sheet I made:

JollyRoger_0-1611082470097.png

 

Obviously, I want to convert the GBP to USD using real time data

 

 

 

@JollyRoger 

The connector is here

image.png

First time it will ask authorization, select Anonymous. After that click Transform, Power Query editor will be opened. Rename the query and in UI editor transform the table to keep only US dollar exchange rate. Load resulting table into any suitable place of your workbook.  Open query properties and select update with workbook opening

image.png

With that formula for the conversion will be like

=F3*GBP2USD[Rate]

If use Stock or Currency data type you'll have same result much easier, just type in any call USD/GBP, click on icon and extract rate field.

image.png

It will be updated automatically every 15 minutes as I remember, but not sure.

Both variant are in attached file.

@Sergei BaklanWoW! Thats great Sercei, I'll give it a try later

@JollyRoger , glad to help