“A key deciding factor for us was definitely the solver performance.”Matthias Wyss
Head of ImpaQt Consulting, swissQuant
When it comes to meeting the needs of private banking customers, recommending the right portolfio of investments for each customer is of critical importance. Not only must the customer’s objectives, risk profile and available assets be taken into account, but the bank itself must adhere to both bank and regulatory policies when creating the possible portfolios to choose from. Making this more complex is that the recommendations must be generated within a reasonable amount of time and the customer must feel like they are an involved and important part of the process.
Given the above requirements and the in-person interaction, an acceptable amount of time for the customer to wait for the solution is not half a day or half an hour, but only a few seconds. Not only is the customer’s time valuable, but the proposed portfolio must also be robust enough that it does not significantly change even if the customer inputs are slightly modified. Powerful and efficient algorithms must be used when calculating the optimal portfolios to ensure timely results that both the customer and bank can have confidence in. This difficult task was carried out at swissQuant with Gurobi.
“A key deciding factor for us was definitely the solver performance,” states Matthias Wyss, Head of ImpaQt Consulting at swissQuant. “When the project first began, another commercial solver was used at first, but it quickly reached its limits. We finally decided on Gurobi, which scored points for its speed, scalability and robustness. Gurobi’s quality sets it apart,” explains Matthias Wyss.
Gurobi is embedded in a complex application, where the first step is to create a customer profile. In this profile, opportunities and risks are presented interactively, and stress tests are run in order to understand the bank risks. From there, additional restrictions from the customer are added in, as well as general rules and conditions from the bank.
At this point, Gurobi solves the consequent mathematical optimization model, in which the portfolio will be optimized to maximize the rate of return subject to risk limits. Once the model is solved, health checks and pre-trade checks are ran to see how the decision might differ based on various factors. Finally, the optimized portfolio showing several investment strategies is presented to the customer, along with their risks and prospective benefits.
There are many ways to structure a portfolio. You can formulate this solution space as a mathematical optimization problem and optimize it with respect to target function. Portfolio optimization is characterised by a quadratic objective function with 1,000 to 10,000 variables and almost as many additional linear conditions. Also, some of the variables must only be represented as integer values, which results in a mixed-integer quadratic problem (MIQP). Gurobi solves the MIQPs in a few seconds, which is essential in a situation where the bank representative interacts with a customer face-to-face, and they both expect to see quality, reliable solutions right away.
The swissQuant Group has carried out various tests and arrived at the following results: Gurobi finds a solution for 98% of the feasible problems within 20 seconds. The competitor could only achieve solution times of less than 20 seconds for 38% of the models. A feasible problem in this case is a portfolio optimization for which there is at least one solution and which fulfils all restrictions.
In 7% of feasible problems, Gurobi was able to find a solution that would bring the customer a 1% higher return on their portfolio compared to the competitor solution. In total, Gurobi found the optimum solution for 90% of the test problems, whereas the competitor could only do this for 55% of problems.
“It was not a difficult decision to switch over to Gurobi after seeing these impressive numbers.The Gurobi interfaces set themselves apart in that they are simple and intuitive to use, and the application works well with large models. The Gurobi technical support team is available to help answer all of our questions, which is an extra time-saving benefit, in addition to the solver’s performance and the quick implementation process,” explains Matthias Wyss.
The swissQuant Group was established in 2005. It was originally founded as a spin-off of ETH Zürich. It tasks close to 100 employees with Risk Modelling & Analytics, Trading & Risk Management and Hedging & Procurement.
Its customers include clearing houses and both Swiss and international banks.
swissQuant Group AG
+41 43 244 75 85
Choose the evaluation license that fits you best, and start working with our Expert Team for technical guidance and support.
Request free trial hours, so you can see how quickly and easily a model can be solved on the cloud.
|_biz_flagsA||1 year||A Cloudflare cookie set to record users’ settings as well as for authentication and analytics.|
|_biz_pendingA||1 year||A Cloudflare cookie set to record users’ settings as well as for authentication and analytics.|
|_biz_sid||30 minutes||This cookie is set by Bizible, to store the user's session id.|
|ARRAffinity||session||ARRAffinity cookie is set by Azure app service, and allows the service to choose the right instance established by a user to deliver subsequent requests made by that user.|
|ARRAffinitySameSite||session||This cookie is set by Windows Azure cloud, and is used for load balancing to make sure the visitor page requests are routed to the same server in any browsing session.|
|cookielawinfo-checkbox-advertisement||1 year||Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .|
|cookielawinfo-checkbox-analytics||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".|
|cookielawinfo-checkbox-functional||11 months||The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".|
|cookielawinfo-checkbox-necessary||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".|
|cookielawinfo-checkbox-others||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.|
|cookielawinfo-checkbox-performance||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".|
|CookieLawInfoConsent||1 year||Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.|
|elementor||never||This cookie is used by the website's WordPress theme. It allows the website owner to implement or change the website's content in real-time.|
|JSESSIONID||session||New Relic uses this cookie to store a session identifier so that New Relic can monitor session counts for an application.|
|__cf_bm||30 minutes||This cookie, set by Cloudflare, is used to support Cloudflare Bot Management.|
|_biz_nA||1 year||Bizible sets this cookie to remember users’ settings as well as for authentication and analytics.|
|_biz_uid||1 year||This cookie is set by Bizible, to store user id on the current domain.|
|_hjAbsoluteSessionInProgress||30 minutes||Hotjar sets this cookie to detect a user's first pageview session, which is a True/False flag set by the cookie.|
|_mkto_trk||2 years||This cookie is set by Marketo. This allows a website to track visitor behavior on the sites on which the cookie is installed and to link a visitor to the recipient of an email marketing campaign, to measure campaign effectiveness. Tracking is performed anonymously until a user self-identifies by submitting a form.|
|bcookie||1 year||LinkedIn sets this cookie from LinkedIn share buttons and ad tags to recognize browser ID.|
|bscookie||1 year||LinkedIn sets this cookie to store performed actions on the website.|
|doc_langsBB||1 year||Documentation system cookie|
|doc_version||1 year||Documentation system cookie|
|lang||session||LinkedIn sets this cookie to remember a user's language setting.|
|lidc||1 day||LinkedIn sets the lidc cookie to facilitate data center selection.|
|UserMatchHistory||1 month||LinkedIn sets this cookie for LinkedIn Ads ID syncing.|
|whova_client_id||10 years||Event agenda system cookie|
|_gat_UA-5909815-1||1 minute||A variation of the _gat cookie set by Google Analytics and Google Tag Manager to allow website owners to track visitor behaviour and measure site performance. The pattern element in the name contains the unique identity number of the account or website it relates to.|
|_an_uid||7 days||6Sense Cookie|
|_BUID||1 year||This cookie, set by Bizible, is a universal user id to identify the same user across multiple clients’ domains.|
|_ga||2 years||The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors.|
|_ga_*||1 year 1 month 4 days||Google Analytics sets this cookie to store and count page views.|
|_gat_UA-*||1 minute||Google Analytics sets this cookie for user behaviour tracking.|
|_gcl_au||3 months||Provided by Google Tag Manager to experiment advertisement efficiency of websites using their services.|
|_gd_session||4 hours||This cookie is used for collecting information on users visit to the website. It collects data such as total number of visits, average time spent on the website and the pages loaded.|
|_gd_visitor||2 years||This cookie is used for collecting information on the users visit such as number of visits, average time spent on the website and the pages loaded for displaying targeted ads.|
|_gid||1 day||Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously.|
|_hjFirstSeen||30 minutes||Hotjar sets this cookie to identify a new user’s first session. It stores the true/false value, indicating whether it was the first time Hotjar saw this user.|
|_hjIncludedInSessionSample_*||2 minutes||Hotjar cookie that is set to determine if a user is included in the data sampling defined by a site's daily session limit.|
|_hjRecordingEnabled||never||Hotjar sets this cookie when a Recording starts and is read when the recording module is initialized, to see if the user is already in a recording in a particular session.|
|_hjRecordingLastActivity||never||Hotjar sets this cookie when a user recording starts and when data is sent through the WebSocket.|
|_hjSession_*||30 minutes||Hotjar cookie that is set when a user first lands on a page with the Hotjar script. It is used to persist the Hotjar User ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.|
|_hjSessionUser_*||1 year||Hotjar cookie that is set when a user first lands on a page with the Hotjar script. It is used to persist the Hotjar User ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.|
|_hjTLDTest||session||To determine the most generic cookie path that has to be used instead of the page hostname, Hotjar sets the _hjTLDTest cookie to store different URL substring alternatives until it fails.|
|6suuid||2 years||6Sense Cookie|
|AnalyticsSyncHistory||1 month||LinkedIn cookie|
|BE_CLA3||1 year 1 month 4 days||BrightEdge sets this cookie to enable data aggregation, analysis and report creation to assess marketing effectiveness and provide solutions for SEO, SEM and website performance.|
|CONSENT||2 years||YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.|
|dj||10 years||DemandJump cookie|
|djaimid.a28e||2 years||DemandJump cookiean|
|djaimses.a28e||30 minutes||DemandJump cookie|
|li_gc||5 months 27 days||LinkedIn Cookie|
|ln_or||1 day||LinkedIn Cookie|
|vuid||2 years||Vimeo installs this cookie to collect tracking information by setting a unique ID to embed videos to the website.|
|__adroll||1 year 1 month||This cookie is set by AdRoll to identify users across visits and devices. It is used by real-time bidding for advertisers to display relevant advertisements.|
|__adroll_fpc||1 year||AdRoll sets this cookie to target users with advertisements based on their browsing behaviour.|
|__adroll_shared||1 year 1 month||Adroll sets this cookie to collect information on users across different websites for relevant advertising.|
|__ar_v4||1 year||This cookie is set under the domain DoubleClick, to place ads that point to the website in Google search results and to track conversion rates for these ads.|
|_fbp||3 months||This cookie is set by Facebook to display advertisements when either on Facebook or on a digital platform powered by Facebook advertising, after visiting the website.|
|fr||3 months||Facebook sets this cookie to show relevant advertisements to users by tracking user behaviour across the web, on sites that have Facebook pixel or Facebook social plugin.|
|IDE||1 year 24 days||Google DoubleClick IDE cookies are used to store information about how the user uses the website to present them with relevant ads and according to the user profile.|
|li_sugr||3 months||LinkedIn sets this cookie to collect user behaviour data to optimise the website and make advertisements on the website more relevant.|
|test_cookie||15 minutes||The test_cookie is set by doubleclick.net and is used to determine if the user's browser supports cookies.|
|VISITOR_INFO1_LIVE||5 months 27 days||A cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.|
|YSC||session||YSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.|
|yt-remote-connected-devices||never||YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.|
|yt-remote-device-id||never||YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.|
|yt.innertube::nextId||never||This cookie, set by YouTube, registers a unique ID to store data on what videos from YouTube the user has seen.|
|yt.innertube::requests||never||This cookie, set by YouTube, registers a unique ID to store data on what videos from YouTube the user has seen.|