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
Paramter
Value
5
Preferred Timeframe
Daily
6
Indicators Used
50 Days SMA, 200 Days SMA
7
Buy Condition
50 Days SMA is above 200 Days SMA
8
Short Condition
50 Days SMA is below 200 Days SMA
9
Stop LossNo fixed stop loss, Stop and reverse when excel gives opposite signal
10
TargetsNo fixed target, Stop and reverse when excel gives opposite signal
11
Excel Sheet
12
Parameter
13
Worksheet Name
14
InputsStock Name (B4)
15
Quantity (B5)
16
Initial Capital (B6)
17
Number of Days (B7)
18
OutputsFinal Capital (E4)
19
Profit Points (E5)
20
Total Profit/Loss (E6)
Description
21
Total Profit/Loss % (E7)
Golden Cross and Death Cross
22
Screenshot
Name of the Stock or Index. Ex: NSE:NIFTY, NASDAQ:AAPL
23
Number of shares to Buy when Golden Cross or Death Cross happens
24
How to use this Excel Sheet
Your initial Trading capital
25
Step 1: Open the sheet from the link provided at the end of this post.
Number of days to backtest this system
26
Final capital after backtest period.
27
Step 2: Provide inputs in Cells B4 to B7. Make sure that you are connected to the internet.
Total points earned
28
Total Profit/Loss in Exact terms
29
Step 3: Wait for around 30 seconds. The sheet will update automatically depending on the inputs you provided.
Total Profit/Loss in Percentage terms
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...
 
 
 
प्रपत्र87
प्रपत्र88
प्रपत्र80
Golden Cross and Death Cross की कॉपी
प्रपत्र92
Golden Cross and Death Cross
प्रपत्र91
प्रपत्र93
प्रपत्र90
प्रपत्र89
पिवट तालिका 3
प्रपत्र84
पिवट तालिका 2
प्रपत्र81
Commodity
Form responses 2
प्रपत्र85
प्रपत्र86
Notes
प्रपत्र83
प्रपत्र82
 
 
Main menu