Annual Predictable zones & Calendar Statistics


Steve Bushlack
 

Greetings all,

 

I’ve always booked a good portion of my fuel needs in early December.  With the volatility in the energy markets, timing on purchasing diesel has gotten bigger.  Using the spreadsheet idea that you created for Andrew on the annual predictable zones, I’ve been manually entering the calendar statistics beside them for a change of trend.   I always use a trigger to enter but having the dates available makes it easier for me to pull the trigger on bigger purchases.

 

If you ever have time, would it be hard to export the day of year/month & week stats to excel similar to what you did on the annual Q strategy?  I will show example of screenshots.

 



#1 if export button to excel or csv similar to the annual Q or above next to daily.  

Then we could copy/past next to annual Q strategy to refine the entry date.

 

Thank you & have a great day.

 

Steve

 


SergeyTS
 

Ok, I can add calendar statistic.

Best regards.

Sergey.

On 2022-11-23 9:09 a.m., Steve Bushlack wrote:

Greetings all,

 

I’ve always booked a good portion of my fuel needs in early December.  With the volatility in the energy markets, timing on purchasing diesel has gotten bigger.  Using the spreadsheet idea that you created for Andrew on the annual predictable zones, I’ve been manually entering the calendar statistics beside them for a change of trend.   I always use a trigger to enter but having the dates available makes it easier for me to pull the trigger on bigger purchases.

 

If you ever have time, would it be hard to export the day of year/month & week stats to excel similar to what you did on the annual Q strategy?  I will show example of screenshots.

 



#1 if export button to excel or csv similar to the annual Q or above next to daily.  

Then we could copy/past next to annual Q strategy to refine the entry date.

 

Thank you & have a great day.

 

Steve

 


SergeyTS
 

BTW, if you plan to make statistic for turning points (CITs), better do it using turning points analyzer module this way:


click this button there:


click "Create report" and open "Statistic" tab

this how this report looks:

Weekly Statistic
Monday      Total=383  Tops=163 Bottoms=220
Tuesday     Total=351  Tops=172 Bottoms=179
Wednesday   Total=347  Tops=185 Bottoms=162
Thursday    Total=299  Tops=149 Bottoms=150
Friday      Total=313  Tops=176 Bottoms=137
Saturnday   Total=57   Tops=30  Bottoms=27

Monthly Statistic
Jan.      Total=124  Tops=70  Bottoms=54
Feb.      Total=124  Tops=61  Bottoms=63
Mar.      Total=145  Tops=72  Bottoms=73
Apr.      Total=130  Tops=71  Bottoms=59
May       Total=161  Tops=78  Bottoms=83
Jun.      Total=160  Tops=78  Bottoms=82
Jul.      Total=120  Tops=60  Bottoms=60
Aug.      Total=137  Tops=69  Bottoms=68
Sep.      Total=180  Tops=95  Bottoms=85
Oct.      Total=173  Tops=81  Bottoms=92
Nov.      Total=156  Tops=79  Bottoms=77
Dec.      Total=140  Tops=61  Bottoms=79

Sun in Zodiac Statistic
Aries          Total=127  Tops=65  Bottoms=62
Taurus         Total=169  Tops=86  Bottoms=83
Gemini         Total=160  Tops=82  Bottoms=78
Cancer         Total=127  Tops=58  Bottoms=69
Leo            Total=133  Tops=66  Bottoms=67
Virgo          Total=169  Tops=93  Bottoms=76
Libra          Total=171  Tops=80  Bottoms=91
Scorpio        Total=169  Tops=86  Bottoms=83
Sagittarius    Total=145  Tops=62  Bottoms=83
Capricorn      Total=112  Tops=65  Bottoms=47
Aquarius       Total=129  Tops=65  Bottoms=64
Pisces         Total=139  Tops=67  Bottoms=72

Moon in Zodiac Statistic
Aries          Total=168  Tops=88  Bottoms=80
Taurus         Total=155  Tops=78  Bottoms=77
Gemini         Total=135  Tops=65  Bottoms=70
Cancer         Total=159  Tops=75  Bottoms=84
Leo            Total=134  Tops=64  Bottoms=70
Virgo          Total=116  Tops=56  Bottoms=60
Libra          Total=139  Tops=68  Bottoms=71
Scorpio        Total=134  Tops=72  Bottoms=62
Sagittarius    Total=135  Tops=75  Bottoms=60
Capricorn      Total=168  Tops=76  Bottoms=92
Aquarius       Total=158  Tops=79  Bottoms=79
Pisces         Total=149  Tops=79  Bottoms=70

Moon Waxing/Wanning
Waxing      Total=889  Tops=469 Bottoms=420
Wanning     Total=861  Tops=406 Bottoms=455

Moon Quartes
1 quarter      Total=442  Tops=235 Bottoms=207
2 quarter      Total=447  Tops=234 Bottoms=213
3 quarter      Total=444  Tops=219 Bottoms=225
4 quarter      Total=417  Tops=187 Bottoms=230

Moon 1/8 phases
1 part         Total=205  Tops=103 Bottoms=102
2 part         Total=237  Tops=132 Bottoms=105
3 part         Total=239  Tops=119 Bottoms=120
4 part         Total=208  Tops=115 Bottoms=93
5 part         Total=213  Tops=102 Bottoms=111
6 part         Total=231  Tops=117 Bottoms=114
7 part         Total=203  Tops=92  Bottoms=111
8 part         Total=214  Tops=95  Bottoms=119

Mercury Direct/Retrograde
Direct     Tops=709 Bottoms=707
Retrograde  Tops=166 Bottoms=168

We can read it this way:

Weekly Statistic
Monday      Total=383  Tops=163 Bottoms=220
Tuesday     Total=351  Tops=172 Bottoms=179
Wednesday   Total=347  Tops=185 Bottoms=162
Thursday    Total=299  Tops=149 Bottoms=150
Friday      Total=313  Tops=176 Bottoms=137
Saturnday   Total=57   Tops=30  Bottoms=27

More tops Wednesday, more bottoms Monday

Moon Waxing/Wanning
Waxing      Total=889  Tops=469 Bottoms=420
Wanning     Total=861  Tops=406 Bottoms=455

More tops on Waxing Moon,  more bottoms on Wanning Moon.


Best regards.

Sergey.






On 2022-11-23 2:02 p.m., SergeyTS wrote:

Ok, I can add calendar statistic.

Best regards.

Sergey.

On 2022-11-23 9:09 a.m., Steve Bushlack wrote:

Greetings all,

 

I’ve always booked a good portion of my fuel needs in early December.  With the volatility in the energy markets, timing on purchasing diesel has gotten bigger.  Using the spreadsheet idea that you created for Andrew on the annual predictable zones, I’ve been manually entering the calendar statistics beside them for a change of trend.   I always use a trigger to enter but having the dates available makes it easier for me to pull the trigger on bigger purchases.

 

If you ever have time, would it be hard to export the day of year/month & week stats to excel similar to what you did on the annual Q strategy?  I will show example of screenshots.

 



#1 if export button to excel or csv similar to the annual Q or above next to daily.  

Then we could copy/past next to annual Q strategy to refine the entry date.

 

Thank you & have a great day.

 

Steve