| The Excel
Squaring Calculator
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. |