Simple and transparent usage of Monte-Carlo simulations in ExcelSimple and transparent usage of Monte-Carlo simulations in 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.
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
Dr. Andreas Grau
+49 89 208039-480
talkabout communications gmbh
Tel.: +49 89 459954-24
This release was published on openPR.
Permanent link to this press release:
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: 1618
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
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
360 Video Camera Market Huge growth by 2023 | Sphericam Inc, Panono, Bubl, Samsu …
HTF MI recently introduced Global 360 Video Camera Market study with in-depth overview, describing about the Product / Industry Scope and elaborates market outlook and status to 2023. The market Study is segmented by key regions which is accelerating the marketization. At present, the market is developing its presence and some of the key players from the complete study are Sphericam Inc, Panono, Bubl, Samsung, Theta S, Kodak, LG, Nikon,
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
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,
Global Thermal Dilatometers Market Key Players 2017 Linseis Thermal Analysis, C- …
The report titled “Global Thermal Dilatometers Market” divides the Thermal Dilatometers industry according to leading players, geographical regions, top manufacturers, types, and applications forecast over a period of 2017 to 2022. It highlights major aspects of Thermal Dilatometers industry such as market profit, top leading players, product specifications along with latest technology trends and details of upcoming industries. The report mainly wraps Thermal Dilatometers market in Europe, Thermal Dilatometers market in