Forum Discussion

calof1's avatar
calof1
Iron Contributor
Dec 12, 2019
Solved

Import Currency Prices into Excel

Hi,

 

I have seen a few examples of live data imports for currency values into excel. Is there a free and easy way to do this. For example so i can track AUD price to USD?

 

Open to any help and suggestions.

 

Many thanks,

admin
BI & Data Analysis
Charting
developer
excel
Excel for web
Excel on mobile
Formulas and Functions
Macros and VBA
power bi
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Dec 12, 2019

    If it's just current exchange rates you want and if you have Office 365 then on the Data Tab you will see Stock Types. Just type in AUD/USD in a cell then click this

     

2 Replies

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Dec 12, 2019

    If it's just current exchange rates you want and if you have Office 365 then on the Data Tab you will see Stock Types. Just type in AUD/USD in a cell then click this

     

    • calof1's avatar
      calof1
      Iron Contributor
      Dec 13, 2019

      HiWyn Hopkins 

       

      Thanks for the information. This works well for my needs.

       

      Many thanks,

Resources