Loading data from web services such as exchanges rates are a common requirements in the TM1. A easy way to do it, is to use TM1py. TM1py helps you to link your TM1 application from different web-services like Yahoo Finance, Bloomberg or Quandl.