Currency Pair EUR/USD USD/JPY GBP/USD CHF/USD USD/CHF
Monthly Data
Open 13585 8199 15845 12437 11770
High 13861 12083 16277 12459 11802
Low 13426 12009 15820 12389 11736
Close 13747 12073 16103 12439 11785
Weekly Data
Open 13698 12074 16256 12437 11770
High 13838 12083 16272 12459 11802
Low 13524 12009 16029 12389 11736
Close 13747 12073 16103 12439 11785
Daily Data
Open 13796 12074 16132 12437 11770
High 13838 12083 16170 12459 11802
Low 13722 12009 16034 12389 11736
Close 13747 12073 16103 12439 11785
Current Market Price (used to calculate % of range)
Current Price 13747 12083 16103 12459 11802
Notes
1) The white cells of the Data Input sheet are the only areas where data can be entered. All other sheets and cells are protect
2) The data that you enter into the Data Input sheet will be propagated to its proper location in the other sheets.
3) The Currency Pair can be changed at the top of each column to whatever you wish, but should take the format of AAA/BBB
4) The Open is not needed to calculate pivots, but is required to determine trading bias (M1/M3 or M2/M4).
5) The Current Price is used to determine where price is in relation to Monthly and Weekly ranges.
AUD/USD EUR/JPY
7749 15735
7762 15737
7719 15658
7727 15721
7749 15735
7762 15737
7719 15658
7727 15721
7749 15735
7762 15737
7719 15658
7727 15721
range)
7762 15737
sheets and cells are protected to avoid accidental formula changes.
other sheets.
ake the format of AAA/BBB or errors will occur in 'Good To' on the Summary sheet.
Developed and Programmed by Gary Bradshaw
Monthly Pivots
EUR/USD USD/JPY GBP/USD CHF/USD
Open 13585 8199 15845 12437
High 13861 12083 16277 12459
Low 13426 12009 15820 12389
Close 13747 12073 16103 12439
R2 14113 12129 16524 12499
M4 14022 12115 16419 12484
R1 13930 12101 16313 12469
M3 13804 12078 16190 12449
PP 13678 12055 16067 12429
M2 13587 12041 15962 12414
S1 13495 12027 15856 12399
M1 13369 12004 15733 12379
S2 13243 11981 15610 12359
Projected Range 870 148 914 140
Actual Range 435 74 457 70
Trading Bias M2/M4 M2/M4 M2/M4 M2/M4
ts
USD/CHF AUD/USD EUR/JPY
11770 7749 15735
11802 7762 15737
11736 7719 15658
11785 7727 15721
11840 7779 15784
11827 7766 15769
11813 7753 15753
11794 7745 15729
11774 7736 15705
11761 7723 15690
11747 7710 15674
11728 7702 15650
11708 7693 15626
132 86 158
66 43 79
M2/M4 M1/M3 M1/M3
Weekly Pivots
EUR/USD USD/JPY GBP/USD CHF/USD
Open 13698 12074 16256 12437
High 13838 12083 16272 12459
Low 13524 12009 16029 12389
Close 13747 12073 16103 12439
R2 14017 12129 16378 12499
M4 13950 12115 16309 12484
R1 13882 12101 16240 12469
M3 13793 12078 16188 12449
PP 13703 12055 16135 12429
M2 13636 12041 16066 12414
S1 13568 12027 15997 12399
M1 13479 12004 15945 12379
S2 13389 11981 15892 12359
Projected Range 628 148 486 140
Actual Range 314 74 243 70
Trading Bias M2/M4 M1/M3 M1/M3 M2/M4
ts
USD/CHF AUD/USD EUR/JPY
11770 7749 15735
11802 7762 15737
11736 7719 15658
11785 7727 15721
11840 7779 15784
11827 7766 15769
11813 7753 15753
11794 7745 15729
11774 7736 15705
11761 7723 15690
11747 7710 15674
11728 7702 15650
11708 7693 15626
132 86 158
66 43 79
M2/M4 M1/M3 M1/M3
Daily Pivots
EUR/USD USD/JPY GBP/USD CHF/USD
Open 13796 12074 16132 12437
High 13838 12083 16170 12459
Low 13722 12009 16034 12389
Close 13747 12073 16103 12439
R2 13885 12129 16238 12499
M4 13851 12115 16205 12484
R1 13816 12101 16171 12469
M3 13793 12078 16137 12449
PP 13769 12055 16102 12429
M2 13735 12041 16069 12414
S1 13700 12027 16035 12399
M1 13677 12004 16001 12379
S2 13653 11981 15966 12359
Projected Range 232 148 272 140
Actual Range 116 74 136 70
Trading Bias M1/M3 M1/M3 M1/M3 M2/M4
s
USD/CHF AUD/USD EUR/JPY
11770 7749 15735
11802 7762 15737
11736 7719 15658
11785 7727 15721
11840 7779 15784
11827 7766 15769
11813 7753 15753
11794 7745 15729
11774 7736 15705
11761 7723 15690
11747 7710 15674
11728 7702 15650
11708 7693 15626
132 86 158
66 43 79
M2/M4 M1/M3 M1/M3
Monthly Pivot Summary
EUR/USD USD/JPY GBP/USD CHF/USD USD/CHF AUD/USD EUR/JPY
Projected Range 870 148 914 140 132 86 158
Actual Range 435 74 457 70 66 43 79
Trading Bias M2/M4 M2/M4 M2/M4 M2/M4 M2/M4 M1/M3 M1/M3
Good To EUR USD GBP CHF USD USD JPY
Weekly Pivot Summary
EUR/USD USD/JPY GBP/USD CHF/USD USD/CHF AUD/USD EUR/JPY
Projected Range 628 148 486 140 132 86 158
Actual Range 314 74 243 70 66 43 79
Trading Bias M2/M4 M1/M3 M1/M3 M2/M4 M2/M4 M1/M3 M1/M3
Good To EUR JPY USD CHF USD USD JPY
Daily Pivot Summary
EUR/USD USD/JPY GBP/USD CHF/USD USD/CHF AUD/USD EUR/JPY
Projected Range 232 148 272 140 132 86 158
Actual Range 116 74 136 70 66 43 79
Trading Bias M1/M3 M1/M3 M1/M3 M2/M4 M2/M4 M1/M3 M1/M3
Good To USD JPY USD CHF USD USD JPY
EUR/USD USD/JPY USD/JPY CHF/USD USD/CHF AUD/USD EUR/JPY
Current Price 13747 12083 16103 12459 11802 7762 15737
% of Mtly Range 74% 100% 62% 100% 100% 100% 100%
% of Wkly Range 71% 100% 30% 100% 100% 100% 100%