The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Angelika's avatar
Angelika
New Contributor
2 years ago
Solved

FX Data Feed - Actual Rates - Automate from different Source like ECB or OAND

Hi, looking for experience and OS counterparts for support to automate ( plugging it directly in OneStream from source) FX Data Feed. Concern currency is USD. Which source are used - OANDA, Eurpean ...
FX Rates
  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    Hi Angelika 
    To be honest, I do dot recall the specificities. As long as the ECB is providing you the information from their api, then we can do anything with those rates, even calculates/recalculates/adj/compare/... before storing it to the FX table.
    Please give a kuddo if it helps,
    Nic

NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago

Hi Angelika 
Ideally you would have a button on a dashboard in onestream that you just press to retrieve the rates from the ECB. Or even, a task scheduler that retrieves overnight the rates for you.
It is possible to achieve that in OneStream by using the api from the ECB. 
You would need to write a business rule connector to connect to the ECB api and update the FX rates. But first, investigate to which api from ECB you will need to connect. Which api as the correct information? what you are looking for is a kind of URL : https://data.ecb.europa.eu/help/data-examples 
I have done connection to ECB in the past.
Have a good day.
Nic


  • Angelika's avatar
    Angelika
    New Contributor
    2 years ago

    Hi Nicolas,

     

    NicolasArgente wrote:

    Hi Angelika 
    Ideally you would have a button on a dashboard in onestream that you just press to retrieve the rates from the ECB. Or even, a task scheduler that retrieves overnight the rates for you.
    It is possible to achieve that in OneStream by using the api from the ECB. 
    You would need to write a business rule connector to connect to the ECB api and update the FX rates. But first, investigate to which api from ECB you will need to connect. Which api as the correct information? what you are looking for is a kind of URL : https://data.ecb.europa.eu/help/data-examples 
    I have done connection to ECB in the past.
    Have a good day.
    Nic
    Hi @Nicolas,

    thank you very much, great help. Do you load data via connector from ECB 1 time in a month - different currecy convert to USD? Are you calculating in OS average monthly rate (daily rates in month) and YTD rate (monthly average Rate)? 

    Thank you

    Angelika