Excel - Get a currency exchange rate using the Currencies data type

With Microsoft Excel's Currencies data type, you can quickly get and compare exchange rates from around the world. In this video, you'll learn how to enter currency pairs, convert them into a data type, work in tables, and extract more information for robust data.

Chapters:
0:00 Intro
0:32 Excel versions
0:54 Create a table
1:35 Currencies data type
3:07 Test accuracy

Other Data Type videos by Chris Menard

#msexcel #microsoftexcel #chrismenard #chrismenardexcel #chrismenardtraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[MaleneLafont]

after your lessons I knew a lot of great trading methods and using it every day! Thank you, man

[MrTururu]

Exactly what I needed... thank you so much! Great Video!

[sbslipknot]

Brilliant, i've been using 3rd party api keys with issues for years. all this time excel had the function :)

[FS-]

worth to subscribe to this noble's channel,
thank you so much

[prnktr]

Can I also get the historical exchange rate for a specific date, which could be different for each row?

[Konginho]

Great video! Is there a way I can get both buy rates and sell rates? Thanks.

[pablohellmund]

is it possible to do this in WPS office ?

[BIRD-tx]

Is there anyway we can choose the date of the currency?

[stanTrX]

Nice. Can you push it to force update, without even opening this excel manually?

[gamershideout-kevn]

Hello can i get historical data of currency pairs in 5 minutes interval using this?

[HarmonieNJeune]

Hello, nice video, very instructive.
I was wondering if you could help me, in my excel I only have "Stock" and "Geography", I don't see any other data type... How is that possible?

[Crawling_Sloth]

I dont seem to have the add colum box appear

[ozzythepolar]

Thanks for the video, how can we add "Convert to currency pairs" data type into excel, only "Stocks" and "Geography" is available on mine

[mohammadtarek]

Thanks for the video! Can I use it also to get for minutes-frequency for the last year or so?

[julianevansheldon]

Once the price field is populated, how can I ensure the data gets updated periodically?

[mohdramdhanmusa]

I have a problem to add the column after click the data. Help me. Thanks.

[jakalil]

Is there a way to convert the exchange rate across an entire sheet or workbook? For example, if I have an Income Statement on Tab 1 and a Balance Sheet on Tab 2, all in a foreign currency and I want to convert to USD, can I apply a universal conversion across either tab or on the entire workbook without going into each individual cell and hard-typing a formula?

[playakaan]

Hi Chris, Thanks a lot.
Here is my problem ... I created the currencies board, say USD/EUR, USD/CHF, USD/GBP A1:A3 and the values B1:B3. I named the cells B1 "EUR", B2 "CHF" and B3 "GBP". Fine, I have my currencies' values on the spot.
Now in the spreadsheet, in connection of each of my assets I have the currency each belongs to, CHF, USD, GBP, EUR. When I calculate the actual market value I would like to also convert to my reference currency, whatever it is. How can I take the text cell showing the 3 letters currency to match/retrieve/understand that it should the take the name+its value and multiply/divide to get the value in my reference currency?

Thanks

[abdullahmahmud]

@Chris, thanks for this video. Do you know if i need a rate from previous years like 2015, how i can get from excel?

[Toad_Nugget]

Hi there!

I really need some help. In my table I have 4 columns. Column 1 is ID/Name, Column 2 is Currency Code (EUR, GBP, BRL, JPY), Column 3 is Payment Due in USD, and column 4 is Payment due in local currency.

How do I make it so Column 4 exchanges the rate of the USD in Column 3 to the corresponding currency code in column 2? Please help me! I have to get this sorted within a day or two!!!

Any help is greatly appreciated.