473,414 Members | 1,630 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

World Currency Import?

Anyone know where i can find all world currencies (USD,etc) and do an import
into mySQL? Just need a comma delimited list if possible. Example:

USD, United States Dollar
etc, etc
Jul 17 '05 #1
5 2930
Philip D Heady wrote:
Anyone know where i can find all world currencies (USD,etc) and do an import
into mySQL? Just need a comma delimited list if possible. Example:

USD, United States Dollar


Would this be OK?

Rates as of 2002.03.14 21:20:02 UTC (GMT). Base currency is USD.

Currency Unit USD per Unit Units per USD
================================ =================== ===================
USD United States Dollars 1.00000 1.00000
EUR Euro 0.882525 1.13311
GBP United Kingdom Pounds 1.42053 0.703961
CAD Canada Dollars 0.628626 1.59077
JPY Japan Yen 0.00773976 129.203
CHF Switzerland Francs 0.604242 1.65497
AFA Afghanistan Afghanis 0.000210526 4750.00
ALL Albania Leke 0.00714286 140.000
You can fint it @ http://www.xe.com/cus/

Read their "Terms of Usage Agreement"
http://www.xe.com/legal/
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--
Jul 17 '05 #2
Unfortunately the US dollar has fallen on hard time lately. It's now close
to 1.30 per Euro.

Uzytkownik "Pedro Graca" <he****@hotpop.com> napisal w wiadomosci
news:c0*************@ID-203069.news.uni-berlin.de...
Philip D Heady wrote:
Anyone know where i can find all world currencies (USD,etc) and do an import into mySQL? Just need a comma delimited list if possible. Example:

USD, United States Dollar
Would this be OK?

Rates as of 2002.03.14 21:20:02 UTC (GMT). Base currency is USD.

Currency Unit USD per Unit Units per USD
================================ ===================

=================== USD United States Dollars 1.00000 1.00000
EUR Euro 0.882525 1.13311
GBP United Kingdom Pounds 1.42053 0.703961
CAD Canada Dollars 0.628626 1.59077
JPY Japan Yen 0.00773976 129.203
CHF Switzerland Francs 0.604242 1.65497
AFA Afghanistan Afghanis 0.000210526 4750.00
ALL Albania Leke 0.00714286 140.000
You can fint it @ http://www.xe.com/cus/

Read their "Terms of Usage Agreement"
http://www.xe.com/legal/
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

Jul 17 '05 #3
Chung Leong wrote:
Unfortunately the US dollar has fallen on hard time lately. It's now close
to 1.30 per Euro.

Uzytkownik "Pedro Graca" <he****@hotpop.com> napisal w wiadomosci
news:c0*************@ID-203069.news.uni-berlin.de...

Rates as of 2002.03.14 21:20:02 UTC (GMT). Base currency is USD.

Currency Unit USD per Unit Units per USD
================================ =================== ===================
USD United States Dollars 1.00000 1.00000
EUR Euro 0.882525 1.13311

You can fint it @ http://www.xe.com/cus/


This is the first few lines of their "sample mailout"

I am not subscribed to their service, but surely their mails are
current.

The interactive web page (http://www.xe.com/ucc/full.shtml) reports:

#v+
xe.com Universal Currency Converter ^(R) Results
Live mid-market rates as of 2004.02.11 00:57:57 GMT.
1.00 EUR = 1.26970 USD
Euro United States Dollars
1 EUR = 1.26970 USD 1 USD = 0.787589 EUR
$v-
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--
Jul 17 '05 #4
Since you posted your message the dollar has slided to 1.28. Ouch! Know any
European firm looking for a PHP programmer?

Uzytkownik "Pedro Graca" <he****@hotpop.com> napisal w wiadomosci
news:c0*************@ID-203069.news.uni-berlin.de...
Chung Leong wrote:
Unfortunately the US dollar has fallen on hard time lately. It's now close to 1.30 per Euro.

Uzytkownik "Pedro Graca" <he****@hotpop.com> napisal w wiadomosci
news:c0*************@ID-203069.news.uni-berlin.de...

Rates as of 2002.03.14 21:20:02 UTC (GMT). Base currency is USD.

Currency Unit USD per Unit Units per USD ================================ =================== =================== USD United States Dollars 1.00000 1.00000 EUR Euro 0.882525 1.13311
You can fint it @ http://www.xe.com/cus/


This is the first few lines of their "sample mailout"

I am not subscribed to their service, but surely their mails are
current.

The interactive web page (http://www.xe.com/ucc/full.shtml) reports:

#v+
xe.com Universal Currency Converter ^(R) Results
Live mid-market rates as of 2004.02.11 00:57:57 GMT.
1.00 EUR = 1.26970 USD
Euro United States Dollars
1 EUR = 1.26970 USD 1 USD = 0.787589 EUR
$v-
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

Jul 17 '05 #5
Chung Leong wrote:
Since you posted your message the dollar has slided to 1.28. Ouch! Know any
European firm looking for a PHP programmer?


Not yet... in a few years perhaps...

Well, we europeans aren't satisfied neither with a cheap dollar, we
are living from exporting cars, beer and other stoff... and those
things turns more expensive if you pay in dollar and so we have less
demand...
All the members of the worldwide financial gremiums want to do
something to revalue the dollar... but the U.S.

Saludo
piz

P.S.: a little o.t...
Jul 17 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Tim Roberts | last post by:
It looks to me like the handling of the currency type in an ADODB connecction from Python is broken. Currency data in an Access database is stored as a 64-bit integer, scaled by 10000. In an...
2
by: Willing 2 Learn | last post by:
I'm still having trouble getting my program to do arithmetic in cents(keeping all #'s) then convert the answer in a format of dollars & cents. The main program should add, subtract, scalar...
3
by: Dalan | last post by:
Is there any code available to address currency rounding problems in Access 97? Apparently, selecting currency type table fields does not resolve the problem. For instance, in my form I have a...
7
by: meenasamy | last post by:
Hi all, i need to create a function that takes three parameters( Original currency, needed currency, amount) i need to convert from the original currency to the needed currency the amount and...
4
by: Richard Kessler | last post by:
I am relatively new to Python. Love it, but I find things that I can do easily in .NET and cannot find a way to do in Python. I need to format a number as currency, for example 12343.56 to...
16
by: xjohnx | last post by:
Hi, I'm hoping someone can help me I am quite new to Javascript and have had to create a programme which converts dollars into euros and vice versa, here is my script which is working var...
3
by: aheath4043 | last post by:
Hi! I'm dealing with a vendor that needs me to format our import file a certain way to work with their system. Most of the issues are ok, but they need all currency values not as $79.95, but as...
25
by: mereba | last post by:
Hello My country Ghana is changing its currency. I want to write a small programme in C++ that can covert from the old currency into the new one. I would like this programme to run behind a simple...
0
by: Gerardo Herzig | last post by:
Hi all. Im having some "problems" with a small concurrent plpython function. Based on a small example about concurrent programming, there is some code which works fine under python: #!...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.