openPR Logo
Press release

Simple and transparent usage of Monte-Carlo simulations in ExcelSimple and transparent usage of Monte-Carlo simulations in Excel

07-17-2012 08:00 PM CET | IT, New Media & Software

Press release from: Thetaris GmbH

/ PR Agency: talkabout communications gmbh
Theta Suite XLScreenshot (Quelle: Thetaris)

Theta Suite XLScreenshot (Quelle: Thetaris)

Thetaris releases Theta Suite XL, an innovative Monte-Carlo toolbox for Microsoft Excel

Munich, July 12, 2012 - Thetaris, a world-leading provider of modeling solutions for the financial sector, supports Excel analyses based on the Monte-Carlo simulation method with its new solution Theta Suite XL. Typical weak areas of Microsoft Excel like low performance and usability during the calculation of a large number of scenarios no longer pose a problem: Theta Suite XL defines the original simulation model outside of Excel, using the simple coding language ThetaML, which has been developed especially for Monte-Carlo simulations. Via the so-called Excel-Bridge, an Excel add-in, models can be configured and evaluated outside Microsoft Excel. So users are able to execute Monte-Carlo simulations faster, more precisely and even more transparently, especially with the valuation of financial products, in the context of corporate planning and benchmarking or for the optimization of production processes and product strategies following the six sigma method. Interested users may test-drive the novel features of Theta Suite XL in the Thetaris cloud by downloading a free demo package from the company website: http://www.thetaris.com/thetasuite/excel . The package contains Excel templates for a range of Monte-Carlo based models.
Simulations have long been established as a means for better understanding complex interrelations in theory and practice. The Monte-Carlo simulation method is a kind of stochastic simulation and works with so-called random number generators.

With the help of random numbers the computer generates a very large number of scenarios, the results of which are used in “what if” analyses for planning in a variety of domains.
Areas of application are e.g. the valuation of financial products, corporate planning and benchmarking, the assessment of project risks or the optimization of production processes and new product strategies following the six sigma method in the industry.

Microsoft Excel is often used for Monte-Carlo simulations; however, it shows significant weaknesses in usability when using higher number of simulations paths: ”Microsoft Excel is a fantastic tool for the embedding of data sources and a great one for reporting. However it is not geared towards simulation models like Monte-Carlo. For example, if you want to simulate a time series, you need the lines in the Excel spreadsheet to represent the time and the rows to fill in the different simulation paths. This often means that there is no space left for a strategy to build on this or for a second time series. But a typical simulation needs 1000 or more simulations paths, so in this case 1000 rows. Here Excel quickly reaches its limit”, explains Dr. Andreas Grau, CEO and head of sales at Thetaris. “If you want to simulate in Excel, the simulations itself can’t be filled into Excel cells.”

Theta Suite XL optimizes the use of MS Excel for simulations. The solution is based on the coding language ThetaML, which was developed especially for Monte-Carlo simulations.
This approach is easy to learn, intuitive and allows the focus on business aspects, as it shields the user from numerical problems. Via the so-called Excel-Bridge models can be opened and evaluated from Microsoft Excel and the results reported in the usual Excel layout. Based on this, any complex simulation can be handled easily.

Theta Suite XL by Thetaris enhances the user’s workflow with automatically generated interfaces that support direct values as well as cell references to the input values of the models in Excel. The Theta Debugger helps to avoid mistakes during the modeling process of the simulation, as it deeply analyzes a calculation run during development and displays information in a way that is tried and true for Excel users. Furthermore the Theta Result Explorer helps to understand the interrelations of simulation models through ready-made visualizations.

To find out how even the most complex models can easily be executed with Excel, the Excel-Bride add-in for MS Excel is ready to be downloaded for a free test-drive. The download package contains Excel templates for a range of equity models and - based on those - pricing calculators for options and fixed income products. All this can be tested directly online in the Thetaris cloud.

Theta Suite XL is available now for the creation and valuation of your own models. The freeware version for use in academic areas as well as for evaluation purposes is ready for a cost-free download. The full version for commercial use costs 1800 Euro. Interested parties may find further information here: Thetaris GmbH (www.thetaris.com/thetasuite)

Thetaris is a world-leading provider of modeling solutions for the financial sector. These solutions are designed to support quantitative analysts and actuaries to manage financial risks in the face of escalating complexity in the world of finance. To this end, Thetaris has developed a landmark method called Computer Aided Finance (CAF). Thetaris offers consulting and innovative means of intuitive modeling, detailed analysis and automated creation of financial pro-ducts. Theta Suite and Theta Proxy are its flagship products, to be applied in trading operations, development of new financial products and risk management.

Public Relations contact
Thetaris GmbH
Dr. Andreas Grau
Leopoldstr. 244
D-80807 Munich
+49 89 208039-480
E-Mail: grau@thetaris.com
http://www.thetaris.com

talkabout communications gmbh
Ursula Schemm
Balanstraße 73
D-81541 Munich
Tel.: +49 89 459954-24
E-Mail: uschemm@talkabout.de
http://www.talkabout.de

This release was published on openPR.

Permanent link to this press release:

Copy
Please set a link in the press area of your homepage to this press release on openPR. openPR disclaims liability for any content contained in this release.

You can edit or delete your press release Simple and transparent usage of Monte-Carlo simulations in ExcelSimple and transparent usage of Monte-Carlo simulations in Excel here

News-ID: 228843 • Views: 1675

More Releases from Thetaris GmbH

Risk Managment: Investment Bank Solution for Asset Manager
Maintainable, transparent models replace in-house development based on Excel-VBA Munich, April 19th - Thetaris, a world-leading provider of modeling solutions for the financial sector, releases Theta Suite Portfolio Market Risk Management. This novel risk management software solution offers asset managers and small to medium sized insurance companies the flexibility and performance which so far has only been achieved with applications tailored to major financial institutions. Users are able to comply with international
Real-Time Spreadsheet Calculations
Thetaris Theta Proxy XL provides high performance computing in MS Excel Munich, February 20. 2012 - Thetaris presents Theta Proxy XL, an Excel Add-in software that accelerates the performance of complex Excel functions, such as user-defined functions (UDF) for Monte-Carlo simulation. This software is targeted at all Excel users for whom fast calculation of formula results is essential. This includes traders at banks and other financial institutions who have to react

More Releases for Theta

Protein Kinase C Theta Market Growth Rate, Demands, Status And Application Forec …
A detailed research study on the Protein Kinase C Theta Market was recently published by UpMarketResearch. This is a latest report, covering the current COVID-19 impact on the market. The pandemic of Coronavirus (COVID-19) has affected every aspect of life globally. This has brought along several changes in market conditions. The rapidly changing market scenario and initial and future assessment of the impact is covered in the report. The report
Omnidirectional Camera Market 2019 Global Analysis and Top Key Players - Spheric …
Virtual reality experiences now can involve the use of VR devices where users can control the angle of the shot with the help of omnidirectional camera. Online experiences are also making a mark as it is easy to scroll around an image as the film on the screen. The user only need to click and drag the pointer to the direction of where the visual is needed to be seen.
Nanocoatings for Building and Construction Market Research Report 2018 | CTC Nan …
Researchmoz added Most up-to-date research on "Global Nanocoatings for Building and Construction Market Research Report 2018" to its huge collection of research reports. This report studies the global Nanocoatings for Building and Construction market status and forecast, categorizes the global Nanocoatings for Building and Construction market size (value & volume) by manufacturers, type, application, and region. This report focuses on the top manufacturers in North America, Europe, Japan, China and
Dec, 19 2017: VR Cameras Market Outlook 2023 Ricoh Theta, Kodak, Gopro, PanoTek, …
VR Cameras Market Research 2017 A market study "Global VR Cameras Market" examines the performance of the VR Cameras market 2017. It encloses an in-depth Research of the VR Cameras market state and the competitive landscape globally. This report analyzes the potential of VR Cameras market in the present and the future prospects from various angles in detail. The Global VR Cameras Market 2017 report includes VR Cameras market Revenue, market Share,
VR Cameras Market 2017 - SAMSUNG, LG, Insta360, PanoTek, Nokia OZO, Gopro, Ricoh …
Apex Research, recently published a detailed market research study focused on the "VR Cameras Market" across the global, regional and country level. The report provides 360° analysis of "VR Cameras Market" from view of manufacturers, regions, product types and end industries. The research report analyses and provides the historical data along with current performance of the global VR Cameras industry, and estimates the future trend of VR Cameras market on
VR Cameras Market Share 2017-2022: Jaunt, Kodak, Ricoh Theta, PanoTek, Bublcam, …
VR Cameras Market Research 2017 A market study ” Global VR Cameras Market ” examines the performance of the VR Cameras market 2017. It encloses an in-depth Research of the VR Cameras market state and the competitive landscape globally. This report analyzes the potential of VR Cameras market in the present and the future prospects from various angles in detail. The Global VR Cameras Market 2017 report includes VR Cameras market Revenue,