Macro-Investment Analysis in Excel
Edit Page
Report
Scan day: 07 February 2014 UTC
39
Virus safety - good
Description: Using named ranges and matrix operations. William Sharpe, Stanford.
spreadsheet program provides an alternative environment for many of the computations required for Macro-Investment Analysis. Its ubiquity and ease of use are among its more attractive features. However, spreadsheets are notoriously dangerous, since the underlying logic of a set of calculations is usually contained in formulas scattered around a sheet (or sheets). Worse yet, the formulas are usually hidden from sight, behind the numbers representing the results of their calculations. These disadvantages loom especially large when an environment is to be chosen primarily as a means of communication. For our purposes, languages such as MATLAB are superior to a spreadsheet environment -- Excel or any other.
Size: 712 chars
Contact Information
Email: —
Phone&Fax: —
Address: —
Extended: —
WEBSITE Info
Page title: | Excel |
Keywords: | |
Description: | |
IP-address: | 171.67.215.200 |
WHOIS Info
NS | Name Servers: ARGUS.STANFORD.EDU 171.64.7.115, 2607:f6d0:0:9113::ab40:773 AVALLONE.STANFORD.EDU 171.64.7.88, 2607:f6d0:0:9116::ab40:758 |
WHOIS | |
Date | activated: 04-Oct-1985 last updated: 07-May-2009 expires: 31-Jul-2014 |