{"product_id":"v06-c06-debug-pdf","title":"V.6:6 (205-209): Debugging and the virtues of experimentation Part 6 by Jim Summers, Ph.D.","description":"Debugging and the virtues of experimentation\nPart 6\nby Jim Summers, Ph.D.\u003cbr\u003e\u003cbr\u003eIn last month's column we discussed the use of {Put} and @Index(...) menu commands in Lotus 1-2-3.\nThese can increase significantly program speed by avoiding cursor movement and redundant range names\nduring processing. We used these to update the formula which calculates the trading range (TR1) shown\nin Figure 1.\u003cbr\u003e\u003cbr\u003eThe TR1 portion of J. Welles Wilder's DMI is a complex formula and very susceptible to typing errors.\nThis month I'll show you how to debug complex formulas before we go on to develop the TR1 loop.\u003cbr\u003e\u003cbr\u003eAre you chafing at the bit to get to the finished product? Keep in mind that this column is process\noriented; reproducing my system is secondary. The goal is to give you the tools to accomplish your own\ntrading tasks. Each column presents a tool, all the while moving towards a \"product.\"\u003cbr\u003e\u003cbr\u003eIf the TR1 formula doesn't work the first time you type it into your computer, don't be discouraged. The\nfirst time I tried, it didn't work for me either. Several sorts of errors commonly occur when using {Put}\nand @Index(...) functions. We'll solve them one by one.","brand":"store-traders-com","offers":[{"title":"Default Title","offer_id":52133780750705,"sku":"\\V06\\C06\\DEBUG.PDF","price":5.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0900\/3843\/6209\/files\/unnamed_0837b0d9-6a30-4666-853a-a43057854a20.jpg?v=1739652290","url":"https:\/\/shop.traders.com\/products\/v06-c06-debug-pdf","provider":"Stocks \u0026 Commodities","version":"1.0","type":"link"}