XLPlanets.xla - Market Astro Physics, Financial Astrology & Gann Astro-Methods
XLPlanets.xla has the tools you need for financial astrology and for exploring Gann astro. methods. It has a digital ephemeris with 50 different functions including: Longitude (geocentric and heliocentric), Right Ascension, Latitude, Declination for each of the planets (and Pluto), Longitude for the moon (geocentric) and the MOF and the COE. It has ten different astrological "clocks" (5 heliocentric and 5 Geocentric) which places the planet relative to a user specified price and: its position in the sky, location on the square of 9, the Circle chart, the Hexagon chart or relative to a natal date which you specify. It has a tool for overlaying planetary support and resistance curves on price charts and a tool for plotting planet speed-lines from significant highs and lows. XLPlanets.xla is designed to integrate seamlessly with the HLC_Chart.xlt template which is included with the purchase. If you are into financial astrology, and you have Microsoft Excel® then you need XLPlanets.xla.
The astro clocks are accessible from the drop down XLTrader menu. The planet speed-lines and planet support and resistances functions are accessible from the toolbar which works with the graph sheets of the HLC_Chart template. The toolbar functions will not work with other templates.
The toolbar has two sets of icons. The first icon from the left is for planet speed-lines. The second icon is for planetary support and resistance (S/R). Once you have a planetary S/R curve on your chart, you can shift it up and down (by the amount determined by the harmonic and scale factor you selected), change the planet, change the scale factor or change the desired harmonic using the toolbar all without leaving the graph sheet!
From the menu, you can pull up the astro. clock of your choosing in either geocentric or heliocentric mode.
Planetary Support & Resistance (S/R)
When you click the planetary support and resistance toolbar icon, it takes you the data sheet in the HLC_Chart template and brings up the form shown. In addition to column where you want the output, you must specify: the planet (in a drop box), the desired harmonic, trending up or trending down, a scale factor (if appropriate) and whether you want heliocentric or geocentric longitude. When you press the Calculate button the S/R Curve is automatically plotted on the chart you started from. If you started from the Calendar day chart, the curves are nice and smooth, if you start from the trading day chart, the curve has steps where weekends and holidays occur. Calendar Day charts look better.
The program tries to position the curve based on the maximum and minimum values in the price data but invariably you will need to shift it up (or down) to get it closer to the current price action. This is easily done by pressing the arrow icons on the toolbar. Once you have a S/R curve displayed on the chart, you can easily modify it using the drop down menu selection on the tool bar. From let to right the choices are: planet (including MOF and COE), Geocentric or Heliocentric, Harmonic, Scale Factor and trending up or trending down.
The chart above shows some geocentric planetary S/R curves plotted over recent S&P500 price action on a trading day chart. Notice how price tagged the Jupiter and Mars harmonics at the recent low? See how Uranus 5th harmonic stopped the rally dead in its tracks?
Planet Speed-lines
When you click on the plant speed-lines icon, you are asked to select and confirm an anchor point which is usually a major high or low.
You are then taken to the data sheet where the speedlines form is displayed. You specify, in addition to the starting column where the output will be placed, the planets you want, whether geocentric or heliocentric, trending up or trending down and any applicable scale factor. The program then automatically plots the speed-lines starting at the point you selected. The chart below shows some geocentric speed-lines plotted over the S&P 500.
Astro Clocks (Legacy version only Office 97-2003)
Astro clocks are designed to quickly show where the planets are in the zodiac in reference to a user specified price or in reference to the natal chart. You can specify the date by either typing it in or by using a pop-up calendar. There are five different types of clocks. The basic positions clock shows where the planets are in the zodiac (either heliocentric or geocentric). You can put the planets on the square of nine, the hexagon chart or the circle chart and you can compare the current positions to a natal date you must specify. The picture below shows each of the clocks in heliocentric mode and its accompanying table which has the actual numeric values.
You can turn aspect calculations on or off. If you want to calculate aspects, you can specify which aspects, the orb and assign a weighting to it. The program tally's up the weights for all of the aspects that are occurring on any given day. Using aspects numeric total, you can come up with your own "Bradley" type indicator. When aspects are turned on, only aspects are shows on the accompanying table. When aspects are turned off, all numbers are shown on the table.
Another feature of the tables is animation. You can "walk forwards" (or backwards) one day at a time taking note of the aspects that occur on each day. A delay function is provided so you have enough time to look at each day otherwise (especially on a fast computer) they fly by too fast. I like to turn animation on, sit back and watch the aspect counts that will be happening over next week or two. Its amazing how often significant highs and lows in the markets are printed on high aspect count days.
Ephemeris Functions
As I mentioned at the top of the page, there are 50 different ephemeris function available in XLPlanets. These are all accessible from the functions item on the insert drop menu. Get XLPlanets by joining XLTrader-Talk Google group today!
XLTrader Add-ins, Templates, etc. work together seamlessly turning Microsoft Excel© into a powerful yet inexpensive Technical Analysis platform. All of the XLTrader add-ins together with the (HLC_Chart.xlt) template to make Technical Analysis as easy as pointing and clicking! 
You can get get XLTrader by joining XLTrader-Talk google group. The software is a group membership benefit.
Data Downloader
