Showing posts sorted by date for query computers. Sort by relevance Show all posts
Showing posts sorted by date for query computers. Sort by relevance Show all posts

Monday, April 23, 2012

The Virtual Economy Hits Jobs

According to Bill Davidow of the Atlantic (2012, April 10), the impact of the emerging virtual economy on jobs introduces some interesting arithmetic with regard to labor productivity and jobs:
Walmart has some two million employees, and annual sales of around $200 billion. Given that many work part-time, I figure that the company has sales of around $100,000 per employee. With 56,000 employees in 2011, Amazon generated a little over $800,000 per employee.... Here's the challenge: In the past, every million-dollar increase in economic output generated on the order of ten jobs. In the future..., it may generate only one or two.
Read More


If we accept that firms such as Amazon are the business models for the future economy, then the future of jobs in America gets gloomy fast. The only safe haven for labor is to acquire high productivity skills that earn premium wages in the still emerging virtual economy.

Source: Davidow, B (2012, April 10), How Computers Are Creating a Second Economy Without Workers, Atlantic.

Related Posts

Thursday, September 01, 2011

Imagining Mathematics

Read below the pedagogical proposition by Dr Sol Garfunkel and Prof David Mumford (2011) regarding pragmatic approaches for teaching and learning mathematics:
Imagine replacing the sequence of algebra, geometry and calculus with a sequence of finance, data and basic engineering. In the finance course, students would learn the exponential function, use formulas in spreadsheets and study the budgets of people, companies and governments. In the data course, students would gather their own data sets and learn how, in fields as diverse as sports and medicine, larger samples give better estimates of averages. In the basic engineering course, students would learn the workings of engines, sound waves, TV signals and computers. Science and math were originally discovered together, and they are best learned together now.
Mathematics is at once, symbolic, real, and conceptual for some -- I tend to agree. Dr Garfunkel is the executive director of the Consortium for Mathematics and its Applications (COMAP). Follow the link below to learn more about COMAP's activities.

COMAP

Source: Garfunkel, S & Mumford, D (2011, August 21), How to Fix Our Math Education, New York Times Online.

Related Posts

Thursday, May 19, 2011

ModelRisk 4.0 Standard Available Free

ModelRisk 4.0 Standard (Vose) is now available free – that’s right – free! ModelRisk was already the best-in-class decision modeling and risk analytics add-in accessory for Excel (Microsoft). However, the latest update, ModelRisk 4.0 Standard, is now available for free download as well.


Every serious Excel user will want to download and install ModelRisk 4.0 Standard onto their personal computers in order to activate the following advanced analytical functions in Excel:
  • Stochastic (Monte Carlo) simulations
  • Sensitivity analysis
  • Scenario analysis
  • Bounded, shifted distributions
  • Correlations between distributions
  • One-click function views
  • ModelRisk functions searches and formatting tool
  • Capacity to run external macros before, during, and after simulations
  • VBA and C++ calls to ModelRisk functions
  • Graphical simulation reporting
  • Descriptive statistical reporting
  • Capacity to view and simulation results as worksheets and workbooks
  • Versatile exporting tools
  • Unrestricted speed and model size
  • Capacity to save results in a sharable Results Viewer format
  • Conversion capabilities from other Monte Carlo add-ins tools
  • Extensive help files with example models and literature references covering every feature of ModelRisk 4.0 in detail
Graduate students in particular will find ModelRisk 4.0 Standard to be especially useful for analytics research and coursework -- the fact that ModelRisk 4.0 Standard is now free software (with a perpetual license) makes the case for adding ModelRisk 4.0 to your analytics workstation overwhelming.

Follow the link below to download a free and fully functional copy of ModelRisk 4.0 Standard now.

Learn More

PS: Please help me to get the word out about this exciting free edition of ModelRisk 4.0 Standard by forwarding this post to the expert analysts you work with using the sharing tools below, thanks...

Tuesday, April 12, 2011

Making Software Fun to Learn

Remember the days when learning to program and using software was fun? The logo below speaks volumes about what I am asking:


Beagle Bros software was produced for the Apple II line of computers back in the 1980's. The Beagle Bros catalog included a wide variety of comical software programs, utilities, and code snippets that appealed to both expert programmers and hobbyists alike. What made Beagle Bros unique was that their software was fun! The eventual replacement of the venerable Apple II with mightier machines eventually lead to the sunset of Beagle Bros as a software publishing firm. However, the Beagle Bros spirit and legacy lives on within many of us "old-timers" who learned to program while having fun on our Apple II computers back when desktops were still new.

These days, I make my living with Microsoft software solutions, which are generally a bore to learn and use. Thinking back, I miss the fun I had 30-years ago learning to program on my Apple II, including Beagle Bros software.

Follow the link below to learn more about the Beagle Bros legacy and contributions to desktop computing:

Beagle Bros Software Repository

PS: Microsoft should consider releasing a "fun version" of Visual Studio, if only for hobbyists...

Sunday, September 05, 2010

Education of a Computer Programmer

I came across a photogragh of my first personal computer purchased back in 1983 -- the Apple //e -- and suddenly found myself reminiscing about how I became a computer user. The Apple //e was powered by the venerable MOS Technology 6502 8-bit microprocessor running at 1.023 MHz, and boasted 128 kilobytes of RAM. I recall taking a $2,500 personal loan to make the purchase, which included the hardware shown below along with an Apple Imagewriter dot-matrix printer.


I spent many hours programming and otherwise "playing" on my Apple //e during the mid-1980's. What I did not know at the the time was how important computer technology would become for me and my career. I essentially taught myself to program on the Apple //e at home, and would later build upon what I had learned as I migrated onto more powerful machines in subsequent years. However, my education about personal computers definitely started on the Apple //e computer, and my life has not been the same since.

My how computer technology has evolved.

Sunday, June 06, 2010

The Evolution of Decision Analysis

by Ronald A Howard © The Stanford Decisions and Ethics Center

Although decision analysis has developed significantly over the last two decades, the basic principles of the field have served well. They are unlikely to change because they are based on simple logic. In the first part of this paper, we summarize the original, fundamental disciplines of decision analysis; in the second part, we show how the discipline has evolved.

PART I: A BRIEF DESCRIPTION OF DECISION ANALYSIS

Making important decisions often requires treating major uncertainty, long time horizons, and complex value issues. To deal with such problems, the discipline of decision analysis was developed. The discipline comprises the philosophy, theory, methodology, and professional practice necessary to formalize the analysis of important decisions.

Overview of Decision Analysis

Decision analysis is the latest step in a sequence of quantitative advances in the operations research/management science field. Specifically, decision analysis results from combining the fields of systems analysis and statistical decision theory. Systems analysis, which grew as a branch of engineering, was good at capturing the interactions and dynamic behavior of complex situations. Statistical decision theory was concerned with logical decisions in simple, uncertain situations. The merger of these concepts creates a methodology for making logical decisions in complex, dynamic, and uncertain situations.

Decision analysis specifies the alternatives, information, and preferences of the decision-maker and then finds the logically implied decision.

Decision-making requires choosing between alternatives, mutually exclusive resource allocations that will produce outcomes of different desirabilities with different likelihoods. While the range of alternatives to be considered is set by the decision-maker, the decision analyst may be able to suggest new alternatives as the analysis progresses.

Since uncertainty is at the heart of most significant decision problems, decision-making requires specifying the amount of uncertainty that exists given available information. Many decision problems become relatively trivial if uncertainty is removed. For example, consider how easily a decision-maker could make a critical decision in launching a new commercial product if he could predict with certainty production and sales costs, price-demand relationships, and governmental decisions. Decision analysis treats uncertainty effectively by encoding informed judgment in the form of probability assignments to events and variables.

Decision-making also requires assigning values on the outcomes of interest to the decision-maker. These outcomes may be as customary as profit or as troubling as pain. Decision analysis determines the decision-maker's trade-offs between monetary and non-monetary outcomes and also establishes in quantitative terms his preferences for outcomes that are risky or distributed over time.

One of the most basic concepts in decision analysis is the distinction between a good decision and a good outcome. A good decision is a logical decision -- one based on the information, values, and preferences of the decision-maker. A good outcome is one that is profitable, or otherwise highly valued. In short, a good outcome is one that we wish would happen. By making good decisions in all situations that face us, we hope to ensure as high a percentage of good outcomes as possible. We may be disappointed to find that a good decision has produced a bad outcome, or dismayed to learn that someone who has made what we consider to be a bad decision has achieved a good outcome. Short of having a clairvoyant, however, making good decisions is the best way to pursue good outcomes.

An important benefit of decision analysis is that it provides a formal, unequivocal language for communication among the people included in the decision-making process. During the analysis, the basis for a decision becomes evident, not just the decision itself. A disagreement about whether to adopt an alternative may occur because individuals possess different relevant information or because they place different values on the consequences. The formal logic of decision analysis subjects these component elements of the decision process to scrutiny. Information gaps can be uncovered and filled, and differences in values can be openly examined. Revealing the sources of disagreement usually opens the door to cooperative resolution.

The formalism of decision analysis is also valuable for vertical communication in a management hierarchy. The organizational value structure determined by policymakers must be wedded to the detailed information that the line manager, staff analyst, or research worker possesses. By providing a structure for delegating decision-making to lower levels of authority and for synthesizing information from diverse areas for decision-making at high levels, decision analysis accomplishes this union.

Methodology

The application of decision analysis often takes the form of an iterative procedure called the Decision Analysis Cycle (see Figure 1). Although this procedure is not an inviolable method of attacking the problem, it is a means of ensuring that essential steps have been considered.


The procedure is divided into three phases. In the first (deterministic) phase, the variables affecting the decision are defined and related, values are assigned, and the importance of the variables is measured without any consideration of uncertainty.

The second (probabilistic) phase starts with the encoding of probability on the important variables; then, the associated probability assignments on values are derived. This phase also introduces the assessment of risk preference, which defines the best solution in the face of uncertainty.

In the third (informational) phase, the results of the first two phases are reviewed to determine the economic value of eliminating uncertainty in each of the important variables in the problem. In some ways, this is the most important phase because it shows just what it would be worth in dollars and cents to have perfect information. Comparing the value of information with its cost determines whether additional information should be collected.

If there are further profitable sources of information, then the decision should be to gather the information rather than to make the primary decision at this time. The design and execution of the information-gathering program follows.

Since new information generally requires revisions in the original analysis, the original three phases must be performed once more. However, the additional work required to incorporate the modifications is usually slight, and the evaluation, rapid. At the decision point, it may again be profitable to gather new information and repeat the cycle, or it may be more advisable to act. Eventually, the decision to act will be made because the value of new analysis and information-gathering will be less than its cost.

Applying the above procedure ensures that the total effort is responsive to changes in information -- the approach is adaptive. Identifying the crucial areas of uncertainty can also aid in generating new alternatives for future analysis.

Model Sequence

Typically, a decision analysis is performed not with one, but with a sequence of progressively more realistic models. These models generally will be in the form of computer programs. The first model in the sequence is the pilot model, an extremely simplified representation of the problem useful only for determining the most important relationships. Although the pilot model looks very little like the desired final product, it is indispensable in achieving that goal.

The next model in the sequence is the prototype model, a quite detailed representation of the problem that may, however, still be lacking a few important attributes. Although it will generally have objectionable features that must be eliminated, it does demonstrate how the final version will appear and perform.

The final model in the sequence is the production model; it is the most accurate representation of reality that decision analysis can produce. It should function well even though it may retain features that are treated in a less than ideal way.

Starting with the pilot model, sensitivity analyses are used throughout each phase to guide its further evolution. If decisions are insensitive to changes in some aspect of the model, there is no need to model that particular aspect in more detail. The goal of a good modeler is to model in detail only those aspects of the problem that have an impact on the decisions, while keeping the costs of this modeling commensurate with the level of the overall analysis.

Important aids in determining whether further modeling is economically justifiable are the calculations of the value of information. Some variables may be uncertain partially because detailed models have not bee" constructed. If the analyst can calculate the value of perfect information about these variables, he will have a standard to use in comparing the co of any additional modeling. If the cost of modeling is greater than the value of perfect information, the modeling is clearly not economically justifiable.

Using a combination of sensitivity analysis and calculations of the value of information, the analyst continually directs the development of model in an economically efficient way. An analysis conducted in this wa provides not only answers, but also often insights for creating new alternatives. When completed, the model should be able to withstand the test of any good engineering design: additional modeling resources could utilized with equal effectiveness in any part of the model. There is no such thing as a final or complete analysis; there is only an economic analysis given the resources available.

PART II: REFINEMENTS AND NEW DEVELOPMENTS IN DECISION ANALYSIS

Having seen the basic concepts of decision analysis and the main poi of its professional practice, let us now examine some of the evolution changes in the field over the last two decades.

The Decision Basis

It has become useful to have a name for the formal description of a decision problem; we call it the decision basis. The decision basis consists of a quantitative specification of the three elements of the basis: the alternatives, the information, and the preferences of the decision-maker. We can then think of two essential steps in any decision analysis: the development and the evaluation of the decision basis.

Basis Development

To develop the decision basis, the decision analyst must elicit each of the three elements from the decision-maker or from his delegates. For example, in a medical problem, the ultimate decision-maker should be the patient. The patient would provide the element of preference in the basis, probably in a series of interviews with the decision analyst. In most cases, however, the patient will delegate the alternative and information elements to doctors who, in turn, would be interviewed by the decision analyst. The analyst should be able to certify that the decision basis accurately represents the alternatives, information, and preferences provided directly or indirectly by the decision-maker. We should note here that the alternatives must include alternatives of information-gathering, such as tests, experimental programs, surveys, or pilot plants.

One key issue is the extent to which the decision analyst can provide substantive portions of the decision basis by acting as an expert. In many circumstances, the analyst cannot be an expert because he has only a lay knowledge of the decision field. Even when the analyst does have substantial knowledge of the subject area, he should make clear to the decision-maker when he has changed from the role of decision analyst to that substantive expert. Playing the role of expert can also force the analyst to defend his views against those of others; to this extent, he would be less of a "fair witness" in the subsequent analysis. Nevertheless, this possible loss of impartiality and fresh viewpoint must be balanced against the communication advantages of dealing with an analyst familiar with the decision field.

Basis Evaluation

Once the basis is developed, the next step is to evaluate it using the sensitivity analysis and value of information calculations described earlier. However, casting the problem as a decision basis shows that value-of-information calculations, important as they are, focus on only one element of the basis -- information.

Using the concept of the basis, we can also compute the value of a new alternative, which we might call the value of control. Such a calculation might well motivate the search for an alternative with certain characteristics and perhaps even the development of such an alternative.

One can perform a similar sensitivity analysis to preference with the intention not of changing preference, but of ensuring that preferences have been accurately assessed. A large change in value resulting from a small change in preference would indicate the need for more interviews about preference.

A Revised Cycle

Using the concept of the basis, we may wish to restructure the decision analysis cycle in the four-phase form shown in Figure 2. Here, the information gathering that must precede analysis or augment subsequent analyses has been included in a basis development phase. The deterministic and probabilistic phases are essentially unchanged, but the informational phase -- renamed "basis appraisal" -- is expanded to include the examination of all three basis elements.


A Refined Analysis Sequence

As a problem is analyzed, the analysis may progress through the decision analysis cycle several times in increasing levels of detail. The basic distinction is between the pilot and full-scale analysis. The pilot analysis is a simplified, approximate, but comprehensive, analysis of a decision problem. The dictionary defines pilot as "serving as a tentative model for future experiment or development." The full-scale analysis is an increasingly realistic, accurate, and justifiable analysis of a decisicision problem, where full-scale is defined as "employing all resources, not limited or partial." To understand these distinctions, we must explain in more detail what constitutes a pilot or full-scale analysis.

The purpose of a pilot analysis is to provide understanding and establish effective communication about the nature of the decision and the major issues surrounding it. The content of the pilot analysis is a simplified decision model, a tentative preference structure, and a rough characterization of uncertainty. From a pilot analysis, the decision-maker should expect preliminary recommendations for the decision and the analyst should expect guidance in conducting the full-scale analysis.

The purpose of the full-scale analysis is to find the most desirable action, given the fully developed decision basis. The full-scale analysis consists of a balanced and realistic decision model, preferences that have been certified by the decision-maker, and a careful representation of important uncertainties. From the full-scale analysis, the decision-maker should expect a recommended course of action.

While most analyses progress from pilot to full-scale, some are so complex that valuable distinctions may be made between different stages of full-scale analysis.

The first stage of full-scale analysis is the prototypical stage, which is intended to reveal weaknesses and excesses in the full-scale analysis that are worthy of correction. A prototype is defined as "an original type, form, or instance that serves as a model on which later stages are based or judged."

After the indicated corrections have been made, the analyst has an integrated stage of full-scale analysis that provides the decision-maker with confidence in having a unified, balanced, and economic analysis as a basis for decision. To integrate is "to make into a whole by bringing all parts together: unify." If a decision-maker is making a personal decision that will not require the support or approval of others, then the integrated stage of full-scale analysis is all that is required. However, if the decision-maker must convince others of the wisdom of the chosen course of action or even defend that course against hostile elements, then an additional stage of full-scale analysis will be necessary — the defensible stage.

The defensible stage of full-scale analysis is intended to demonstrate to supportive, doubtful, and possibly hostile audiences that the analysis provides an appropriate basis for decision. Defensible means "capable of being defended, protected, or justified." Typically, defensible analyses are necessary for important decisions in the public arena; however, even private enterprises may wish to conduct defensible analyses to win the support of workers, financial institutions, or venture partners. Defensible analyses are very demanding because they must show not only that the basis used is reasonable, but also that other possible bases that would lead to different decisions are not reasonable.

Contributions from Psychological Research

One of the most significant factors influencing the practice of decision analysis in recent years has been new knowledge about cognitive processes from the field of psychology. This research, centering on the contribution of Kahneman and Tversky, has had two major effects. First, the research on cognitive biases [10] has shown the need for subtlety and careful procedure in eliciting the probabilistic judgments on which decision analysis depends. Second, and perhaps even more important the descriptive research on how people actually make decisions [6,11] shows that man is considerably less skilled in decision-making than expected. The main thrust of this research shows that people violate the rules of probabilistic logic in even quite simple settings. When we say that people violate certain rules, we mean that when they are made aware of the implications of their choices, they often wish they had made another choice: that is, they realize they have made a mistake. While these mistakes can be produced in analyzing simple decision settings, they become almost unavoidable when the problem is complex.

These findings may change our interpretation of the logical axioms that are the foundations of decision analysis. We have always considered these axioms as normative: they must be satisfied if our decisions are to have many properties that we would regard as desirable. If a particular individual did not satisfy the axioms, then he would be simply making mistakes in the view of those who followed the axioms. While this interpretation is still possible, a more appropriate way to look at the axioms is that they describe what any person would do if faced with a situation as simple as the one described by the axioms. In other words, the axioms are descriptive of human behavior for simple situations. If, however, the situation becomes more complex, more "opaque" as opposed to "transparent," the axioms are no longer descriptive because the person may unintentionally violate the axiom systems.

We may now think of the job of the decision analyst as that of making "opaque" situations "transparent," so that the person clearly sees what t do. This interpretation of the work may not make it any easier, but it is far more humane than the view that the analyst is trying to impose logic willfully illogical world.

Influence Diagrams

The influence diagram is one of the most useful concepts developed in decision analysis [3]. The analyst has always faced the problem of how to reduce the multifaceted knowledge in people's heads to a form that could meet the rigid tests of explicitness and consistency required by a computer. The analyst has always faced the problem of how to reduce the multifaceted knowledge in people's heads to a form that could meet the rigid tests of explicitness and consistency required by a computer. The influence diagram is a major aid in this transformation because it cross the border between the graphic view of relationships that is very convenient for human beings and the explicit equations and numbers that are the province of present computers. To find a device that can readily be sketched by a layman and yet be so carefully defined that useful theorems concerning it can be proved by formal methods is rare. Although there is a danger that people who do not thoroughly understand influence diagrams may abuse them and be misled, there is an even greater promise that the influence diagram will be an important bridge between analyst and decision-maker.

Valuing Extreme Outcomes

One of the problems perplexing early users of decision analysis was how to treat outcomes so extreme that they seemed to be beyond analysis. For example, the question of how a person's death as the result of medical treatment can be balanced with other medical outcomes, like paralysis or even purely economic outcomes, was especially demanding. These problems appear to raise both ethical dilemmas and technical difficulties. One ethical dilemma centered on who had the right to value lives. A technical difficulty was revealed when an economist testifying in court on the value of a life was asked whether he would be willing to allow himself to be killed if he were given that amount of money. Nevertheless, once the ethical issue is clarified by acknowledging that a person may properly place a value on his own life, then the technical question of how to do it can be addressed quite satisfactorily, especially in the case of exposure to the many small risks present in modern life [4,5]. The results have major implications for many decisions affecting health and safety.

The development of ways to think about the unthinkable has shown that no decision problem lies beyond the realm of decision analysis. That is very satisfying, for were you faced with medical decisions about a loved one, would you want to use second-rate logic any more than a second-rate doctor?

Conclusion

When decision analysis was first developed, a common comment was, "If this is such a great idea, why doesn't [insert name of large, famous company] use it?" Today, it is difficult to find a major corporation that has not employed decision analysis in some form. There are some factors that should lead to even greater use. For example, decision analysis procedures are now more efficiently executable because the increased power of modern computers has reduced the costs of even very complex analyses to an affordable level. The problems that can be successfully attacked now run the gamut of all important decision problems. Increasing uncertainties and rapid change require fresh solutions rather than tested "rules of thumb." Some day, decision analysis of important decisions will perhaps become recognized as so necessary for conducting a provident life that it will be taught in grade school rather than in graduate school.

References:

1. Ronald A Howard, "Decision Analysis: Applied Decision Theory," Proceedings of the Fourth International Conference on Operational Research, Wiley-Interscience, New York, 1966, pp. 55-71.

2. Ronald A Howard, "The Foundations of Decision Analysis," IEEE Transactions on Systems Science and Cybernetics, SSC-4, No. 3, (September 1968): 211-19.

3. Ronald A Howard and James E Matheson, "Influence Diagrams," Department of Engineering-Economic Systems, Stanford University, July 1979.

4. Ronald A Howard, "On Making Life and Death Decisions," Societal Risk Assessment, How Safe Is Safe Enough?, Edited by Richard C. Schwing and Walter A Albers, Jr, General Motors Research Laboratories, Plenum Press, New York, 1980.

5. Ronald A Howard, James E Matheson, and Daniel L Owen, "The Value of Life and Nuclear Design," Proceedings of the American Nuclear Society Topical Meeting on Probabilistic Analysis of Nuclear Reactor Safety, American Nuclear Society, May 8-10, 1978.

6. Daniel Kahneman and Amos Tversky, "Prospect Theory: An Analysis of Decision under Risk," Econometrica, 47, No. 2 (March 1979): 263-291.

7. D Warner North, "A Tutorial Introduction to Decision Theory," IEEE Transactions on Systems Science and Cybernetics, SSC-4, No 3, (September 1968): 200-10.

8. Howard Raiffa, Decision Analysis: Introductory Lectures on Choices under Uncertainty, Addison-Wesley, 1968.

9. Myron Tribus, Rational Descriptions, Decisions, and Designs, Pergamon Press, 1969.

10. Amos Tversky and Daniel Kahneman, "Judgment under Uncertainty: Heuristics and Biases," Science, 185 (Sept 27, 1974): 1124-1131.

11. Amos Tversky and Daniel Kahneman, "The Framing of Decisions and the Psychology of Choice," Science, 211 (Jan 30, 1981): 453-458.

Republished with permission of The Stanford Decisions and Ethics Center

Saturday, June 05, 2010

Information Technology Is Not Smart, People Are…

Dr Andrew McAfee (2010) recently made the following observations about computers in enterprise:
I see companies in all industries using computers to accomplish three broad and deep transformations: they're becoming more scientific, more orchestrated, and more self-organizing.
I sincerely hope that large-scale enterprises might someday become more scientific, orchestrated, and self-organizing, and I agree that these are the hopes and promises of information technology (IT). However, the case is still out as to whether IT can or will deliver on these promises by itself.

My personal observation is that firms today tend to throw money at IT and then rush into the claim that they are therefore more analytic, collaborative, and agile as a result -- the reality is very different on the ground. Decision support and information technology are critical resources for the conduct of enterprise, however these functions and installations remain a supporting effort to the larger tasks of predicting and optimizing. The weak link in the business intelligence production chain is not IT, but smarts...


Source: McAfee, A (2010, June 3), IT's Three Key Organizational Transformations, Harvard Business Review Blog.

Friday, April 16, 2010

From Ledgers to Electronic Spreadsheets

There was a time through the 1970’s when spreadsheets were synonymous with ledger books and paper as shown below. Of course, you can still purchase ledger paper at any office supply store, and many accountants still use ledgers for light bookkeeping and budgeting tasks.

Ledger Paper

However, by the early 1980's the world marveled as the first electronic spreadsheets found their way onto the personal computers of the day. My introduction to electronic spreadsheets began with VisiCalc (Electronic Arts). Below is a screenshot of VisiCalc as it would have appeared on my Apple //e computer back in 1983. At the time, VisiCalc amazed me with its capabilities and potential. Remarkably, VisiCalc still runs on today’s computers (follow the link below for instructions and a free download of the program).

VisiCalc

VisiCalc (Electronic Arts)

VisiCalc was soon followed by the introduction of Lotus 1-2-3 (Lotus Development), which by the mid-1980's was the best selling electronic spreadsheet program on the market. Lotus 1-2-3 (shown below) boasted improved speed and functionality over VisiCalc, as well as the addition of integrated graphing capabilities.

Lotus 1-2-3 (Lotus Development)

However, the emergence of Windows (Microsoft) in 1987 was quickly joined by the arrival of Excel (also Microsoft) as shown below. By the mid-1990's, Windows and Excel had become industry standards in the fast-growing technology sector.

Excel 2.1p (Microsoft)

The spreadsheet technology available today has certainly come a long way since VisiCalc, Lotus 1-2-3, and the early editions of Excel. The latest version of Excel (shown below) now reigns as the the most ubiquitous software application in the world, and is widely regarded to be an essential business intelligence and personal productivity tool with unparalleled capacities to support problem-solving and decision-making.

Excel 2010 (Microsoft)

I have omitted a number of other less popular spreadsheet applications from this short history. However, all spreadsheet programs (including Excel) trace their lineage to the paper ledgers of years past. Some say that spreadsheets have seen their day and will eventually be replaced by something new. Perhaps, but I suspect that whatever comes next will still somehow resemble plain old ledger paper.

Sunday, January 24, 2010

The Minds Behind the Meltdown

In an effort to assign responsibility for the Wall Street financial meltdown that began in 2007, Scott Peterson (2010) makes the case that "quants" were the demons that somehow misled investment managers and the public:
On Wall Street, they were all known as "quants," traders and financial engineers who used brain-twisting math and superpowered computers to pluck billions in fleeting dollars out of the market. Instead of looking at individual companies and their performance, management and competitors, they use math formulas to make bets on which stocks were going up or down. By the early 2000s, such tech-savvy investors had come to dominate Wall Street, helped by theoretical breakthroughs in the application of mathematics to financial markets, advances that had earned their discoverers several shelves of Nobel Prizes.
Regarding the management teams that supervised these "quants," Peterson is mute. I tend to take the alternative view that management is responsbile for everything that happens or fails to happen within their domains. My question for the investment managers and policy makers is simply, "How could you be so dumb as to let your trading staffs run over you?" I tend to point the finger directly at the investment policies and greed of the investment managers and other senior executives rather than the traders. After all, the public can hardly hold staff traders responsibile for the devastating loses that ensued. The executive management teams of these investment institutions have a lot to answer for from my perspective. The minds behind the meltdown sit amongst the policy makers - not the traders.

Reference: Peterson, S (2010, January 23), The Minds Behind the Meltdown, Wall Street Journal Online.

Friday, July 31, 2009

Enter the Algorithm

In this occasional paper, I echo Dr David Berlinski's view that the proliferation of powerful personal computers during the late twentieth-century accelerated the quest for algorithms as drivers of technological and human progress. While calculus is creditworthy of bringing high order to the physical sciences, it is now the algorithm that thrives as the intelligent artifact of the new millennium.

Download

Wednesday, July 29, 2009

Small Investors Beware

High frequency (or algorithmic) trading was one of the major investment innovations to emerge in the late 20th century. Given the effectiveness and profit potential of such methods, it comes as no surprise to learn that 46 percent of daily volume originates through high frequency strategies.
Powerful computers, some housed right next to the machines that drive marketplaces like the New York Stock Exchange, enable high frequency traders to transmit millions of orders at lightning speed and, their detractors contend, reap billions at everyone else’s expense… High-frequency specialists clearly have an edge over typical traders, let alone ordinary investors… Powerful algorithms — “algos,” in industry parlance — execute millions of orders a second and scan dozens of public and private marketplaces simultaneously. They can spot trends before other investors can blink, changing orders and strategies within milliseconds… These systems are so fast they can outsmart or outrun other investors, humans and computers alike. (Duhigg, “Stock Traders Find Speed Pays, in Milliseconds,” NYT, 23 Jul 2009)
Unfortunately, the methods of high frequency trading are neither available nor assessable to the average investor. My advice to most investors is to invest in public companies only with funds that you can afford to lose. My recommended investment strategy of choice for serious investors is to target companies in which you are an active owner, partner, or director in order to ensure you have full access to the fundamental information you need to monitor your investments wisely (which incidentally is the same strategy apparently used by Warren Buffet, George Soros, and Carl Icahn).

Institutional investors and other major players dominate modern day investing with sophisticated methods and technologies that the average investor cannot hope to match. Unless regulators can find a way to level the playing field, small investors should beware of the markets.