Excel Model For Portfolio Optimization

Optimized Step Size Random Search(OSSRS) A random search method[1] for the optimization of a function of n variables. Can be used as a start-up before using a determistic method like Simplex method of Nelder and Mead to arrive at the region of the optimum and then switch to a deterministic...

Please see PORTOPTGADS, by following link 'Published m-files' below.PS. The cool picture is a visualization of Rastrigin's function, taken from Genetic Algorithm and Direct Search Toolbox documentation.

A Matlab reference implementation of a novel semi-analytical signal processing model for the binaural coherence of homogeneous isotropic noise fields is presented.The model is derived from a simplified geometrical model of the human head, where the shadowing between the left and right ear is...


Platforms: Matlab

Model for Soft Independent Modeling of Class Analogy (SIMCA) simca_model=simca(x,classes) input: x (samples x descriptors) for calibration classes (samples x 1) classes numbers (must be >0) output: simca_model struct with: models (1 x No. classes) struct with: (one for each class) x (samples x...


Platforms: Matlab

Newhall is a Java implementation of Franklin Newhall's model for soil moisture regime determination. This implementation stems directly from the Wambeke BASIC version of the Newhall simulation model, which was a BASIC reimplementation of the original COBOL version. The model functions by taking...


Platforms: Mac

This is the exact model for any normal game of Snake. However, mine has an extra component to increase the difficult, and try to adhere to my chosen achievement. You have a countdown timer that, if it reaches 0, will record your movement until you eat a new pellet, at which point a stationary...


Platforms: Mac

The Voronoi Game is a simple geometric model for the competitive facility location. Competitive facility location studies the placement of sites by competing market players. The geometric concepts are combined with game theory arguments to study if there exists any winning strategy. The Voronoi...


Platforms: Mac

With Model Builder for Excel you can perform fast and accurately repetitive and time consuming tasks, such as transposing linked formulas, if formulas, consolidating sheets, consolidate ranges, swapping data, etc. Model Builder for Excel will allow you to audit, understand and analyze any...


Platforms: Windows

Model Assistant Suite is the most useful collection of add-ins for people who uses Excel as a decision making tool: to build, review, analyze and present more robust models, quicker. BUILD: To develop and format professionally your Excel models is now easier with Model Builder for Excel !! AUDIT:...


Platforms: Windows

Stock Quotes for Excel is a powerfull Add-in for Excel that allows you to update Stock Quotes automatically, Market Indexes and Mutual Funds into your Excel spreadsheets - via Internet. No more manual and tedious updates. No more risk of using outdated data. It seamlessly integrates to Microsoft...


Platforms: Windows

Tools for Excel Tables is a set of tools that will strengthen your Microsoft Excel to manage data bases and huge tables in your spreadsheets. Tools for Excel Tables is an addin that combines the functionalities of Microsoft Excel in order to create more robust functionalities which let you...


Platforms: Windows

1DCutX is the length cutting optimization add-in for Microsoft Excel. It finds how to cut one-dimensional (1D) linear stocks (bars, pipes, beams, wires, etc.) in order to minimize the material waste and the cost without leaving Microsoft Excel. It reads the spreadsheets, performs the optimization...


Platforms: Windows

Picture Manager for Excel is intuitive and user friendly add-in for Microsoft Excel, designed primarily for business users to assist in easily inserting multiple images (automatically sized to fit cells) into single or multiple Excel spreadsheets at once. Additional advantageous features include:...


Platforms: Windows, Windows 8, Windows 7

Export Query to Excel for Microsoft SQL Server helps to save results of a query execution to Excel spreadsheet. The program has easy to use wizard interface. All modern versions of Microsoft SQL Server and all versions of Microsoft Excel are supported. A few options make export process more...


Platforms: Windows

The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions...


Platforms: Windows

Track your project expenses effectively and increase profits!. Construction Job Cost Tracking and Reporting System for Excel. Designed specifically for contractors, builders, remodelers, project managers, cost engineers and architects, JobCOST Controller tracks construction costs tied to...


Platforms: Windows

Files used in the Webinar: Build a Portfolio Analysis Production Application in MATLAB using Object-Oriented Programming Techniques.The focus of this demo is to introduce the design and development of a complete MATLAB application from concept through to completion. The GUI-based tool provides...


Platforms: Matlab

Make paint cost estimating productive and fun with this easy-to-use software! Designed specifically for painting and wallcovering contractors, decorators, builders, remodelers, and do-it-yourself individuals. PaintCOST Estimator contains industry-standard user modifiable cost data and...


Platforms: Windows

The Portfolio Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a...


Platforms: Windows

Enhance your productivity and accuracy with this easy-to-use software! Designed specifically for roofing contractors, builders, remodelers, and do-it-yourself individuals. RoofCOST Estimator contains industry-standard user modifiable cost data and intelligent takeoff area calculator with...


Platforms: Windows