Forum Discussion

QWeelon's avatar
QWeelon
Brass Contributor
Sep 18, 2021

Generalized currency conversion

Dear community!   I have a modified setup as figure below. I want to generalize my currency conversion to SEK from different currencies (not limited to the ones listed below). In other words, I wan...
Excel
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 18, 2021

    QWeelon Almost correct. You need to make the references to the lookup array and the return array absolute, using $ signs.

    Removed the table style in the attached workbook, so that you can see what I mean. Though, I'd recommend to learn about structured tables. The will make your Excel-life a lot easier.

     

    Trevlig helg!

QWeelon's avatar
QWeelon
Brass Contributor
Interesting. I'm currently using the Excel Stock function for currency data, but it requires manual updates to acquire the latest (15 min delay) the latest rates.

I'll have to look further into this to determine if this might be favourable for me!

Thanks!
SergeiBaklan's avatar
SergeiBaklan
MVP
Sep 18, 2021

QWeelon 

If you need current exchange rate that doesn't work. STOCKHISTORY() has an option to show it on open, close, high and low for each day in interval.

 

Stock data type is updating constantly, thus you have the latest exchange rate for now. Not sure about delay in data, perhaps yes, 15 minutes. On the other hand you can't use currency pair as parameter here, it is predefined.

 

As for the refresh, option is coming for Excel. Not it is available for Beta version, it looks like

Resources