ESPL: Format statement

Q:  I cannot get the format command to work with a variable enclosed in brackets.  This example gives an error.

vTotalVolume:=13894948
strText:=’The Total Volume was ‘ + Format(‘%12.0n’,[vTotalVolume]);

A:  The parameter needs to be of type ‘real’. The example you gave evaluates to type ‘integer’.   This example works where .0 is appended to the value so it is treated as a ‘real’.

vTotalVolume:=13894948.0
strText:=’The Total Volume was ‘ + Format(‘%12.0n’,[vTotalVolume]);

T-Bonds Weekly Thunderbolt

Larry Pesavento:  “Thirty years ago in the spring of 1981 the yield on the 30-year treasury bond issued by the US government was above 16%. The bond carried an 8% coupon, but the price of the bond had dropped below 46. This meant that you could buy one hundred thousand dollars of treasury bonds for $46,000, and cash them in at maturity for $100,000. In 1981 inflation was rampant above 15%, gold had retreated from its high of 865 and ounce, and the country was in turmoil to say the least. Since that time, interest rates have dropped every year over the past 30 years making this one of the longest bull markets in bonds in history. The chart we are showing today is a long-term weekly chart of the thirty-year T-bond.

Several patterns are apparent to the trained eye. Of particular interest is the pattern that is completing at the present time known as the thunderbolt, or AB=CD pattern. This pattern measures equal and parallel moves and is present in just about everything that trades with a liquidity on the worldwide basis.  In addition a double top can be seen. This has the potential of being the trade of the decade, i.e. interest rates are going higher. No one in their right mind thinks this could happen but just looking at the charts it appears that this could be the case. The downgrading of U.S. Treasury bonds and notes by Standard & Poor’s did little to slow down the upward move of these instruments and make rates go even lower. What we’re waiting for now is a sign that the top is finally in. This sign will come after we have a correction and then one more retest hopefully at the 61% retracement were we can enter with a stop above the reason highs of 144. Bonds have not stopped going up as yet and they could still reach 151 making new highs from 2008.

Ask yourself this question, is there anyone that I would lend money to for 10 years at a rate of 1.9% per year? I think we all know the answer to that question.  However, the prevailing financial minds believe that rates are going to go even lower. Herein could be the big surprise for the rest of this decade.”

Interactive Broker Chart Volumes

Q:  Why does my 15-second chart from IB have less volume than the same chart in Ensign?  When I refresh the Ensign chart from IB, the volume difference is corrected.

A: The higher volume bars in Ensign should be considered to be more correct than the IB chart, and here is why.   IB is a sampled feed, meaning they do not send all ticks.  The IB chart is charting the ticks seen and summing the tick volumes on those ticks. Ticks NOT sent, because it is a sampled feed, are totally ignored.

Ensign, on the other hand, compares the tick volume on the tick received with the change in total volume. Then they match, Ensign uses the tick volume value. When they differ, obviously some ticks were not sent and Ensign adds a filler tick with the needed tick volume to stay in sync with total volume.  These inserted ticks with the missing tick volume are the source of the larger volume values shown in Ensign compared to IB.

When the tick database is refreshed, Ensign receives 1 second records from IB to work with and this erases the filler ticks with the missing tick volume.  Thus the refreshed result looks more like the IB chart.  The refresh has forced Ensign to miss the ticks that the IB chart missed.  What Ensign is doing to account for missing volume in the live feed it better than what IB is doing.  The chart Ensign shows with the inserted missing tick volume is MORE like the charts from other data vendor who send all ticks.  It is recommended that refresh only be used when data is missing.

FYI, Ensign 10 does the same thing for the Yahoo Finance feed which is also a sampled feed.  Ensign 10 watches the change in total volume to calculate the tick volume that must have occurred since the last tick was received.

Gold Index 3 Drives to Top

Larry Pesavento: “The gold market has been parabolic over the last 10 weeks and has approached an overbought situation that has not been seen since 1980 when gold topped at 865 an ounce. The Gold bug index (HUI) is showing a three drive to the top pattern along with the butterfly pattern. Within the butterfly pattern you can easily see the AB=CD pattern that is also known as the thunderbolt pattern. This is telling us that the market is incredibly vulnerable to a correction in gold.

We are seeing the same type of pattern evolving in the gold/silver index (XAU) but it is coming at a level where we’ve had three declining tops. Should you be long gold and silver it would be wise to ask yourself this question.? Why haven’t the gold and silver stocks gone up with the price of gold? Part of the answer is because the stock market has been been down dramatically but that is only one element. Silver, known as the poor man’s gold, is particularly weak as it is unable to make only a 61% retracement off of the April 25 highs.  Patterns such as those in gold and gold bug index are highly predictive of a major top, if not, at least a major correction. As always it is good to remember that these are only probabilities and not certainties. Good money management and risk control are tantamount to anything related to technical analysis.”

Dec Corn Daily Harmonics

Larry Pesavento: “This weekend I would like to talk about the corn market because it is so perfectly harmonic. The Ensign Windows software I use is invaluable in the analysis of the corn market i.e. and others.

My focus is on December corn which is growing as we speak. It is also referred to as new crop corn because it will be harvested sometime in late October. Corn is a perfect example of the valuable insights that can be gleaned from technical analysis.

First, by using the formations tool in the Ensign program you can easily see the AB=CD patterns that are formed over the past nine months. What is interesting is that they have the same characteristics in time as they do in price.

Secondly, there is a 75 day cycle that is repeated twice and has peeked at the exact time in the previous two cycles. When cycles peak at the right hand side of the cycle, i.e. going longer to the upside, it is referred to as right translation and is invariably bullish do the market. As you can see from this chart the third peak is forming as we speak and is due sometime in mid-September.

Dec Corn Daily

By using the Fibonacci tool it is easy to see that the retracement’s entities cycles were 50% and 78.6% respectively. Finally we can look at the repetition in the corn market by watching previous retracements in the corn market as shown by the yellow boxes. The first three retracement’s were perfectly equal. The last retracement that finished with a Gartley pattern in early July was exactly twice the other retracements and stopped at the 786 retracement.

Other charts exhibit the same types and characteristics but this particular one in corn is a textbook example. Anyone unfamiliar with technical analysis are skeptical of its ability to help make good trading decisions should take some time and study these principles and then use them on other charts. The Ensign software I use enables me to look inside the market and see the secrets it is trying to tell us.”

Median Filter Formula

Q:  My favorite robust statistic is always non-linear tools. To that end I do not like averages but like medians.

Median:  Sort the list of numbers from smallest to biggest. When the count is an odd number, the Median is the middle number.  When the count is an even number, the Median is the midpoint between the two middle numbers.  It would be nice if this were listed on the Ensign studies list.

A:  The Median Filter formula has been added to all study property forms where there is a drop down component to select from 11 average formula. The Median Filter entry is on the bottom of the list.  For example, you can put on the Moving Average study and select the Median Filter formula.

TWS Auto Logoff Timer

Q:  How do I change the time when TWS does its daily shut down?

A:  Use the TWS Configure button to edit the time for the shut down.

TWS Auto Logoff Time

Then in Ensign, on the connection form for the Interactive Brokers feed, enter a time for Ensign to rerun TWS that is 1 minute later than the auto logoff time.

Which Tool is Selected?

Q:  I like Ensign 10 and think it’s a big improvement over Ensign Windows although I thought that version was very good too.  I put up several Fibonacci Retracements on a chart.  When I go into the objects window, is there a good way of keeping track of which retracement is which?

A:  Clicking on an object on the list in E10 will show the construction boxes on the draw tool on the chart.  That indication on the tool helps you see if you have selected the intended tool.