Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Since the Kijun-Sen has some segments that are flat, you'll need to use the Spreadsheet System/Alert study so that you can create a persistent variable to 'remember' the direction through those flat segments.
Try a formula like this, e.g. in cell Z3, where the Kijun-Sen is ID1:
It returns a 1 if the line is sloped up, or if the current segment is flat and the previous segment was up.
It returns a -1 if the line is sloped down, or if the current segment is flat and the previous segment was down.
You will then need to find the transitions using formulas in columns K and M:
K3:
=AND(Z4-1,Z3=1)
M3:
=AND(Z4=1,Z3=-1)
Add the Spreadsheet System/Alert study to your chart
-Give it a name in the Spreadsheet Name field
-Assign alerts to Column K and Column M
-You may want to set 'Signal Only On Bar Close (Columns K,M)' to Yes.
-On the Subgraphs tab, set the Draw Style of SG1 to your requirements
-Press OK and OK
-On the spreadsheet:
Put this in cell Z3:
Put this in cell K3:
Put this in cell M3:
The formula in Z3 assumes your Kijun-Sen study is ID1. If it is a different ID#, edit all 12 of the ID1s to the correct ID#.
