Trading in a spreadsheet.(part 1)(market analysis using Microsoft Excel)

Futures (Cedar Falls, Iowa), April, 1999 by Ruggierro, Murray A., Jr.

Steps on how to use the spreadsheet program Microsoft Excel for conducting market analysis are presented. This method is useful for stockbrokers who are just starting to build and test their trading systems. With the Microsoft Excel program, large amounts of data that include numbers, text, dates and times, formulae and functions can be processed and transformed into valuable market information. Aside from performing complex calculations, what-if scenarios can also be processed by Microsoft excel.

If you're just getting started, or handy with spreadsheets, you may not need the fancy software to build and test your trading ideas. In a multiple part series, we'll show how to use a simple spreadsheet program, in this case Microsoft's Excel, to test ideas and help build...

Read the rest of this article with a Free Trial at HighBeam Research.

Premium Content Partnership | HighBeam Research provides an in-depth online archive library of reference works.