Relation between DataFeed and Bloomberg

[Former Member]

Dear TRM experts

Does any of you ever implemented the DataFeed for TRM using Bloomberg as the provider?

Thanks for the help

Regards

George Passini

[Former Member]

What specific questions you have? I can help based on my experience.

[Former Member]

I need to use the DataFeed to import all the currencies and interest rates using a HTTPA connection.

I made a similar customizing as the one bellow using FINISS as a provider and now I need to do the same for bloomberg.

SAP R/3 4.7 customizing steps - ERP Data Feed Online

[Former Member]

Actually that is all to it! The instrument and property have to be defined in the translation table so that it maps with bloomberg mnemonics.

The function module would read the input selection parameters from TBD4 and then populate in a structure all the currency pairs and interest rates to be fetched. Then it will make the bloomberg call and populate the fetched data.

You would have to define different rate types for ASK, MID, BID currencies and different reference interest rates for ASK, MID, BID interest rates for different durations. The yield curve can also be populated at the same time if the reference interest rates are assigned to a yield curve.

Hope it was helpful, if you need to know anything specific let me know.

--

[Former Member]

First of all, thanks for the information.

Did you ever made this for Bloomberg? I don't know how they provide all the data, don't know if it is similar to Finiss.

Please send me any example if you have.

Thanks again.

[Former Member]

Well, setting the configuration in SAP is the easy part. The bigger challenge would be to setup connection with the Bloomberg web services by working with the integration team in your organization. It's too technical for a functional person to do. Best way to approach would be to get the bloomberg people talk to the integration guys in your organization.

If your organization already has account with bloomberg then you can use the ID which they use to log tickets with bloomberg and log a ticket for guiding your team with the integration part. The link is www.bloomberg.com/datasolutions

If your treasury folks already uses bloomberg market data then they would know the relevant bloomberg mnemonics and bloomberg price types. You should ask them for the complete list of bloomberg mnemonics and bloomberg price types for the interest rates and currency pairs they plan to pull in the data.

A typical example for currencies could be -

Description	Mnemonic	Bloomerg Price Type (PX_MID/PX BID etc)
Spot Rates	EURUSD Curncy	PX_LAST, PX_MID, PX_BID, PX_ASK
Spot Rates	GBPUSD Curncy	PX_LAST, PX_MID, PX_BID, PX_ASK
Spot Rates	USDCHF Curncy	PX_LAST, PX_MID, PX_BID, PX_ASK

For currency deposit rates could be -

Description	Mnemonic	Bloomerg Price Type (PX_MID/PX_BID etc)
1 Week	EUDR1Z Curncy	PX_LAST, PX_MID, PX_BID, PX_ASK
1 Month	EUDRA Curncy	PX_LAST, PX_MID, PX_BID, PX_ASK
2 Month	EUDRB Curncy	PX_LAST, PX_MID, PX_BID, PX_ASK
3 Month	EUDRC Curncy	PX_LAST, PX_MID, PX_BID, PX_ASK

And finally map these mnemonics to SAP rate type in the translation table -

Hope it helped.

--

[Former Member]

One more question, how did you managed to get a HTTPA connection with Bloomberg?