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 ...
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

     

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