Currency Converter

I am trying to get the fx rates for the past 30 days. I want to set USD as the base and get the fx rates for all other currencies. I tried with the ECB repository, but it seems to have a very limited set of currencies. Can someone help with this, I am looking for daily fx rates for the past 30 days until today. Is there a way we can pull it from Google Finance or xe.com or other reliable sources?

Thanks in advance!

Custom Tools

Accepted answers

Luke_C

Hi @nischalvadari

It's very dependent on the site and how the data is stored there. I'm not as familiar with those sites, on first glance I didn't see any way to download the data, but I'd definitely suggest playing around with the tool and seeing if you can get it to work.

If you're all set please accept the solution, otherwise let me know if there are other questions!

All comments

Luke_C

Hi @nischalvadari

I usually find that yahoo finance has a good population, and it also has easily downloadable data so you don't have to constantly update your inputs. See attached as an example.

In the text input, I put my currency pair (i.e. EURUSD).
This feeds into a formula tool that populates the URL of the yahoo finance download link (equivalent to clicking the download button on this page)
The download tool takes that link and downloads the data. In this case yahoo finance lets you download the last year of rates, but you can filter as needed once you have the data read in.
The text to columns tools transform the data into a readable format, then the dynamic rename/select tool clean up the columns.

Take a look and let me know if you have any questions.

New Workflow3.yxmd

nischalvadari

Thank you very much Luke. This was exactly what I was looking for. My input has a column with all the various currency codes. (sample shown below)

Country	Currency
Afghanistan	AFN
Albania	ALL
Algeria	DZD
Euro Member Countries	EUR
Angola	AOA
Argentina	ARS
Armenia	AMD
Aruba	AWG
Australia	AUD
Azerbaijan	AZN
Bahamas	BSD
Bahrain	BHD
Bangladesh	BDT
Barbados	BBD
Belarus	BYN

Is there a way I can modify the workflow you had attached, so I can map the currency code and get the output as it was on your workflow? Also, how do I set the history to hold the past 30 days only (not that a longer history does any harm 🙂 )

Alankrita-Shukla

Hi @Luke_C

I used the workflow with 'https://query1.finance.yahoo.com/v7/finance/download/'+[Currency]+'=X?period1=1651108122&period2=1682644122&interval=1d&events=history&includeAdjustedClose=true' in URL column it is giving me correct value for INR only. If I have to convert AUD it is not giving me correct values. Am I using wong URL, if yes could you please help me with the correct one?

Luke_C

Hi @Alankrita-Shukla

The data pulls from yahoo finance, so I'd check out what values are there. I've seen it struggle with some less common currency pairs.

eahsanul

Hi Luke,

the amounts i need to convert are in a different output, as the text input does not have any input anchor how can i ensure the data in my file get converted into USD currency

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335