Do you know a new tool called “Get Conversion by currencies and date” has been published in our catalog?
What can I do with this tool?
If you use this tool you can convert amount between supported currencies and an exchange date. EURO exchange rate is applied to all conversions. If no exchange date is provided, last available date is assigned.
Supported currencies: AUD, BGN, BRL, CAD, CHF, CNY, CZK, DKK, GBP, HKD, HRK, HUF, IDR, ILS, INR, ISK, JPY, KRW, MXN, MYR, NOK, NZD, PHP, PLN, RON, RUB, SEK, SGD, THB, TRY, USD, ZAR
After using this tool you will enrich easily your data. If you want to know more about data enrichment, check our post How to treat your data(III): Completion.
Who can use this tool?
The tool “Conversion by currencies and date” is designed for the following working areas:
- Data Science
What parameters can I use?
To use the tool “Conversion by currencies and date”, you need to have the following field/s in your file, database, form or application:
What fields can I get?
If you use the tool “Get Conversion by currencies and date” you will obtain next output fields:
- result: value
Testing on the web catalog
If you browse our catalog, choose “I work on It area”:
You can find tool several ways from the catalog:
Writing “Conversion by currencies and date” or any of tool params (amount, isocode1, isocode2, date) in search input, pushing enter and clicking on the tool
Clicking on finance > Enrich > “Get Conversion by currencies and date” on “Category” view.
You can go to the tool page to test online for free.
After that, complete mandatory params on free test section and click on “test it”.
Using the tool from web wizard
Web wizard allows processing any file (download sample template), database or cloud application using existing data tools.
Choose your preferred data source and go ahead.
You can get extended details about wizard at “title”.
Now, you can see a data preview of your source.
Choose field (amount, isocode1, isocode2, date) or category (finance), action (enrich), tool “Get Conversion by currencies and date” and assign columns to parameters.
Add tool to view the estimated cost and process it
Boosting data from Google Sheets
First, you need to install UProc for Sheets from Google Apps marketplace.
Open panel “Add-ons” > “UProc for Sheets” and choose “I work on It area”.
Select field (amount, isocode1, isocode2, date), select tool “Get Conversion by currencies and date” and assign columns to parameters.
Ensure that your sheet has next headers: amount, isocode1, isocode2, date
Check “My sheet has headers” and “Process data”.
If your sheet has more than 200 rows, please use wizard instead.
Automating tool at Zapier
Zapier automates your business flow with any application you currently use in your workday.
Please, access UProc beta to create zaps at Zapier.
To boost your flow, add a new Uproc zap (you need to add your UProc account to Zapier)
Choose the group (finance), tool “Get Conversion by currencies and date” and assign values to “amount, isocode1, isocode2, date” using data from other zaps or fixed values.
Add more zaps to send data wherever you want.
Use tool by API
Go to tool page and click on “Show API information”.
Choose your preferred language and method to process your data (one value, multiple values or streams – files, databases and cloud applications -).
Copy generated API code to your environment and launch it.
How much does it cost?
This tool costs €2 if you process 1000 rows.
If you have a lot of rows to be processed you can check our discounts at Purchase section, completing the next data:
How many rows do you want to process?
Choose field (amount, isocode1, isocode2, date) or category (finance), action (enrich) and “Get Conversion by currencies and date”.
Click on “Add tool” to generate budget
You will see how much it costs processing your rows with “Get Conversion by currencies and date”.
That’s all folks
Thanks for reading this post and enjoy improving your data.
You can make Uproc better. Share your thoughts with us to add new tools or improve any other aspect of the platform.