Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 14:10:34 +0000



[User Discussion] - Here is a Divergence Study Collection

View Count: 6892

[2019-04-05 21:32:11]
User7817001 - Posts: 96
I know some Sierra Chart customers appreciate a decent (not perfect) divergence detector.

Not sure if this is a good way to share what I created, but here it is.

In a nut shell,
both MACD (large dots) and Stoch Slow (small dots)
1st and 2nd peak and null identified, MACD and Stoch Slow
1st MACD and Slow Stoch peak or null, Peak or Null current price captured
2nd MACD and Slow Stoch peak or null, recent Peak or Null current price captured and compared to 1st

Yes, this study set is a bit upside down, in that price is not the primary peak/null, but MACD and Stoch Slow peak/null is the trigger
And when there is divergence found a green dot will be for 'long'under the price candle and red dot will be for 'short' below the price candle
I set MACD divergence as a larger size #10 dot
I set Stoch Slow divergence as a smaller size #5 dot

If you copy this study to your C:\SierraChart\Data drive I should work
If not let everyone know in the replies

Mark
imageDivergence chart image.JPG / V - Attached On 2019-04-05 21:30:39 UTC - Size: 188.38 KB - 2406 views
attachmentEMCWIZ Divergence MACD and Slow Stoch.StdyCollct - Attached On 2019-04-05 21:31:05 UTC - Size: 28.01 KB - 981 views
[2019-04-07 22:14:01]
User743797 - Posts: 1
thanks for the study, i added to my data under Sierra but i can't get it to come up
[2019-04-07 23:49:27]
User7817001 - Posts: 96
Sorry, you may also require the 'blank.scss' file which is referred to within the divergence study within the collection, it's attached and should also go into the data directory

Also, any studies you add in addition to this collection need to go after (bottom) of the three within the collection, or the added studies will break this one.
Date Time Of Last Edit: 2019-04-19 09:23:07
attachmentBlank.scss - Attached On 2019-04-07 23:49:22 UTC - Size: 633.06 KB - 716 views
[2019-04-19 08:03:17]
User61576 - Posts: 418
where is the scss file?
[2019-04-19 09:23:26]
Sierra Chart Engineering - Posts: 104368
The spreadsheet file should now be visible in the prior post.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2019-04-19 09:23:33
[2020-02-14 13:40:50]
mtomas - Posts: 21
hi mark

i downloaded the collection, and am using it, i do see the blank.scss in my SC, but i do not get any signals on my chart.

its the eh20, emini current contract, ive tried on 1 min, 5 min, 30 min, everything seems to load but no signals

anything i should tweak? thanks for the help
[2020-05-21 22:02:06]
trading2themoon - Posts: 46
i downloaded the collection, and am using it, i do see the blank.scss in my SC, but i do not get any signals on my chart.

Did you get it working? I finally got it and hooked it into another spreadsheet file, but in translating the cell IDs I noticed an error in MACD T/B referencing X2 and X3, which I'm guessing should be X3 and X4. Is that right User7817001?
[2020-05-22 10:22:37]
User7817001 - Posts: 96
I presume you are referring to the formula in cell Y3 only, this cell will never trigger an "Top" or "Bottom" for the very reason you have seen, if you examine all other cells below Y3...Y4,5,6.. you will see the formula compares the two cells in column X, which DOES post a "Top" or "Bottom" from row 4 and down...while your observation is true, the outcome does not result in an error, thanks for looking through it
[2020-05-22 16:22:41]
trading2themoon - Posts: 46
I presume you are referring to the formula in cell Y3 only, this cell will never trigger an "Top" or "Bottom" for the very reason you have seen, if you examine all other cells below Y3...Y4,5,6.. you will see the formula compares the two cells in column X, which DOES post a "Top" or "Bottom" from row 4 and down...while your observation is true, the outcome does not result in an error, thanks for looking through it

Okay thanks. So the reference from Y4 to Y3 is intentional.
[2020-05-28 09:05:37]
User7817001 - Posts: 96
yes, it is, and for THAT cell, it is non-functional, but for all others, it is functional
[2020-05-29 01:22:08]
User164231 - Posts: 278
Thanks.....yup I tried both under Data directory and same result as per the last 3 tries. Not available either on Add Custom Study nor Studies Available. What is the name it is supposed to be on either study?
[2020-06-23 12:08:19]
User378620 - Posts: 6
Hello,

is there a possibility to display the divergence for the rsi in addition?
[2020-06-23 13:01:27]
User7817001 - Posts: 96
it is possible by editing the spreadsheet, you will need to poke around it a bit
[2020-06-23 16:56:45]
User378620 - Posts: 6
seven sheets within the blank.scss, some with around 2000 lines, that's a bit more than 'poking around' required.
[2020-06-23 17:10:18]
User7817001 - Posts: 96
one only needs to update formula(s) the 1st row/line, the remaining 1999 lines are automatically populated when the script is running, the formulas are simple to decifier, each refers to the predefined sierra chart study on the chart, which you will need to simply replace one of the exiting studies being referenced, or the formula refers to another column in the spreadsheet, also, the column headers are labeled, I understand if you don't wish to take on the task of learning how to do the work, it isn't easy, but give a man a fish or teach them how to fish, good luck
[2020-06-24 03:44:22]
User378620 - Posts: 6
OK, I'll give it a try, but where is here a reference to the Stoch Study ID2.SG1 (or SG1-4)?

Stoch U/D in Line M3:

=IF(BF3=BF4,M4,IF(BF3>(BF4+2),"Up",IF(BF3<(BF4-2),"Down",M4)))
[2020-06-24 14:13:20]
User7817001 - Posts: 96
Great! Yes, the formulas in the cells refer to other cells in the worksheet (same row), those referenced cells are either raw live data feed from your chart, beginning from Column A, then there is a gap of columns with no data or formulas, then columns with my formulas....

Cuz I am dumb, I had to work out the logic over several columns, one for determining where the change of direction takes place, one for plotting the custom study (big dot, little dot), etc...This accounts for the many columns of formulas.

Be careful when adding or removing studies from in the charts where this is applied, the raw data gets inserted/removed and may throw off the complete workbook, experiment, you will see, I think I remember being able to add studies to the very end of the of the study user interface on the chart, or the beginning, not between existing studies...again you will need to play

Hint: in excel if you choose a cell, and it has a formula references other cells, and you click (pretend to edit) the text on in the edit cell atop the worksheet, all referenced cells will be highlighted in the worksheet, allowing you to drag and drop if you need to change the formulas cell references, which you should not, all you should need to do is replace one of the two studies which exist, with the one you want (in the chart studies ui), then make sure the column(s) being filled by sierra chart are filling up with data
[2022-02-23 19:05:27]
User837393 - Posts: 132
Sorry to revive an old thread, but why there is so many sheets? Also I noticed that by ammending the number of rows (ln:4) into the studies, the dots changes in location. … just trying here to optimise the spreadsheet study to make it less demanding ressource wise.
Date Time Of Last Edit: 2022-02-23 19:06:48
[2023-01-19 18:34:49]
mbarbhaya - Posts: 35
Hi Mark,,
I got both the files in my data folder - Blank.scss SpreadSheet and also opened it.
Then in Analysis I found EMCWIZ Divergence MACD and Slow Stoch.StdyCollct , but not able to get it added to my Studies.
Please help me on the procedure. Or is it that files are from 2019 and so not working for me?
Please help

Thank you
Manish
[2023-02-27 16:22:23]
User123091 - Posts: 6
Hi,

sorry for the question, I never used a study whith a scss file. Do I have to load the scss file as a study or only copy the both files into the Data directory and open only the .StdyCollct file (in SC menue "Analysis")?

I'm asking because nothing happens when selecting the .StdyCollct file, it seems it can't be loaded ("Studies to Graph" window is empty) - or maybe the files really don't work with newer versions of SC?

Thanks for infos
Kind regards
Tom
[2023-02-27 16:55:15]
Sawtooth - Posts: 3952
Do I have to load the scss file as a study or only copy the both files into the Data directory and open only the .StdyCollct file (in SC menu "Analysis")?
Put both files in your Sierra Chart \Data folder, then go to Analysis and click on the study collection.

...maybe the files really don't work with newer versions of SC
Older chartbooks and study collections need to be converted to work in newer versions of Sierra Chart.
Chartbooks (Workspaces): Opening Older Chartbooks
[2023-02-27 17:52:11]
User123091 - Posts: 6
Hi,

nice, thank you very much for the info - now it works ;-)

Tom
[2024-02-03 09:15:14]
pawelchasikowski - Posts: 7
Is it possible to create a study that will highlight divergence beetween 2 charys,NQ and ES for example ?
imageScreenshot_2024-02-03-09-28-35-432_com.tradingview.tradingvi.jpg / V - Attached On 2024-02-03 09:13:45 UTC - Size: 388.36 KB - 55 views
Attachment Deleted.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account