To: Eric P who wrote (2334 ) 8/4/1999 12:10:00 AM From: - Read Replies (2) | Respond to of 18137
re: the Futures West conference Sept 28-Oct 3 in Long Beach, one of the things that attracted me to it was Murray Ruggerio's all-day tutorial on using Microsoft Excel for trading applications. I just noticed he has an article on this topic in the new Futures Magazine (Aug 1999 pg 54) "VBA from concepts to applications". Murray is a respected industry heavy who is frequently published in Futures etc., and he has written a few books. I trade a lot of different semi-mechanical setups (entry patterns) which are usually some unique combination of my own blend of T.A. criteria+market conditions+candlestick patterns. It is nice to be able to routinely backtest these different entry setups that I devise on different stocks and indices in order to gauge how effective they might be in the future. By building your own daily and intraday tick databases on your favorite trading instruments (or buying some data) you can gain a much better insight into different potential trading strategies through backtesting (this is widely/routinely done by system traders and futures traders). What Murray's course is all about, is how to do this with simple, common, garden-variety Microsoft Excel -- thus, avoiding the whole TradeStation/Metastock/(etc.) charting package/backtesting headaches that can literally suck the life out of you ;) I owned/used/upgraded TS for years, and believe me it is to-be-avoided if possible, unless you have a lot of spare time on your hands. Excel represents a simpler (but effective) streamlined alternative, which still gets the job done while at the same time remaining more flexible, and it is useful for a much broader scope of trading, analysis, and database applications. There are a many other interesting things you can do with Excel to enhance your trading as well, such as "The Equity Curve Technique" which I've written about on this thread and on Tiger Investor; and various other useful trading tricks/stunts can be achieved by DDE-linking live price quotes into Excel (etc.); the list is long. The applications of Excel in trading are many, so the time you invest in learning to do things with Excel for one purpose, tends to pay off later for other purposes. FYI, -Steve