How to show live exchange rates in Active Report?

[tm1ist]

Hi all,

I have a requirement that particular current exchange rates (USD, EUR etc.) should be shown in an Active Report. Has anyone achieved this functionality?

I would prefer getting the numbers and format them myself. I guess there is only two ways to get the numbers:
(i)using some external url on the internet as a datasource in framework manager and creating&publishing that package to Cognos BI
(ii)using 'HTML Item' or similar item in the report to get the number from some service/website etc. somehow

Does anyone of you have any idea?