Taiwan Dollar not working

dylan1218 / Foreign-Currency-Exchange-UDF-VBA-

Translate Fx rates through a user defined function in excel

MIT License

3 stars 0 forks source link

Open douala63 opened 6 years ago

douala63 commented 6 years ago

thank you for your code, it works great except for the Taiwan Dollar (TWD). ANy suggestions? Thanks

douala63 commented 6 years ago

It returns #VALUE!

dylan1218 commented 6 years ago

Apologies for the late response!

Given that the API this is based off of uses the ECB for rates ("https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html") there's a limitation to which currencies are available. Unfortunately in this case the ECB doesn't appear to provide rates for TWD.

If you happen to find another API that has the TWD available within it feel free to let me know and I'll build it into the UDF for your use