Commodity Strategy
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Rs.
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Golden Cross and Death Cross are important Trend reversal points on a Technical chart of a Stock or Index. Its is based on Moving Average Crossover. It is a general rule that Stock gives a Buy signal when faster moving average crosses above the slower moving average, while its gives a Sell signal when faster moving average crosses below the slower moving average. Golden Cross is indicated when 50 Days simple moving average crosses above the 200 day moving average. And Death Cross is indicated when 50 Days moving average crosses below the 200 day moving average. Either crossover is considered more significant when accompanied by high trading volume.As simple as that! It works perfectly on majority of indices and stocks in a long term.
2
3
Strategy Overview
4
ParamterValue
5
Preferred TimeframeDaily
6
Indicators Used50 Days SMA, 200 Days SMA
7
Buy Condition50 Days SMA is above 200 Days SMA
8
Short Condition50 Days SMA is below 200 Days SMA
9
Stop Loss
No fixed stop loss, Stop and reverse when excel gives opposite signal
10
Targets
No fixed target, Stop and reverse when excel gives opposite signal
11
Excel Sheet
12
Parameter Description
13
Worksheet NameGolden Cross and Death Cross
14
Inputsreliance
Name of the Stock or Index. Ex: NSE:NIFTY, NASDAQ:AAPL
15
1000
Number of shares to Buy when Golden Cross or Death Cross happens
16
1000000Your initial Trading capital
17
120Number of days to backtest this system
18
OutputsFinal Capital (E4)Final capital after backtest period.
19
Profit Points (E5)Total points earned
20
Total Profit/Loss (E6)Total Profit/Loss in Exact terms
21
Total Profit/Loss % (E7)Total Profit/Loss in Percentage terms
22
Screenshot
23
24
How to use this Excel Sheet
25
Step 1: Open the sheet from the link provided at the end of this post.
26
27
Step 2: Provide inputs in Cells B4 to B7. Make sure that you are connected to the internet.
28
29
Step 3: Wait for around 30 seconds. The sheet will update automatically depending on the inputs you provided.
30
31
Step 4: Check the outputs in Cell E4 to E7.
32
33
Step 5: Take Buy/Short position based on the signal at Position column.
34
35
Step 2: Provide inputs in Cells B4 to B7. Make sure that you are connected to the internet.
36
37
Step 3: Wait for around 30 seconds. The sheet will update automatically depending on the inputs you provided.
38
39
Step 4: Check the outputs in Cell E4 to E7.
40
41
Step 5: Take Buy/Short position based on the signal at Position column.
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu