asked on 4/23/2017

C# Get Current Exchange Rate from XE

Hi,

I need to display current exchange rates on my application.
Is it possible to retrieve the exchange rate from http://www.xe.com (XE Converter)
Thank you.
Here what I tried:

public string CurrencyConversion(decimal amount, string fromCurrency, string toCurrency)
        {
            string Output = "";
             string fromCurrency1 = comboBox1.Text;
             string toCurrency1 = comboBox2.Text;
             decimal amount1 = Convert.ToDecimal(textBox1.Text);

            // For other currency symbols see http://finance.yahoo.com/currency-converter/
            // Construct URL to query the Yahoo! Finance API

            const string urlPattern = "http://finance.yahoo.com/d/quotes.csv?s={0}{1}=X&f=l1";
            string url = string.Format(urlPattern, fromCurrency1, toCurrency1);

            // Get response as string
            string response = new WebClient().DownloadString(url);

            // Convert string to number
            decimal exchangeRate =
                decimal.Parse(response, System.Globalization.CultureInfo.InvariantCulture);

            // Output the result
            Output = (amount1 * exchangeRate).ToString();
            textBox2.Text = Output;

            return Output;
        }

Open in new window

With this code I am not having the full output... the decimal part is not showing...

Last Comment

Vishal Tankariya

4/29/2017

Éric Moreau

4/23/2017

I just tried your code and it is working correctly for me. What is your decimal point separator? A dot?

        private void button1_Click(object sender, EventArgs e)
        {
            CurrencyConversion(new decimal(123.45), "CAD", "USD");
        }

        public string CurrencyConversion(decimal amount, string fromCurrency, string toCurrency)
        {
            string Output = "";
            string fromCurrency1 = fromCurrency; // comboBox1.Text;
            string toCurrency1 = toCurrency; // comboBox2.Text;
            decimal amount1 = amount; // Convert.ToDecimal(textBox1.Text);

            // For other currency symbols see http://finance.yahoo.com/currency-converter/
            // Construct URL to query the Yahoo! Finance API

            const string urlPattern = "http://finance.yahoo.com/d/quotes.csv?s={0}{1}=X&f=l1";
            string url = string.Format(urlPattern, fromCurrency1, toCurrency1);

            // Get response as string
            string response = new WebClient().DownloadString(url);

            // Convert string to number
            decimal exchangeRate = decimal.Parse(response, System.Globalization.CultureInfo.InvariantCulture);

            // Output the result
            Output = (amount1 * exchangeRate).ToString();
            //textBox2.Text = Output;
            MessageBox.Show(Output);

            return Output;
        }

Open in new window

SniperCode Sheva

4/23/2017

ASKER

instead of CAD, try GNF and put as an amount 10000 and try it here http://www.xe.com/en/currencyconverter/convert/?Amount=10000&From=GNF&To=USD it will not be the same output...

Éric Moreau

4/23/2017

It is working. The returned exchange rate is 0.0001. so 10,000 * 0.00001 = 1.

Replace 10000 with 123.45 and you will see that it is working.

SniperCode Sheva

4/23/2017

ASKER

Why I must replace 10000 with 123.45 ? Did you see the result in the link that I gave ?

Éric Moreau

4/23/2017

>>Why I must replace 10000 with 123.45 ?

10,000 * 0.00001 = 1.

Try it with 123.45 and you will see decimals

SniperCode Sheva

4/23/2017

ASKER

yes but the real rate is 0.000108225 and not 0.00001 so I must get this : 0.000108225

Éric Moreau

4/23/2017

the service that is called seems to be limited to 5 digits as it returns only .00001. You can see it in the response variable.

David Johnson, CD

4/23/2017

converted = amount1 * exchangeRate;
            Output = string.Format("{0:f2}", converted);
            textBox2.Text = Output;

Open in new window

you code also worked for me

ASKER CERTIFIED SOLUTION

Vishal Tankariya

4/29/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial