oo7ml
asked on
Currency / Exchange Rate
Hi, my site allows users (marathon runners) to create a marathon profile page so that they can accept donations from their friends and families.
I have a section on the site called Charities, which shows the amount of money that each charity has received through the site.
The site currently allows users (donators) to donate in USD, EUR, GBP & AUD so each marathon profile page could have a mixture of donations from a mixture of currencies.
There are 30+ charities on my site that the marathon runners can choose to donate their money to at present.
Question
How do i control / calculate the overall total raised for a single charity as there will be a mixture of donations / currencies. A user can choose one of USD, EUR, GBP & AUD as their default currency view in their account, so i can just display the total in one of those, but how do i add all of the donations up.
I was thinking maybe it would be best to just convert all donations for the chosen charity into the users default currency using an exchange rate for each of the 4 available currencies and then manually changing the exchange rates on a daily basis (or pulling them from some exchange rate site)
How do you think this would be best handles, thanks in advance for your advice...
I have a section on the site called Charities, which shows the amount of money that each charity has received through the site.
The site currently allows users (donators) to donate in USD, EUR, GBP & AUD so each marathon profile page could have a mixture of donations from a mixture of currencies.
There are 30+ charities on my site that the marathon runners can choose to donate their money to at present.
Question
How do i control / calculate the overall total raised for a single charity as there will be a mixture of donations / currencies. A user can choose one of USD, EUR, GBP & AUD as their default currency view in their account, so i can just display the total in one of those, but how do i add all of the donations up.
I was thinking maybe it would be best to just convert all donations for the chosen charity into the users default currency using an exchange rate for each of the 4 available currencies and then manually changing the exchange rates on a daily basis (or pulling them from some exchange rate site)
How do you think this would be best handles, thanks in advance for your advice...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was thinking it would probably be best to only accept donations in the currency that the marathon runner set the profile page up as...
So, for example, if they set it up as $ and a user from Europe wanted to donate, the could choose $5 but then PayPal would work out there and then what it is actually costing them in €
Then on top of this, i can use a base currency for the site too... what you reckon...