There is an additional problem not addressed in this answer. The foreign currency rates are typically the interbank rates, i.e., those used by banks. You cannot get that rate if you are converting foreign currency into US dollars. The appropriate rate is the actual rate that occurred at the time of conversion.
