In this process, we are calculating live currency, foreign exchange rates via currency converter on the Economic Times
Top Benefits
Removes the manual efforts of reconciling sensitive data
Currency converter bot saves manpower cost and efforts and works 24/7 their respective time
Tasks
Open Excel input file and fetch data
Set data in Oanda website
Extract currency data from website and set data in Excel sheet
You have to provide an input Excel sheet that contains different country currency details. The bot will fetch the currency details and enter into the Oanda website and get updated currency amount details and store them in an input Excel sheet with the updated date. The bot will get all rates as per the given data.
See the Bot in Action
Setup process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Use the Bot in a bot, configure keys and other credentials the Bot will need (see the ReadMe for details.)
Run
That's it - now the Bot is ready to get going!
Requirements and Inputs
Please provide values to below variables:
1. InputFilePath – Download dependency file – “Currency Converted Rate.xlsx”, and provide downloaded file path at line 2
2. ErrorLogFilePath – Provide file path to store error log details at line number 3 in bot.