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:

More Releases from Thetaris GmbH

Risk Managment: Investment Bank Solution for Asset Manager
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
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

Global F-Theta Lenses Market Research Report 2022-GEOMATEC, Jenoptik
Los Angeles, United States: The report comes out as an intelligent and thorough assessment tool as well as a great resource that will help you to secure a position of strength in the global F-Theta Lenses market. It includes Porter's Five Forces and PESTLE analysis to equip your business with critical information and comparative data about the Global F-Theta Lenses Market. We have provided a deep analysis of the vendor landscape to
Global F-Theta Scanning Lenses Market Research Report 2022-GEOMATEC, Jenoptik
Los Angeles, United States: The report comes out as an intelligent and thorough assessment tool as well as a great resource that will help you to secure a position of strength in the global F-Theta Scanning Lenses market. It includes Porter's Five Forces and PESTLE analysis to equip your business with critical information and comparative data about the Global F-Theta Scanning Lenses Market. We have provided a deep analysis of the vendor
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
Global Nanocoatings Market for Building and Construction Industry 2017-2021 | Th …
Nanocoatings coat surfaces with nanostructures that form a uniform network of molecules. The thickness of these coatings is measured in nanoscales. The global nanocoatings market for the building and construction industry to grow at a CAGR of 20.41% during the period 2017-2021. The report covers the present scenario and the growth prospects of the global nanocoatings market for the building and construction industry for 2017-2021. To calculate the market size, the
Nanocoatings | CAGR 20% by 2021 : Leading Vendors - CTC Nanotechnology, Theta Ch …
Press Release - 13 Mar 2018 Global Research and Development News -- . . Report Description- '
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