Common Excel Link Problems

Excel indicates Runtime error '429' Active X component can't create object. 2. Excel does not start MATLAB automatically. 3. Your commands show up in Excel with errors. 4. Excel Link shuts down entirely, taking Excel with it. If you are having problems with Excel Link, try the following Check Excel Link Files and References 1. Check, and if necessary reinstall, the correct Excel Link files, using the Excel Tools Add-Ins function. If you have switched MATLAB versions, try the steps listed under...

Applications for Finance

Half Year Convention Macrs

Finance is a field within economics, which is devoted to the study of the capitalization of enterprises and households. By capitalization we mean the various forms of financing and operating, including borrowing debt and direct investment equity . How an enterprise is financed affects its growth prospects, its current profits, and its fair market value.296 Interest in finance has grown rapidly in the past few decades, and today there are many times more workers employed in occupations more...

Drawbacks of Matlab and Simulink

In the impressive list of attributes above, there are two notable absences easy to use and inexpensive to acquire. However, economics is about trade-offs. Through this book and others recommended here, we can help the interested reader quickly use MATLAB to perform advanced analyses and create impressive graphics. It is still harder to perform simple calculations in MATLAB than it is to perform the same tasks in a spreadsheet. It is sometimes harder to perform rudimentary analysis such as a...

Matlab Scripts and Functions

Most of the work done in the MATLAB environment is performed by command files that end in the suffix .m, such as print.m. These files may have been included as part of the MATLAB software, created by the user, or created by a third party. Because of the suffix, these files are often collectively called m-files. There are two types of m-files scripts and functions. Scripts are commands that take no argument they perform exactly the same tasks each time. Scripts operate on the data already in the...

TABLE 41 Sample Excel Sheet for Inputting Data

Variable Name Amount1 Amount2 Definition Statement Evaluation Statement 200 MLEvalString D2 toolbar. However, for repeated use of similar data, this process can be automated in the same fashion as importing data. The method for reporting your data is the same as for inputting the data with the following changes 1. Define the range of cells into which you want to place the data calculated in MATLAB. Put the ap propriate headings and related formatting items in place as well. The data cells will...

Setting Up the Matlab Workspace

The first place to start with good design is the design of the workspace. Just as it is difficult to find and complete work in a disorganized office, it is easy to work in a well-organized software environment. We suggest the following ways of organizing the MATLAB software environment. 1. Create your own startup file, which should accomplish the following a. Display any greetings or messages unique to the user. An example of this is in Chapter 1, under A Simple Startup File on page 7. b....

Introduction to Simulink Models

One of the major advantages of working within the MATLAB software environment, especially with Simulink, is the ability to comprehensively model and then simulate complex, dynamic economic phenomena. By dynamic we mean changing over time. Most problems in business economics and finance involve multiple variables that change over time. Thus, simulation models are a natural and powerful tool for these problems. Simulink is not the only environment that allows simulation modeling, and indeed we...