Have anyone managed to automate data consolidation between Reuters and Bloomberg for Options on Futures? Are there any common attributes that these vendors share in this particular asset class that can be used to match the Options?
Thanks, Kishore.
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It only takes a minute to sign up.
Sign up to join this communityHave anyone managed to automate data consolidation between Reuters and Bloomberg for Options on Futures? Are there any common attributes that these vendors share in this particular asset class that can be used to match the Options?
Thanks, Kishore.
I think the best you may be able to do here is creating your own unique identifier in your code based off underlying, maturity date, put or call, and strike price, and then match the two data sources on that key. The only identifier Bloomberg seems to have for options on futures is their FIGI number, and I'm doubtful that Reuters supports that.
Here's an example key with common attributes you could create in your code: CLX5 10/15/15 C44.0. WTI crude oil call option expiring in October struck at 44.