Foreign currency conversion for international visitors to ecommerce web site?
Central banks don't generally post exchange rates with other currencies, as they are not determined by central banks but by the currency markets. You need a source for live exchange rate data (for example www.xe.com), and you need to calculate the prices in other currencies dynamically as they are displayed -- they will be changing continually, from minute to minute. For manual conversion you can use many sites, starting from google (type 30 USD in yuan) to sites like xe.com mentioned here. For programmatic conversion, you could use Google Calculator API or many other currency exchange APIs that are available. Beware however that if you do it on the real site, the exchange rate is different from actual rates used by banks and payment processing companies - while they use market-based rates, they usually charge some premium on currency conversion, meaning that if you have something for 30 dollars, according to current rate it may bet 198 yuan, but if he uses a credit card for purchase, it may cost him, for example, 204 yuan. You should be very careful about making difference between snapshot market rates and actual rates used in specific transaction. You probably can get away with only updating the exchange rates once a day and specify that any prices quoted in units other than your home currency are estimates only. If you're planning to accept more than one currency as payment, I'd (a) see about whatever regulations there are for doing so, and (b) build in a nice spread for yourself if you're allowed to, since it is a service you're providing to your customers.  If you Google currency converter the first result is just that: a currency converter.
"&gt;But Facebook, which claims more than 900 million members, had 158 million unique visitors to its site in April, according to researcher ComScore, up just 5% from a year ago. That compares with year-over-year growth rates of 89% in April 2010.  So, about 1 in 6 users (~16%) visited facebook during a particular (recent) month.  The other 5 of 6 (~83%) of users didn't visit during that month...  Hmmm...  Sounds like a lot of relatively dead/fairly inactive accounts/users to me\*.  And the thing is that -- different than other social sites like LinkedIn (which is in a lot of ways an ""online resume"" &amp; business contact database) -- facebook pretty much NEEDS continuous and regular use (that's the premise that their whole model, especially advertising-wise, is built on, if FB reverts to people simply using it to maintain a once or twice a year ""update"" on movements of friends {i.e. it becomes the equivalent of a Xmas card list storage site} then it's potential ""value"" diminishes rather dramatically).  &gt;Also, the social network is testing ways to allow those under 13, currently prohibited, to participate with parental supervision.  Which seems (from a cynical perspective anyway) to be a sign that they are potentially getting ""desperate"" to maintain the purported ""growth"" in number of users. (And in a certain sense, they are doing what all companies with ""saturated"" markets do... a futile attempt to pull future demand into the present; which of course -- to the extent that it succeeds anyway -- really just moves the inevitable ""dropoff"" that much closer.)  ---  \* EDIT: And in addition (not surprisingly) it looks like Pareto principle, which tends to be recursive.. Of the roughly 20% (~16%) ""unique"" visitors during the month, probably the majority of them (roughly 80% of the 16%) engaged in minimal activity, with only some 20% of it (and thus somewhere round 3.2%~4%) of the total user base being truly ""active"", and then again, probably only 20% of *that* (maybe at or under 1%) were of the *hyper*-""active"" users that everyone thinks facebook'ers are." As NRI/PIO (Non-Resident Indian/Person of Indian Origin), the overseas income and transfers in foreign currency are exempt from Indian income taxes. However, the account in India has to be designated NRE or FCNR. There are three kind of accounts that an NRI can maintain Interest earned in NRE and FCNR accounts is exempt from income taxes. Interest earned in NRO accounts is not exempt from income taxes, in fact banks would withhold about 30% of interest (TDS). The exact tax liability would depend upon income generated in India and TDS could be applied towards that liability when the tax returns are filed. There are other implications also of designating the account as NRE or NRO. NRE accounts can only be funded via inward remittance of permitted foreign currency e.g. deposit USD/GBP. So proceeds like rental income, pension etc. that are generated in INR within India can't be deposited in this account. The money deposited in NRE account can grow tax free and can be converted back in any foreign currency freely. On the other hand NRO accounts can be funded through both inward remittance of permitted foreign currency or local income e.g. rental, pension etc. All the amount in this account is treated as Indian originated INR (even if remitted in foreign currency) and thus is taxed as any other bank account. The amount in this account is subject to the annual cap of convertibility of USD 1 million. Both NRE and NRO accounts are maintained in INR and can be Saving and Term Deposit. Any remittance made to these accounts in any foreign currency is converted to INR at the time of deposit and is maintained in INR. FCNR account are held in foreign currency and can only be Term Deposit. Official definitions: Accounts for Non Resident Indians (NRIs) and Persons of Indian Origin (PIOs) Evaluating the value of currencies is always difficult because you are usually at the mercy of a central bank that can print new currency on a whim. I am trying to diversify my currency holdings but it is difficult to open foreign bank accounts without actually being in the foreign country.  Any ideas here? You don't indicate which currencies you own but I would stick with your diversified portfolio of currencies and add some physical assets as a hedge against the fiat currencies. "For the purposes of report generation, I would recommend that you present the data in the currency of the user's home country. You could present another indicator, if needed, to indicate that a specific transaction was denominated in a foreign currency, where the amount represents the value of the foreign-denominated transaction in the user's home country Currency. For example: Airfare from USA to London: $1,000.00 Taxi from airport to hotel: $100.00 (in £) In terms of your database design, I would recommend not storing the data in any one denomination or reference currency. This would require you to do many more conversions between currencies that is likely to be necessary, and will create additional complexity where in some cases, you will need to do multiple conversions per transaction in and out of your reference currency. I think it will be easier for you to store multiple currencies as themselves, and not in a separate reference currency. I would recommend storing several pieces of information separately for each transaction: This way, you can create a calculated Amount for each transaction that is not in the user's ""home"" currency, whereas you would need to calculate this for all transactions if you used a universal reference currency. You could also get data from an external source if the user has forgotten the conversion rate. Remember that there are always fees and variations in the exchange rate that a user will get for their home country's currency, even if they change money at the same place at two different times on the same day. As a result, I would recommend building in a simple form that allows a user to enter how much they exchanged and how much they got back to calculate the exchange rate. So for example, let's say I have $ 200.00 USD and I exchanged $ 100.00 USD for £ 60.00, and there was a £ 3.00 fee for the exchange. The exchange rate would be 0.6, and when the user enters a currency conversion, your site could create three separate transactions such as: USD Converted to £: $100.00 £ Received from Exchange: £ 60.00 Exchange Fee: £ 3.00 So if the user exchanged currency and then ran a balance report by Currency, you could either show them that they now have $ 100.00 USD and £ 57.00, or you could alternatively choose to show the £ 57.00 that they have as $95.00 USD instead. If you were showing them a transaction report, you could also show the fee denominated in dollars as well. I would recommend storing your balances and transactions in their own currencies, as you will run into some very interesting problems otherwise. For example, let's say you used a reference currency tied to the dollar. So one day I exchange $ 100.00 USD for £ 60.00. In this system I would still have 100 of my reference currency. However, if the next day, the exchange rate falls and $ 1.00 USD is only worth £ 0.55, and I change my £ 60.00 back into USD, I will get approxiamately $ 109.09 USD back for my £ 60.00. If I then go and buy something for $ 100.00 USD, the balance of the reference currency would be at 0, but I will still have $ 9.09 USD in my pocket as a result of the fluctuating currency values! That is why I'd recommend storing currencies as themselves, and only showing them in another currency for convenience using calculations done ""on the fly"" at report runtime. Best of luck with your site!" I want to shop in the currency that will be cheapest in CAD at any   given time. How do you plan to do this? If you are using a debit or credit card on a CAD account, then you will pay that bank's exchange rate to pay for goods and services that are billed in foreign currency. If you plan on buying goods and services from merchants that offer to bill you in CAD for items that are priced in foreign currency (E.g. buying from Amazon.co.uk GBP priced goods, but having Amazon bill your card with equivalent CAD) then you will be paying that merchant's exchange rate. It is very unlikely that either of these scenarios would result in you paying mid-market rates (what you see on xe.com), which is the average between the current ask and bid prices for any currency pair. Instead, the business handling your transaction will set their own exchange rate, which will usually be less favorable than the mid-market rate and may have additional fees/commission bolted on as a separate charge.  For example, if I buy 100 USD worth of goods from a US vendor, but use a CAD credit card to pay, the mid-market rate on xe.com right now indicates an equivalent value of 126.97 CAD. However the credit card company is more likely to charge closer to 130.00 CAD and add a foreign transaction fee of maybe $2-3, or a percentage of the transaction value. Alternatively, if using something like Amazon, they may offer to bill the CAD credit card in CAD for those 100 USD goods. No separate foreign transaction fee in this case, but they are still likely to exchange at the less favorable 130.00 rate instead of the mid-market rates. The only way you can choose to pay in the cheapest equivalent currency is if you already have holdings of all the different currencies. Then just pay using whichever currency gets you the most bang for your buck. Unless you are receiving payments/wages in multiple currencies though, you're still going to have to refill these accounts periodically, thus incurring some foreign transaction fees and being subject to the banker's exchange rates. Where can I lookup accurate current exchange rates for consumers? It depends on who will be handling your transaction. Amazon will tell you at the checkout what exchange rate they will apply if you are having them convert a bill into your local currency for you. For credit/debit card transactions processed in a different currency than the attached account, you need to look at your specific agreement or contact the bank to see which rate they use for daily transactions (and where you can obtain these rates), whether they convert on the day of the transaction vs. the day it posts to your account, and how much they add on ($ and/or %) in fees and commission. You havent indicated the duration of your visit. The best way to do this is carry GBP. Exchange this into local currencies in the Thailand/Indonesia. Do not convert at Airport as the rates are bad. Go around shopping for rates. Most of the malls have tons of delears, bargain hard to get a good price.   For hotel stay, most of the hotels in Thailand/Indonesia charge you a USD rate for room. You can check with them, if so its better to get a Pre-paid USD card or even if you swipe your regular card, you would get a decent rate for USD-GBP. The other option to make hotel payments is using Travellers cheques. I have heard it recommended on the money radio shows to get a little walking around money in the local currency at your local bank, but look for a credit card that offers low or no fees for international usage.  The credit card company will do all the monetary conversions for you for a smaller fee. Hi there. I think China is recommended for premanufactured products given their GDP output. The specific products may exist in the US too. The key is networking. Starting online retail, you are essentially ecommerce and or sales. There may be people seeking sales reps for their products.   You should have a specific business plan targetting the niche you plan to sell and cater to. Thomasnet has US manufacturers. You may have to get clever and work out deals selling manufactured goods but with work it can be done. I personally have seen way too many issues result of dealing with imports and know of many rookie mistakes in business where people have gone this route due to price.  Sources: MBA, marketing apprentice for multi millionaire, business apprentice working with manufacturing operations director with civil and military experience; former freelance design, project management and product manufacturing experience.