The software uses the Open Exchange Rates API and is entirely dependent on this for data. You will enter a separate contract with them when registering for the API key / App ID. It takes less than two minutes, the service has been around for a decade or so as of February 2020, and they never ever send spam or ads. I have only gotten two mails from them, about relevant service interruptions, over the course of this near-decade.
Open Exchange Rates has a free plan that can be used for testing, or indefinitely, which you can sign up for here. It takes only about a minute to sign up, and as a user of their services for several years myself, I can say I have never received a single spam email from them, and for my purposes the service has been very reliable.My software depends entirely on Open Exchange Rates web API access working. It does cache data locally upon initial retrieval for a default of 30 minutes. The time interval is set on first run to a default of 60 seconds * 30 (30 minutes) and stored on disk.
You can view and change this value (in seconds) with the functions ''Get-STOXRCacheInterval'' and ''Set-STOXRCacheInterval''.I recommend you purchase a plan with Open Exchange Rates if you plan to use this API a lot and if you want their service to continue existing, by supporting them and also abiding by their terms if you want faster updates, shorter cache times, etc.
NB! You need to know how to start powershell.exe or powershell_ise.exe and preferrably a bit about how to use PowerShell in order to use this software in its current form. Such as how to install a module (put it in $Env:PSModulePath) and run functions.It is written primarily for technical people who want to save time - and possibly don't possess the skill set to do the same - by another person.
PS C:\> Import-Module STOXR WARNING: This is a trial version of the product. You can only change to or from one single currency (both ways). The currency is 'USD' by default. In the trial software it can be changed once every 12 hours. Change to for example British Pound Sterling with Set-STOXRTrialCurrency -Currency GBP. To display the currently set trial currency, use Get-STOXRTrialCurrency. To list all supported currencies, use Get-STOXRCurrencyList. WARNING: No Open Exchange Rates App ID has been set. You need to set it to use this software. This can be obtained at https://openexchangerates.org/ . Use Set-STOXRAppID to set it.WARNING: You need to set the Open Exchange Rates app ID with Set-STOXRAppID before using this software.
PS C:\> Set-STOXRAppID -AppID "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"PS C:\> Convert-STOXRCurrency -Amount 1 -FromCurrency USD -ToCurrency NOK
FromAmount : 1.0000 FromAmountNumerical : 1 FromCurrency : USD FromCurrencyText : United States Dollar ToAmount : 7.8185 ToAmountNumerical : 7.818513 ToCurrency : NOK ToCurrencyText : Norwegian Krone FromCurrencyPerUSD : 1.0000 ToCurrencyPerUSD : 7.8185 Date : 2017-09-26 03:49:05 Precision : 4
PS C:\> Get-STOXRCurrencyList | Select-Object -First 15 |
foreach {
$Result = Convert-STOXRCurrency 1 $_.Name USD -Precision 3
"1.000 $($_.Name) ($($_.Description)) is $($Result.ToAmount) United States Dollars"
}
1.000 AED (United Arab Emirates Dirham) is 0.272 United States Dollars
1.000 AFN (Afghan Afghani) is 0.015 United States Dollars
1.000 ALL (Albanian Lek) is 0.009 United States Dollars
1.000 AMD (Armenian Dram) is 0.002 United States Dollars
1.000 ANG (Netherlands Antillean Guilder) is 0.562 United States Dollars
1.000 AOA (Angolan Kwanza) is 0.006 United States Dollars
1.000 ARS (Argentine Peso) is 0.057 United States Dollars
1.000 AUD (Australian Dollar) is 0.782 United States Dollars
1.000 AWG (Aruban Florin) is 0.557 United States Dollars
1.000 AZN (Azerbaijani Manat) is 0.588 United States Dollars
1.000 BAM (Bosnia-Herzegovina Convertible Mark) is 0.601 United States Dollars
1.000 BBD (Barbadian Dollar) is 0.500 United States Dollars
1.000 BDT (Bangladeshi Taka) is 0.012 United States Dollars
1.000 BGN (Bulgarian Lev) is 0.600 United States Dollars
1.000 BHD (Bahraini Dinar) is 2.652 United States Dollars
The software in its current form is not optimized for speed or efficiency with regards to resource usage, but provides extreme convenience and saves you the tedious task of writing a lot of code to perform similar tasks, probably less feature-rich than I've invested time in making it as well.
Being built entirely in PowerShell, the built-in shell and scripting langauge and automation framework in Microsoft Windows operating systems, STOXR is extremely automation-friendly. It can also quite seamlessly be integrated with other .NET languages accessing these PowerShell functions to do the heavy lifting - languages such as C# and VB.NET. You can also integrate it with ASP.NET and other web frameworks if you so desire.NB! The proxy features are currently untested since I don't have access to a test environment of that nature.
PS C:\> Get-Command -Module STOXR | Format-Table -AutoSize CommandType Name Version Source ----------- ---- ------- ------ Function Convert-STOXRCurrency 1.0.0.7 stoxr Function Get-STOXRAppID 1.0.0.7 stoxr Function Get-STOXRCacheInterval 1.0.0.7 stoxr Function Get-STOXRCurrencyList 1.0.0.7 stoxr Function Get-STOXRDebugInfo 1.0.0.7 stoxr Function Get-STOXRProxy 1.0.0.7 stoxr Function Get-STOXRTrialCurrency 1.0.0.7 stoxr Function Register-STOXR 1.0.0.7 stoxr Function Set-STOXRAppID 1.0.0.7 stoxr Function Set-STOXRCacheInterval 1.0.0.7 stoxr Function Set-STOXRProxy 1.0.0.7 stoxr Function Set-STOXRTrialCurrency 1.0.0.7 stoxr Function Unregister-STOXR 1.0.0.7 stoxr
'''NB!''' The proxy functions are currently '''untested'''! I will investigate upon receiving feedback, if necessary. I have no access to such a testing environment currently.
This does not work properly in the trial version. The error you will get when trying a fuzzy trial currency, with the trial version, is:
PS C:\> $Result = Convert-STOXRCurrency -Amount 1 -FromCurrency "united states" -ToCurrency swedish WARNING: This product is not registered, so the limitations apply that either the 'From' or 'To' currency needs to be 'USD' (default USD) - and that -FuzzyInput does not work. The trial currency can be changed once every 12 hours with the command Set-STOXRTrialCurrency. Register the product to unlock full functionality.
If you specify the currency abbreviation "USD", or the trial currency you changed to, explicitly, it works with fuzzy matching on the other currency.
Here I register the software using a license, using the function Register-STOXR.
PS C:\> help Register-STOXR
NAME
Register-STOXR
SYNOPSIS
Use the license key you bought and received to register the Svendsen Tech
Open Exchange Rates module.
This unlocks the full functionality and allows you to convert between
any/multiple currencies.
SYNTAX
Register-STOXR [[-LicenseKey] ] [-RefreshUsingExistingLicense]
[]
... and then I register it like this:
PS C:\> Register-STOXR -LicenseKey 'xxxxx-xxxxxxxxxxxx-xxxxxxxxxx' Successfully registered the Svendsen Tech Open Exchange Rates module.
This time around it works better.
PS C:\> $Result = Convert-STOXRCurrency -Amount 1 -FromCurrency "united states" `
-ToCurrency swedish
WARNING: Performing first-run operation of setting currency exchange data refresh interval
to 30 * 60 seconds (30 minutes). Use Set-STOXRCacheInterval to change it.
PS C:\> $Result
FromAmount : 1.0000
FromAmountNumerical : 1
FromCurrency : USD
FromCurrencyText : United States Dollar
ToAmount : 8.0393
ToAmountNumerical : 8.039254
ToCurrency : SEK
ToCurrencyText : Swedish Krona
FromCurrencyPerUSD : 1.0000
ToCurrencyPerUSD : 8.0393
Date : 2017-09-26 03:49:05
Precision : 4
Examples with pound, dollar and Scandinavian currencies (krone/krona - which incidentally means "crown", for some random linguistic elucidation of the masses):
PS C:\> Convert-STOXRCurrency 1 USD -To pound WARNING: Multiple hits (12) for "to" currency: EGP, Egyptian Pound FKP, Falkland Islands Pound GBP, British Pound Sterling GGP, Guernsey Pound GIP, Gibraltar Pound IMP, Manx pound JEP, Jersey Pound LBP, Lebanese Pound SDG, Sudanese Pound SHP, Saint Helena Pound SSP, South Sudanese Pound SYP, Syrian Pound PS C:\> Convert-STOXRCurrency 1 USD -To dollar WARNING: Multiple hits (23) for "to" currency: AUD, Australian Dollar BBD, Barbadian Dollar BMD, Bermudan Dollar BND, Brunei Dollar BSD, Bahamian Dollar BZD, Belize Dollar CAD, Canadian Dollar FJD, Fijian Dollar GYD, Guyanaese Dollar HKD, Hong Kong Dollar JMD, Jamaican Dollar KYD, Cayman Islands Dollar LRD, Liberian Dollar NAD, Namibian Dollar NZD, New Zealand Dollar SBD, Solomon Islands Dollar SGD, Singapore Dollar SRD, Surinamese Dollar TTD, Trinidad and Tobago Dollar TWD, New Taiwan Dollar USD, United States Dollar XCD, East Caribbean Dollar ZWL, Zimbabwean Dollar PS C:\> Convert-STOXRCurrency 1 USD -To kron WARNING: Multiple hits (3) for "to" currency: DKK, Danish Krone NOK, Norwegian Krone SEK, Swedish Krona
As of 2020-02-28 the list is as follows:
PS C:\temp> Get-STOXRCurrencyList -AutoSizeTable Name Description ---- ----------- AED United Arab Emirates Dirham AFN Afghan Afghani ALL Albanian Lek AMD Armenian Dram ANG Netherlands Antillean Guilder AOA Angolan Kwanza ARS Argentine Peso AUD Australian Dollar AWG Aruban Florin AZN Azerbaijani Manat BAM Bosnia-Herzegovina Convertible Mark BBD Barbadian Dollar BDT Bangladeshi Taka BGN Bulgarian Lev BHD Bahraini Dinar BIF Burundian Franc BMD Bermudan Dollar BND Brunei Dollar BOB Bolivian Boliviano BRL Brazilian Real BSD Bahamian Dollar BTC Bitcoin BTN Bhutanese Ngultrum BWP Botswanan Pula BYN Belarusian Ruble BZD Belize Dollar CAD Canadian Dollar CDF Congolese Franc CHF Swiss Franc CLF Chilean Unit of Account (UF) CLP Chilean Peso CNH Chinese Yuan (Offshore) CNY Chinese Yuan COP Colombian Peso CRC Costa Rican Colón CUC Cuban Convertible Peso CUP Cuban Peso CVE Cape Verdean Escudo CZK Czech Republic Koruna DJF Djiboutian Franc DKK Danish Krone DOP Dominican Peso DZD Algerian Dinar EGP Egyptian Pound ERN Eritrean Nakfa ETB Ethiopian Birr EUR Euro FJD Fijian Dollar FKP Falkland Islands Pound GBP British Pound Sterling GEL Georgian Lari GGP Guernsey Pound GHS Ghanaian Cedi GIP Gibraltar Pound GMD Gambian Dalasi GNF Guinean Franc GTQ Guatemalan Quetzal GYD Guyanaese Dollar HKD Hong Kong Dollar HNL Honduran Lempira HRK Croatian Kuna HTG Haitian Gourde HUF Hungarian Forint IDR Indonesian Rupiah ILS Israeli New Sheqel IMP Manx pound INR Indian Rupee IQD Iraqi Dinar IRR Iranian Rial ISK Icelandic Króna JEP Jersey Pound JMD Jamaican Dollar JOD Jordanian Dinar JPY Japanese Yen KES Kenyan Shilling KGS Kyrgystani Som KHR Cambodian Riel KMF Comorian Franc KPW North Korean Won KRW South Korean Won KWD Kuwaiti Dinar KYD Cayman Islands Dollar KZT Kazakhstani Tenge LAK Laotian Kip LBP Lebanese Pound LKR Sri Lankan Rupee LRD Liberian Dollar LSL Lesotho Loti LYD Libyan Dinar MAD Moroccan Dirham MDL Moldovan Leu MGA Malagasy Ariary MKD Macedonian Denar MMK Myanma Kyat MNT Mongolian Tugrik MOP Macanese Pataca MRO Mauritanian Ouguiya (pre-2018) MRU Mauritanian Ouguiya MUR Mauritian Rupee MVR Maldivian Rufiyaa MWK Malawian Kwacha MXN Mexican Peso MYR Malaysian Ringgit MZN Mozambican Metical NAD Namibian Dollar NGN Nigerian Naira NIO Nicaraguan Córdoba NOK Norwegian Krone NPR Nepalese Rupee NZD New Zealand Dollar OMR Omani Rial PAB Panamanian Balboa PEN Peruvian Nuevo Sol PGK Papua New Guinean Kina PHP Philippine Peso PKR Pakistani Rupee PLN Polish Zloty PYG Paraguayan Guarani QAR Qatari Rial RON Romanian Leu RSD Serbian Dinar RUB Russian Ruble RWF Rwandan Franc SAR Saudi Riyal SBD Solomon Islands Dollar SCR Seychellois Rupee SDG Sudanese Pound SEK Swedish Krona SGD Singapore Dollar SHP Saint Helena Pound SLL Sierra Leonean Leone SOS Somali Shilling SRD Surinamese Dollar SSP South Sudanese Pound STD São Tomé and Príncipe Dobra (pre-2018) STN São Tomé and Príncipe Dobra SVC Salvadoran Colón SYP Syrian Pound SZL Swazi Lilangeni THB Thai Baht TJS Tajikistani Somoni TMT Turkmenistani Manat TND Tunisian Dinar TOP Tongan Pa'anga TRY Turkish Lira TTD Trinidad and Tobago Dollar TWD New Taiwan Dollar TZS Tanzanian Shilling UAH Ukrainian Hryvnia UGX Ugandan Shilling USD United States Dollar UYU Uruguayan Peso UZS Uzbekistan Som VEF Venezuelan Bolívar Fuerte (Old) VES Venezuelan Bolívar Soberano VND Vietnamese Dong VUV Vanuatu Vatu WST Samoan Tala XAF CFA Franc BEAC XAG Silver Ounce XAU Gold Ounce XCD East Caribbean Dollar XDR Special Drawing Rights XOF CFA Franc BCEAO XPD Palladium Ounce XPF CFP Franc XPT Platinum Ounce YER Yemeni Rial ZAR South African Rand ZMW Zambian Kwacha ZWL Zimbabwean Dollar
PS C:\> Convert-STOXRCurrency -FuzzyInput '1 norwegian in swedi' FromAmount : 1.0000 FromAmountNumerical : 1 FromCurrency : NOK FromCurrencyText : Norwegian Krone ToAmount : 1.0282 ToAmountNumerical : 1.0282331179854788244260769276 ToCurrency : SEK ToCurrencyText : Swedish Krona FromCurrencyPerUSD : 7.8185 ToCurrencyPerUSD : 8.0393 Date : 2017-09-26 03:49:05 Precision : 4
PS C:\> Convert-STOXRCurrency 1 dkk nok -AsString 1.0000 DKK (Danish Krone at 6.2739/USD) is 1.2459 NOK (Norwegian Krone, 7.8169/USD). Date: 2017-09-26 04:19:19.
Rounded to two digits only with "-Precision 2".
PS C:\> Convert-STOXRCurrency 1 dkk nok -AsString -Precision 2 1.00 DKK (Danish Krone at 6.27/USD) is 1.25 NOK (Norwegian Krone, 7.82/USD). Date: 2017-09-26 04:19:19.PS C:\> Convert-STOXRCurrency 1 usd dkk -Precision 2
FromAmount : 1.00 FromAmountNumerical : 1 FromCurrency : USD FromCurrencyText : United States Dollar ToAmount : 6.27 ToAmountNumerical : 6.27387 ToCurrency : DKK ToCurrencyText : Danish Krone FromCurrencyPerUSD : 1.00 ToCurrencyPerUSD : 6.27 Date : 2017-09-26 04:19:19 Precision : 2
You can always download the latest version here or from the PowerShell gallery, where I will keep the software up-to-date. Old keys will work for new software unless I provide a significantly different product (GUI and graphs are on the to do list), for which a new license will apply. Previous customers will either get it for free or get a significant discount.
If you have Windows Management Framework 5 / PowerShell version 5 or higher (default in Windows 10 / Server 2016 and up), you can install the module from Microsoft's PowerShell gallery site where it has also been published in the trial version:This requires an admin console and installs for all users, by default in $Env:ProgramFiles\WindowsPowerShell\Modules.
Install-Module -Name STOXRor to install in your profile directory for your user only:
Install-Module -Name STOXR -Scope CurrentUseror to update the module to the latest version (you will need to re-enter the App ID in the updated version, will look into automating retrieval from the latest previous version found and automatically installing that in the new one, or prompting, since it might not be desired behaviour):
Update-Module -Name STOXR
or to download and inspect the code:
Save-Module -Name STOXR -Path X:\SomeDirectory\STOXR
The pricing model for STOXR is as follows:
One license entitles you to use the software freely indefinitely, combined with the Open Exchange Rates terms you and they agree upon when you register for an App ID / API key on their website (sign up here). Free plan available - no spam.
"Use" means within one (part of an) organization/company or as one private individual.STOXR-License.pdf. It's a simple, slightly modified MIT license.
If you have questions, please contact Svendsen Tech at svendsentech@gmail.com.My sales and license key provider is MyCommerce/Share-It, a Digital River company.
You can purchase the software by clicking this link, or the order button above, completing the payment process and getting immediate access to the license key.To get in touch with MyCommerce customer service and refer to my vendor ID, use this link.
Version history:Keywords: convert currency, currency converter software in .NET, CSV, Excel, convert USD to EUR, .xls, .xlsx, currency conversion software, convert EUR to USD, convert between any currency, currencies, all currencies, .NET currency conversion software, business, business software, ASP.NET, VB.NET, C#, F#, Visual Basic, automation framework, Microsoft Windows, PowerShell/.NET, gold ounce exchange rate (XAU), platinum ounce, silver ounce (XAG) exchange rate, PowerShell version 3, bitcoin, Japanese Yen, Chinese Yen, Australian Dollars, Euro, .NET framework, bank, banking, finance, financial currency conversion, enterprise, comprehensive list of currencies, convert USD to any currency, free trial currency software, shareware, automation, DevOps, objects, PowerShell objects
Currency Currency Conversion Currency Conversion Software Finance Powershell Windows Automation Finans .NET All CategoriesMinimum cookies is the standard setting. This website uses Google Analytics and Google Ads, and these products may set cookies. By continuing to use this website, you accept this.