The Excel Squaring Calculator  | back |

This Excel program is an excellent tool for developing your forecasts of time and price or to pinpoint support and resistance. Easy to use; just insert the high price and date, and low price and date. Now, let the program do the rest. The program generates sub-squares of time and price. 1/8th and 1/3rd increments.

  • RSC allows you to change the speed of the square.  Normal is 1x1, but in very active or inactive markets the speed or scale of the range can be slowed or sped up.  As long as you keep it mathematical the ranges are equal.  The slowest speed programmed into the calculator is a 16th or 0.0625, then  0.125, 0.25 etc.. There is place in the program to input any speed you want.  I use this function mostly for planet orbit calculation or you use it to square out specific number etc...
  • You can square Calendar Day, Market Day (market day is based on 20 year average with leap years and holidays.) Weekly and Monthly.  Also you square from the high or low to zero to get range to zero on each of the above times.  
  • Can save all inputs to separate folder
  • Can save sub-squares of price to separate folder
  • Can save sub-squares of time to separate folder
  • Repeat as many times as you wish to have a complete current range square database.
  • Can go to price folder or time folder to print and research the data.
  • The program takes it on step farther, it allows you to bunch study the date data by months in pre-selected years. example:  01-01-04 to 12-31-06.

If you have the major swing data; (high, low and dates), you can run a long and short-term COMPLETE studys in a matter of minutes. Print out the "Study Folder" and keep it handy as you begin trading your market.

>*Squaring the range is fairly simple, but plotting four or more squares on your chart becomes a blur. *Human error and miscalculation is also a problem. This program is simple and error free!

>*By selecting different speeds of the square will allow one to give more sub-square turn dates or less turn dates depending on the length of the square.

>*Don't forget to square out the all-time low as well as zero squares when performing your studies. | back |