Astral Excel for Statistics &Finance

<Price List>

It is similar to Astral Excel but with one step forward that it is supported with Macros. Macro is small software fixed inside Excel sheet. It does additional calculations when it is activated; mainly reorganizing the data imported from the main software "standard- Astral". To provide the user with better view and comprehensive understanding to the observed astrological phenomena for making better financial decisions.


It helps the user to find out more about Financial Astrology (FA) in modest paces. One will learn and discover always something new about the nature of Mutual Planetary Aspects


Among the main functions of Macros:

1) Grouping the listing of Mutual Planetary Aspects in smaller groups by (Planets, Date, Aspect degree ...) see Fig 14          

2) Marking the semi groups in colours see Fig 16

3) Conclusions gathering  about each Aspect type for exportation to single page  see Fig 18

4) Approximate Benefic or Malefic major planetary Aspects marking see Fig 16

5) Approximate Planet power evaluation see Fig 19

6) Approximate Planet Malefic/ Benefic nature evaluation see Fig 17


Financial Astrology tries to find out how and when the planetary power affects the financial market. The ambiguity is that the planetary power does not act in full global manner despite the fact that it is indeed global phenomenon. Any Planetary Aspect between two planets refers to the distance between them calculated in the number of degrees around the zodiac. Any Mutual Planetary Aspect which takes place on particular date is not necessarily going to affect all the markets everywhere and all Stocks in the same manner. Not all the stocks or all the players on earth are going to be affected in the same way and luckily it is like that.


The answer for how it affects particular Player could be posted into the sphere of Natal Astrology. Remain, the question how the planetary aspect affects this Market and this Stock or this Raw Material could be answered on two levels. The first one is of course associated with the Natal map of the Market and of the Stock itself, both are powerful  instruments but not always are available. What to do then? One has to find some clue from the astrological phenomenon itself. If you want to find the precious answer by pressing a button in a software which you buy even for few hundreds dollars, you had better to think it over again. Researchers had to work hard to find little information for what they are looking for. This software [Astral Excel for Finance and Statistics] is to put you on the right truck to pursue the right method to find the right answer.


Planetary aspects are cyclic in their occurrence exactly as the ups and downs in the financial and stock markets, there is no reason why they should not coincide with each other. In fact they do, The statistical facts are still there and worth consideration. That's how financial astrology supporters justify their action in conducting Statistics about the frequency of coincidence between the state of the market and the occurrence of particular Mutual Planetary Aspect. Such methodology seems to be reasonably scientific and reliable for the investigation.


Statistics for Financial Astrology  is presented here in simple manner. It requires only smart observation, it could be conducted absolutely by everyone whether young or old, highly educated or not. All what one needs is downloading or cutting from the newspaper the historical chart (daily or weekly) of the observed market Index or of the Stock or the Raw Material and a software like ours. What you get from Astral Excel - Finance & Statistics  software is not any revolutionary idea but you get the means and methods for making the search easy, well documented and reliable. So, you can enjoy it and be fully satisfied and proud that you are discovering what the market and the planets hid behind the seen.


To do that, we take for example the historical chart of the market Index for the last several years or the prices historical chart of the stock or of the raw material and have deep look at it. You will certainly observe that there were many ups and downs in it. Some of them were sharp and sudden and some others were mild and slow. You may jump now to standard Astral software to find any global planetary aspects took place around the date of those fluctuations. After that; everything is in your hand. All what you need is sharp observation skill and some astrological knowledge to pick the connection between the event and the most possible astrological phenomenon (planetary aspect). You need only preliminary astrological knowledge about the nature of the planets and the aspect angle involved and smart observation.


The lengthy work done after that is only to confirm your guess and enrich your skill. The better it is, the best and more accurate predication you can make. However, you can do that without investing even a cent in any software. As we mentioned earlier that our software is only to make it easier for you and make you more confident that you are not making unnecessary undocumented mistakes. Soon you will find it is great fun which brings enormous self satisfaction.


The list of planetary aspects imported from standard Astral Software to your Excel workbook sheet looks like any usual listing simply black ink on white paper sorted chronologically. Below are some clips showing the development process of the listing presentation:




Fig 1

Fig 2

 Fig 3

 Fig 4

 Fig 5

Fig 6

 Fig 7

 Fig 8

 Fig 9

 Fig 10

Astrology software for all

 Fig 11

 Fig 12

Fig 13

 Fig 14

 Fig 15

Fig 16

 Fig 17

 Fig 18


Fig 19

 Fig 20

 Fig 21




Fig 1  The listing how appears in its original presentation in standard Astral Software. show me

Fig 2   The same listing exported by [Astral-Excel] to an Excel sheet. show me

Fig 3   The listing exported by [Astral-Excel Statistics&Finance] to an Excel sheet. Still it is usual listing based on event's (aspect) date chronology.  It is not yet dealt with by the Macros included inside Excel sheet. show me

Fig 4  Such listing could be more difficult for the analysis when it is long and includes items (aspects) of several years. Fig4 covers the minimum selected listing of 5 years period. show me

Fig 5 The same 5 years listing as it now appears on an Excel sheet. Namely, sorted by date. show me


With this kind of analysis, it is necessary to group the aspects according the planets participating in the aspect. That in order to evaluate the impact of every planet and every aspect angle on the state of the market whether it goes up or down. The crux is to conclude from the accumulated previous experience how this time the Market or the Stock is going to behave to the same planetary circumstances (MPA) encountered before. 


For example, The analyst who would like to know what the market will do when Venus and Mars make their next regular conjunction aspect which is going to take place in few weeks time.  The traditional method to find the answer is to thumb one of the astrological literature and find some reading. But, is it always like that? Empirical testing showed that the evaluation is not the same when the market is declining and when it is heading up. Also, some types of Stocks are more sensitive to an aspect than to another. Those aspects which are more affiliated with the nature of Mars (armament, ammunition, medical instruments) may receive favourite breeze from Venus conjunction. While Stocks related to fine arts and cosmetics are not expected to be affected positively as the martial nature is of opposite nature. Moreover, market indices and single Stocks often react in different manner in different geographical locations. Thought, the general tendency is rather similar, but the timing and the intensity of the aspect is not always the same.


Therefore, it's became inevitable to run this type of analysis to see empirically how the market behaved times before to the same aspect which is coming to take place soon. Theoretical astrological explanations are very important to inspire the analyst but not necessarily to impose early conclusion. To assemble reliable conclusion about market reaction to the formation of particular planetary aspect there is no way then to have swift listing showing the dates when that particular aspect had taken place before i.e. months and years ago. It sounds fine, but how to do that? The new version of Astral software correlates fully with the standard version to approach this goal. Thereon, we should have several approaches for the observation.


1) Single planetary aspect observation: when we try to have as many as possible historical occurrences of the same aspect between the same two planets documented with the state of the market (chart) at each occurrence. Simply, to find out what did the market, the stock do when this aspect had taken place once before.


2) Annual and periodical chart observation: We should have the annual price chart of the Stock or the Market Index in one hand and set of calculated planetary aspects in the other. In fact, one cannot do much without having such chart available, however, it is not difficult to obtain. And here we need the power of standard Astral software for doing the calculations fast and flexible and exportable into Excel workbook.


3) Major Planetary Aspects observation:  Astral Software has defined a set of Major Planetary Aspects which are very carefully selected. Every single aspect included in the set came after serious lengthy observation by eminent scientists. Having this set adjusted with the user's preferred planetary aspects illuminates heavily the analyst perception.


To have your notes about the observations neatly organized, you can create more than one Excel Sheet where to each of them you can Add, Adjust and Append more aspects of course with the required space for your notes. The final target of the analysis is to have these notes as many as possible and to have them handy and approachable to help you making your final personal anticipation about how this aspect is going to affect the market next time. Taking into the full consideration that any aspect reacts differently when the market is bearish or bullish.


Let us see how Macros performance could help in understanding the impact of the planetary phenomena:

Fig 6:  show me The long listing of planetary aspects presented in figure 5 will be reduced into smaller groups each is printed on specified background colour for quick identification. Each planet has its own identifying colour. In Fig6, the sheet appears before writing any remarks on it. It is just after its creation by the Macro. It is now ready for further development by the user. One great advantage of the Macro is that you can always append to the sheet you are working on more items whenever you find it necessary. The software will append each item to its right group. If you had on the sheet listing of some twenty groups with few items in each of the groups and in one of them say: the group of Mars Conj Jupiter there were three items and then you appended to the sheet ten or twenty items related to various groups, each of the items will go to the group it belongs to or creates its own new group.

With another important advantages, there is another Macro (Conclusions Gathering Macro) will collect your single summing up conclusions you noted in front of each group (aspect) and fix them all on one page. Each item (in any group) has its own space for your notes and the group has its own as well, in it you sum up your conclusion how did the aspect during its various occurrences behave.


Fig 8: show me An example for how a user exploited the sheet. In the upper part of figure 7 one can see copy of weekly based market index diagram for ten years period. Astral has calculated the approximate dates of several mutual planetary aspects defined by the user among them were the conjunction aspects between Mars and Jupiter and Mars and Saturn and some others. The analyst wrote short note in the "Conclusion" column reflecting his personal judgment about how the chart did on the date of the aspect.

The first listed aspect was [Mars Conjuncts Jupiter] on 1993-09-06 (in figure 7a enlargement clip). In the "Conclusions" column, the user wrote brief remark about the state of the market at that time "Light slow down in an up trend". The same aspect [Mars Conjuncts Jupiter] took place again on 1995-11-16 (figure 7b). Analyst's remark was "Supporting level in falling down trend". Also, in figure 7c, the analyst noted an "End of a rally - the Index crossed down the 45 moving average". It is well accepted indicator of the technical analysis.        

All together the user came out with the conclusion about the effect of [Mars Conjuncts Jupiter] on that studded market which reads in symbols as follows: "In falling down (Market) trend - an end of the declining trend. In growing up trend - end of the rally. The aspect is less significant (comparing to other Martial aspects) better observed with Index & Moving Average". How faithful is this conclusion, it is a relative matter and probably you or any other user can do it better. Once the user formulates personal judgment about an aspect, there will be much more certainty in anticipating correctly whether it is time to buy or to sell Stocks. With the aid of some technical analysis indicators the user will be even more accurate and certain for what is coming up.     


Fig 9 show me  Among the listed planetary aspects there was also the conjunction between Mars and Saturn. Let us see how the same user saw its effect on the market. Five of these aspects are marked with notes in figure 8. Valuable observation about the remarks writing here is that the analyst has learnt to recognize between the effect of the aspect when the general trend was heading up and the effect of the same aspect when the market was heading down. The usual understanding about  the conjunction aspect between Mars and Saturn is that it is certainly a malefic aspect but how bad is it? How does it affect the market? The answer comes with the state of the market itself whether it is bullish or bearish. And whether this aspect is accompanied with some other bad aspects to make it more evil or was accompanied with beneficial aspects to elevate its effect to become harmful only for shorter period with less souring results.


The sheet created with this Macro does not show what other aspects were accompanying the studied aspect. Therefore, the user should have another Macro to fix the problem. Aspects calculated by Astral are listed chronologically but not necessarily in black ink on white as any usual listing. It could be more helpful for the user when the print recognizes broadly (more or less) between Benefic aspects and Malefics. The Malefics could be listed with red background colour or green for the good aspects. In the column of "Conclusions", the user writes down short notes about how good or how bad was the effect of the planetary aspect.


Fig 13: Shows such sheet with some notes written by a user about the same index mentioned earlier. It illustrates how some users used the software.


Generally speaking, Macros are created to rearrange the listing to make the analysis more friendly and there are several ways to do that:

1) Adding colours to the horizontal rows of the listing according to the planets and aspects angles. show me

2) Grouping the listed aspects according to the planet sending, receiving the aspect and the aspect angle degree show me

3) Adding red colour to those aspects considered as malefic aspects show me

4) Adding green colour to those aspects considered as goods aspects show me

5) Identifying what is specified as Major Aspects in separate sheet show me

6) Classifying the aspects by the year identified show me




               Please send mail to  with your questions and comments about this web site
               Last modified: September 28, 2015