singaporeen
Bringing the quant research and the production data together

Bringing the quant research and the production data together

24-02-2020 | Insight

Researching, designing and implementing top-notch quantitative investment strategies requires good data sources. In order to ensure that all the necessary data is available to all quant research and investment teams, Robeco has dedicated considerable resources to upgrading its data platform over the past couple of years. We talked to Jacob Buitelaar and Richard Groenewegen about these improvements.

  • Jacob Buitelaar
    Jacob
    Buitelaar
    Co-head Portfolio Engineering & Trading Equity
  • Richard Groenewegen
    Richard
    Groenewegen
    Head of Investment Data Engineering

Speed read

  • We bring the research and the production data together in one place
  • Moving to the cloud enables us to scale our computations
  • We want to be very flexible and able to add new data sources really quickly

Could you explain the main idea behind this effort?

Jacob Buitelaar: “Our aim is to ensure that Robeco’s quantitative teams have top-notch data infrastructure at their disposal. The key idea for that is to bring the research and the production data together in one place and make it available directly and flexibly to all relevant stakeholders, including researchers and portfolio managers.”

“Doing so, we can significantly shorten time-to-market for our clients. Once we’ve researched investment ideas, we can put them into production really quickly. Moreover, making data available centrally to everyone improves the data quality and the efficiency and collaboration.”

Now also follow us on Instagram
Now also follow us on Instagram
Follow

When you talk about data, what kind of data are you talking about exactly?

Richard Groenewegen: “It starts with historical data concerning financial markets, like asset prices or transaction volumes. But it can also be sustainability-related information, or proprietary data regarding our funds’ positions and holdings, as well as transaction costs, for example. In all cases, we check the link between each piece of data and the related financial instrument. So, it’s a lot of details.”

Our teams may need to process a lot of data and we want to be able to scale our computations

OK. But, gathering information and making it available is one thing, while making sure it can be exploited is another, right?

R.G.: “Definitely. In fact, that’s the other part of what we do: we make sure that we also have the necessary processing power and the tools to analyze the data. Our teams may need to process a lot of data and we want to be able to scale our computations. That’s why we’re moving things into the cloud, where we get access to some of the most advanced tools, such as Apache Spark.”

“The cloud allows you to effectively clone or duplicate your environment, which makes it easier to have research and production all effectively on the same platform without risking any integrity issues. And because all the different teams work with exactly the same tools and the same data sets, it makes the transition from research to production much easier.”

J.B.: “Altogether, this means much more than having interconnected teams: the whole process works in exactly the same way from beginning to end. This enables both scalability and flexibility, something increasingly important as the data sets we use as input for our quantitative strategies are becoming larger, more diversified and often less structured. Just think about SEC filings or newsfeeds, for example.”

Could you illustrate with a concrete example?

R.G.: “Yes. For instance, take the cloud implementation of Robeco’s quant allocation strategies. This project had two main aspects. The first one was to have a front-to-back automation of the quant model, starting with data collection, all the necessary checks and putting the monitoring of the process in place. The second aspect was to work with new technology and to bring IT development much closer to the front office.”

“So, it was really about having a team with one foot in the front office and one foot in IT. And now, instead of running scripts and babysitting the whole process, we simply run everything automatically, with data-anomaly checking and web dashboards in place to ensure confidence in the outcome.”

“Another project we worked on during the second half of 2019 was a bottom-up reimplementation of the quantitative selection database. This database gathers stock-specific information, like historical prices, transaction volumes, company earnings estimates, accounting information, news sentiment information, ESG information, and so on and so forth. We have put a lot of focus on making it flexible, so that we can quickly add new data sources. ”

J.B.: “This is a very important aspect: we want to be very flexible and able to add new data sources really quickly. For example, if a researcher needs a new data source to be included, we want to be able to have it in the next day. And we want it to be available not just locally but for the entire research department, which requires huge processing power and cutting-edge technology.”

“In particular, we use the Databricks platform and its analytics engine Apache Sparks. Doing so, we can have hundreds of computers available within five minutes working on the same problem. That’s several terabytes of main memory that we can use flexibly. We also work very closely with Databricks to ensure that features and performance of the platform that are specific to our use case get the right attention on their development agenda.”

What are your projects for this year?

R.G.: “We may slightly shift our focus towards the computation side of things to enable faster processing of large datasets as well as machine learning. We’ll also likely add more data sources, including further sustainability-related information or insights from our fundamental analysts, for example. Also, we will be looking to extend the quantitative selection database with credit data and even more detailed information.”

Indeed, Robeco uses equity signals for credit strategies and vice versa. Is that an issue?

J.B.: “Not at all. In fact, this is one of the key benefits of our new platform: instead of having separate infrastructures for each capability, we gather everything in one place. Because our investment strategies combine cross-asset signals, it is really useful to have them all together. This way we can link instruments and use signals from one asset class or the other.”

Any other project you may want to mention?

R.G.: “We are also helping to create a tool to automate the customization of Robeco’s Core Quant Equity strategies. This would enable clients to configure a personalized portfolio reflecting their risk, return and sustainability preferences in real time. It would allow them to understand better tradeoffs between various options and to see the effect of changing some existing portfolio settings.”

So, in a way, it would be a bit like for the automobile industry, where you can customize your car online and see the end result directly on your screen, right?

R.G.: “Exactly. We observe a trend that once investors have chosen their index, they are looking for the best way to enhance that index as an alternative for a pure replication, or passive, approach while staying close to that index. With this tool, clients can see directly the impact of their choices on the portfolio characteristics.”

Important information

This information is for informational purposes only and should not be construed as an offer to sell or an invitation to buy any securities or products, nor as investment advice or recommendation.
The contents of this document have not been reviewed by the Monetary Authority of Singapore (“MAS”). Robeco Singapore Private Limited holds a capital markets services license for fund management issued by the MAS and is subject to certain clientele restrictions under such license.
An investment will involve a high degree of risk, and you should consider carefully whether an investment is suitable for you.

Subjects related to this article are:
Logo

Important Information

Warning/Important note: This website contains information which is only available to qualified investors as defined below. If you are not a qualified investor, please click “I Disagree” to leave the website.

By clicking on "I agree", I declare that: 

  • I am a qualified investor as defined under 1
  • I have read and understood the Terms and Conditions and Disclaimers as described under 2

1 - This website may only be accessed directly or indirectly by the following persons in Singapore:

1) “institutional investor” under section 304 of the Securities and Futures Act (Cap.289)(“SFA”), which means:
(i) the Government; (ii) a statutory board as may be prescribed by regulations made under section 341 of the SFA; (iii) an entity that is wholly and beneficially owned, whether directly or indirectly, by a central government of a country and whose principal activity is (A) to manage its own funds; (B) to manage the funds of the central government of that country (which may include the reserves of that central government and any pension or provident fund of that country); or (C) to manage the funds (which may include the reserves of that central government and any pension or provident fund of that country) of another entity that is wholly and beneficially owned, whether directly or indirectly, by the central government of that country; (iv) any entity (A) that is wholly and beneficially owned, whether directly or indirectly, by the central government of a country; and (B) whose funds are managed by an entity mentioned in sub-paragraph (iii); (v) a central bank in a jurisdiction other than Singapore; (vi) a central government in a country other than Singapore; (vii) an agency (of a central government in a country other than Singapore) that is incorporated or established in a country other than Singapore; (viii) a multilateral agency, international organisation or supranational agency as may be prescribed by regulations made under section 341 of the SFA; (ix) a bank that is licensed under the Banking Act (Cap.19); (x) a merchant bank that is approved as a financial institution under section 28 of the Monetary Authority of Singapore Act (Cap.186); (xi) a finance company that is licensed under the Finance Companies Act (Cap.108); (xii) a company or co-operative society that is licensed under the Insurance Act (Cap.142) to carry on insurance business in Singapore; (xiii) a company licensed under the Trust Companies Act (Cap.336); (xiv) a holder of a capital markets services licence; (xv) an approved exchange; (xvi) a recognised market operator; (xvii) an approved clearing house; (xviii) a recognised clearing house; (xix) a licensed trade repository; (xx) a licensed foreign trade repository; (xxi) an approved holding company; (xxii) a Depository as defined in section 81SF of the SFA; (xxiii) an entity or a trust formed or incorporated in a jurisdiction other than Singapore, which is regulated for the carrying on of any financial activity in that jurisdiction by a public authority of that jurisdiction that exercises a function that corresponds to a regulatory function of the Authority under this Act, the Banking Act (Cap.19), the Finance Companies Act (Cap.108), the Monetary Authority of Singapore Act (Cap.186), the Insurance Act (Cap.142), the Trust Companies Act (Cap.336) or such other Act as may be prescribed by regulations made under section 341 of the SFA; (xxiv) a pension fund, or collective investment scheme, whether constituted in Singapore or elsewhere; (xxv) a person (other than an individual) who carries on the business of dealing in bonds with accredited investors or expert investors; (xxvi) the trustee of such trust as the Authority may prescribe, when acting in that capacity; or; (xxvii) such other person as the Authority may prescribe.

2) “relevant person” under section 305(1) of the SFA, which means:
(i) An accredited investor; (ii) a corporation the sole business of which is to hold investments and the entire share capital of which is owned by one or more individuals, each of whom is an accredited investor; (iii) a trustee of a trust the sole purpose of which is to hold investments and each beneficiary of which is an individual who is an accredited investor; (iv) an officer or equivalent person of the person making the offer (such person being an entity) or a spouse, parent, brother, sister, son or daughter of that officer or equivalent person; or (v) a spouse, parent, brother, sister, son or daughter of the person making the offer (such person being an individual).

3) any person who acquires the units [in a collective investment scheme] as principal if the offer is on terms that the units may only be required at a consideration of not less than $200,000 (or its equivalent in a foreign currency) for each transaction, whether such amount is to be paid for in cash or by exchange of units in a collective investment scheme, securities, securities-based derivatives contracts or other assets, and if the following condition is satisfied: (i) the offer is not accompanied by an advertisement making an offer or calling attention to the offer or intended offer; (ii) no selling or promotional expenses are paid or incurred in connection with the offer other than those incurred for administrative or professional services, or by way of commission or fee for services rendered by any of the persons specified in section 302B(1)(d)(i) to (vi) of the SFA; and (iii) no prospectus in respect of the offer has been registered by the Authority or, where a prospectus has been registered (A) the prospectus has eAccxpired pursuant to section 299 of the SFA; or (B) the person making the offer has before making the offer 1. informed the Authority by notice in writing of its intent to make the offer in reliance on the exemption under this subsection; and 2. taken reasonable steps to inform in writing the person to whom the offer is made that the offer is made in reliance on the exemption under this subsection.

4) Or otherwise pursuant to, and in accordance with the conditions of, any other applicable provision of the SFA.

If you are not any of the types of persons described above, you are not authorized to enter this website and you should leave this website immediately.

2 Terms and Conditions
You acknowledge that you have read these Terms and Conditions (“Terms”) prior to accessing the website located at www.robeco.com/sg (“Website”) and you agree to be bound by the Terms.  If you do not agree to all of the Terms, you are not an authorised user and you should not use the Website. The Website is owned by Robeco Singapore Private Limited (company registration number: UEN. 201541306Z), which is licensed by the Monetary Authority of Singapore (“MAS”) pursuant to the Securities and Futures Act (Cap.289) (“SFA”) of Singapore, and is managed by Robeco Singapore Private Limited and/or its affiliates (collectively, as “Robeco”). The Website is intended for and should be accessed by institutional investors or accredited investors (as defined under Section 4A of the SFA) of Singapore.  The Website is not directed to, or intended for distribution to or use by, any person or entity who is a citizen or resident of or located in any locality, state, country or other jurisdiction where such distribution, publication, availability or use would be contrary to law or regulation or which would subject the Robeco to any registration or licensing requirement within such jurisdiction.  It is your responsibility to observe all applicable laws, rules and regulations of any relevant jurisdiction. The content contained in the Website is owned by Robeco and/or its information providers and is protected by applicable copyrights, trademarks, service marks, and/or other intellectual property rights.  You may not copy, distribute, modify, post, frame or link the Website, including any text, graphics, video, audio, software code, user interface, design or logos.  You may not distribute, modify, transmit, reuse, repost, or use the content of the Website for public or commercial use, including all text, images, audio and/or video.  Robeco may terminate your access to the Website for any reason, without prior notice. Neither Robeco, nor any of its associates, nor any director, officer or employee accepts any liability whatsoever for any loss arising directly or indirectly from the access of the Website.  You agree to indemnity and hold Robeco, its associates, directors, officers or employees harmless against any and all claims, losses, liability, costs and expenses arising from your use of the Website due to violation of the Terms. Robeco reserves the right to change, modify, add or remove any parts of the Terms at any time and for any reason.  The Terms shall deemed to be effective immediately upon posting. The Terms shall be governed by, and shall be construed in accordance with, the law of Singapore.

Disclaimers
The Website has not been reviewed by the MAS. Accordingly, the Website may not be accessed directly or indirectly to persons in Singapore other than (i) to an institutional investor under Section 304 of the SFA, (ii) to a relevant person pursuant to Section 305(1), or any person pursuant to Section 305(2), and in accordance with the conditions specified in Section 305, of the SFA, or (iii) otherwise pursuant to, and in accordance with the conditions of, any other applicable provision of the SFA. 

Nothing in the Website constitutes tax, accounting, regulatory, legal or investment advice.  The Website is for informational purposes only and should not be construed as an offer to sell or an invitation to buy any securities or products, nor as investment advice or recommendation or for the purpose of soliciting any action in relation to Robeco’s businesses, or solicitation by anyone in any jurisdiction in which such an offer or solicitation is not authorised or to any person to whom it is unlawful to make such an offer and solicitation. Any reproduction or distribution of information from the Website, in whole or in part, or the disclosure of its contents, without the prior written consent of Robeco, is prohibited.  By accessing to the Website, you agree to the foregoing.  

The funds referred to in the Website are for information only.  It is not a recommendation or investment advice, nor does it mean the funds is suitable for all investors.  The contents of the website is not reviewed by the MAS.  Any decision to participate in the funds should be made only after reviewing the sections regarding investment considerations, conflicts of interest, risk factors and the relevant Singapore selling restrictions.  You should consult your professional adviser if you are in doubt about the stringent restrictions applicable to the use of the Website, regulatory status of the funds, applicable regulatory protection, associated risks and suitability of the funds to your objectives.

Any decisions made based on the information contained in the Website are the sole responsibility of yours.  Any investments made or to be made shall be with your independent analyses based on your financial situation and objectives.  The investments and strategies contained in the Website may not be suitable for all investors and are not guaranteed by Robeco.  

Investment involves risks and may lose value.  Historical returns are provided for illustrative purposes only and do not necessarily reflect Robeco’s expectations for the future.  The value of your investments may fluctuate.  Past performance is no indication of current or future performance.  The Website may contain projections or other forward looking statements regarding future events or future financial performance of countries, markets or companies and such projection or forecast is not indicative of the future.  The information contained in the Website, including any data, projections and underlying assumptions are based upon certain assumptions, management forecasts and analysis of information available on an “as is” basis and without warranties of any kind, whether express or implied, and reflects prevailing conditions and Robeco’s views as of the date published or indicated, and maybe superseded by subsequent events or for other reasons.  The information contained in the Website are accordingly subject to change at any time without notice and Robeco are under no obligation to notify you of any of these changes.  Robeco expressly disclaims all liability for errors and omissions in the information presented in the Website and for the use or interpretation by others of information contained in the Website.

Robeco Singapore Private Limited holds a capital markets services licence for fund management issued by the MAS and is subject to certain clientele restrictions under such licence.  An investment will involve a high degree of risk, and you should consider carefully whether an investment is suitable for you.

I Disagree