API for currency exchange rate

Hi,

I want to make a macro which should convert multiple currencies into US dollar on the current date. I know we can use download tool to get it. However, I am finding difficulty in finding API address or URL address which we can put in formula tool.

Any help would be appreciated!

API

Download

Accepted answers

Luke_C

Hi @Rahul_Analyst

Got it, just add a filter tool to take care of it. Each currency comes back in as it's own table, so not surprising they're getting unioned like that. Please consider accepting as the solution if this works. You could probably make the URL more dynamic if needed, for reference the dates in the URL are in epoch format (there are resources here on how to convert to normal dates if needed).

For your point on the API, you would need to register with whatever the API provider is and get your own API token.

FX rates.yxmd

All comments

Emil_Kos

Hi,

I would recommend starting with watching a video about API:

https://www.youtube.com/watch?v=7zbMHdXS-cQ

This webinar should help you solve your problem.

Luke_C

Hi @Rahul_Analyst

While not exactly an API, Yahoo Finance works nicely for this last I checked. I would doubt that you'll find a free API service to do this. Take a look at my solution from the below post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Currency-Converter/td-p/748383

Rahul_Analyst

@Luke_C , Thanks for the response. I got a few queries using it.

1) I could see data for upcoming days and months in output, is it pridicting the fx rates ?

2) It is creating new headers for different pairs. In this example, another header is created for CADUSD (record no. 262). why ? how to get only one header ?

3)If I verify fx rates from alteryx and on website by the link given by you. It is not matching. Records -238, here EURUSD vale is 1.190.. but on website 0.90... why is it ?

Luke_C

Hi @Rahul_Analyst - the dates there are last year, does that resolve the questions?

For the CAD, I'm not seeing that? Can you share your workflow?

Rahul_Analyst

Hi @Emil_Kos, thanks for the respnse. I treid using the API link given in the video. However, it is giving me error.

This is the error-

{
"success": false,
"error": {
"code": 101,
"type": "missing_access_key",
"info": "You have not supplied an API Access Key. [Required format: access_key=YOUR_ACCESS_KEY]"
}
}

Rahul_Analyst

@Luke_C , got it, I did not pay attention earlier. I want to get latest rates when I run the workflow. is it possible ? the workflow is same as you provided. I did not make any change.

Luke_C

Hi @Rahul_Analyst , the workflow is a year old.. you may need to tweak the URL. I believe the highlighted part controls the date. You should be able to navigate to the yahoo finance page for a currency and find the new URL. Let me know if you have any issues.

Rahul_Analyst

@Luke_C , thanks, by changing the portion, you highlighted, it worked. However, again I got another header in between. Please see in the attached workflow.

FX rates.yxzp

Luke_C

Hi @Rahul_Analyst

For your point on the API, you would need to register with whatever the API provider is and get your own API token.

FX rates.yxmd

Rahul_Analyst

@Luke_C , thanks a lot! It resolved the issue. Can you share the link where I can learn about this type of date format?

Luke_C

Hi @Rahul_Analyst Take a look at this thread:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Convert-Epoch-time-to-actual-date-format/td-p/72586

Theja_G

Hi @Luke_C,

May i know how should i tweak the URL in the highlighted part controls the date to the current year?

Luke_C

Hi @Rahul_Analyst You'd have to convert the date range you want to unix format (see above link) using a formula like this: datetimediff([_CurrentField_],'1970-01-01 00:00:00','seconds')

Then you'd substitute those in the URL for period1= and period2=

Theja_G

Thanks, @Luke_C.

raj_kiran

How to modify this URL to fetch for today's date?

Luke_C

Hi @raj_kiran - you'd convert it the same way mentioned above.

datetimediff(DateTimeNow(),'1970-01-01 00:00:00','seconds')

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335