Login Page - Create Account

Support Board


Date/Time: Wed, 18 Sep 2019 12:24:57 +0000



[Hidden] - Automatically draw a horizontal line on a chart about 10 ticks apart.

[2019-09-07 04:48:16]
Ackin - Posts: 336
I've already done a similar study.

https://www.sierrachart.com/SupportBoard.php?ThreadID=37210
[2019-09-09 18:04:04]
User357195 - Posts: 23
Thanks Ackin, but this is not quite what I want to see on the chart. All I want to see is automated horizontal lines based upon 10 tick increments either above or below the opening print for the ES. The open print would be at 9:30:00 eastern time.
I know there is the horizontal line study but that requires manual input and if i use the tools to draw a horizontal line that also requires a manual entry.

Does anyone else know how to do this with Sierra Charts or maybe could SC instruct me how or could SC add this to their software as a study in a future release?

I have seen many other requests for such a study from others.

Thanks in advance.
Date Time Of Last Edit: 2019-09-09 18:05:59
[2019-09-09 18:29:49]
tomgilb - Posts: 2267
You can do it with the Spreadsheet Study study.
Post again if you want details.
[2019-09-09 23:43:56]
User357195 - Posts: 23
Yes sir. I would need details about how to use the spreadsheet study. To clarify, I would like to have a horizontal line drawn 10 ticks away from the opening print in the ES. Then additional horizontal lines drawn ever 10 ticks on the ES chart both below and above the opening print. Maybe for about 15 horizontal lines and each horizontal line would auto draw on the chart at 10 tick increments starting with the open print price as the anchor and then 15 separate horizontal line. Also, it would be great if the study had the ability to be drawn underneath the main graph line the studies do that are included with the SC software.

I hope that makes sense. Thanks for your help.
Date Time Of Last Edit: 2019-09-10 00:00:57
[2019-09-10 01:08:36]
tomgilb - Posts: 2267
It was easier to build it than to give instructions to do it.

- Put both attached files in your Sierra Chart \Data folder.
- To add the study, go to Analysis >> Line intervals from Open+ and click No when asked if you want to Clear Existing studies.

You must download both files, and you must use the Study Collection to add the study.

The study will draw up to 29 pairs of lines, half above the current day's Open, and half below.
The default shows 3 pairs of lines. To show more lines, go to the Subgraphs tab and set the Draw Style to Dash for the lines you want.
The Open line is Hidden, but you can set its Draw Style to Dash if you want it to show.
There are two user options on the spreadsheet's Sheet1:
Cell I2 sets the line interval from the Open, in ticks.
Cell J2 sets the Open time.
Date Time Of Last Edit: 2019-09-10 15:43:38
attachmentLine intervals from Open+.StdyCollct - Attached On 2019-09-10 01:07:12 UTC - Size: 9.41 KB - 11 views
attachmentLine intervals from Open.scss - Attached On 2019-09-10 15:43:06 UTC - Size: 455.22 KB - 7 views
Attachment Deleted.
[2019-09-10 13:50:53]
User357195 - Posts: 23
How can I say thanks? Thank you very much. I will add those to my chart today after the close.
[2019-09-10 14:49:44]
User357195 - Posts: 23
I just took a minute and added the study. It is exactly what I wanted; and, the instructions were so simple that even I could understand them. Very Nice Work!!!
Let me know if you want to see my chartbook, Tomgilb, and we will figure out a way to send it to you so that only you can know where to go to download it to your Sierra Charts.

Thanks again!!!
Date Time Of Last Edit: 2019-09-10 14:50:25
[2019-09-10 15:33:42]
User357195 - Posts: 23
When I tried to change the time to 09:00:00 in cell J2, the chart still started drawing at 09:30:00. In other words, the study is still using the open print at 09:30:00 instead of 09:00:00. I don't know if it would effect anything but I also changed the interval from open from 10 ticks to 15 ticks.

What am I doing wrong?
[2019-09-10 15:50:47]
tomgilb - Posts: 2267
You did nothing wrong. I did. Do this:

- Close and save the chartbook that uses this study.
- Go to post #6 and download the corrected Line intervals from Open.scss file.
- Put the file in your Sierra Chart \Data folder, and overwrite the existing file of the same name.
- Open the chartbook that uses this study, and verify the time you want in J2.
[2019-09-10 18:43:54]
User357195 - Posts: 23
Ta Da. That worked. Let me know if you would like me to send you my whole ES chartbook. If so, let me know how to make sure it only goes to you. Thanks and good trading to you.
[2019-09-10 19:13:56]
User657945 - Posts: 23
Hi Tom I saw your study and since a long time I was asking here on the forum the possibility to use Excel file as input but the answer was no so I'm using the horizontal lines study. What I do is a little more complicated that the other user request and it is like this:
Each morning I have a personal excel file where for each futures and mainly for the bund I have 5 range levels up and 5 down with input the close of the prior day.
this range levels are not fix i.e. 10 ticks but in the case of the bund 50/68/80/90/100 ticks from the close and the same below the close.
I input the prior close get the output levels and input them manually into the Sierra Horizontal line study so, is it complicated for you to modify the published study to do this and let the range levels as input to be modified for different futures i.e Dax where I use 100/130/170/200 ticks?
Thx
Alberto
[2019-09-10 19:49:30]
tomgilb - Posts: 2267
I have a personal excel file where for each futures and mainly for the bund I have 5 range levels up and 5 down with input the close of the prior day.
You can modify the Line Intervals study to use different offsets for each line.
And you can copy/paste the 5 offset values from Excel to the SC spreadsheet.

- Use cells I2-I6 for the 5 values.
- Use cell J2 for the Close time.
- No need to edit Line 1/Line-1 formulas.
- For Line 2, edit cell AL3 to reference I3: =$AN3+$J$21*$I$3
- For Line -2, edit cell AP3 to reference I3: =$AN3-$J$21*$I$3
- For Line 3, edit cell AK3 to reference I4: =$AN3+$J$21*$I$4
- For Line -3, edit cell AQ3 to reference I4: =$AN3-$J$21*$I$4
- For Line 4, edit cell AJ3 to reference I5: =$AN3+$J$21*$I$5
- For Line -4, edit cell AR3 to reference I5: =$AN3-$J$21*$I$5
- For Line 5, edit cell AI3 to reference I6: =$AN3+$J$21*$I$6
- For Line -5, edit cell AS3 to reference I6: =$AN3-$J$21*$I$6
[2019-09-10 20:08:40]
User657945 - Posts: 23
Thx a lot Tom I will make the modification and test it.
Date Time Of Last Edit: 2019-09-10 20:08:47
[2019-09-10 20:34:44]
User657945 - Posts: 23
I make the modification and changing the closeing time it works but I can't define the correct closing time to get the right data. I mean the bund close at 22 but if I use that time it does not work if I take the 21 I get the lines (so the study works) but that is not the close. Where Am I wrong?p. I use volume bars chart not time based.
Date Time Of Last Edit: 2019-09-10 20:35:27
[2019-09-10 20:40:31]
User657945 - Posts: 23
OK I found the issue: It works on 60 min chart not on volume bar based so I will set it to the 60 min chart and let the volume based chart refer to the 60 min hope not to get too much lag with chart referencing. thx again
[2019-09-10 21:09:08]
tomgilb - Posts: 2267
It works on 60 min chart not on volume bar based
Yes, the formula in AN3, that returns the price at the start time, is more accurate on a time-based chart bar.
Date Time Of Last Edit: 2019-09-10 21:12:59
[2019-09-11 21:48:42]
User357195 - Posts: 23
Hello Tom,

If I want to use your horizontal line study on two separate chartbooks that are both on the same computer, can I create another Line intervals from Open.scss and name it Line intervals from open(2).scss? The 2nd .scss file would have a start time of 9:00 and 10 tick intervals and the first .scss would be on the same computer but have a different chartbook and that .scss would have a start time of 9:30 and a 15 tick interval.

If so, then how would I get each chartbook to recognize the correct .scss file?

Thanks in advance.
Date Time Of Last Edit: 2019-09-11 21:55:19
[2019-09-11 23:17:26]
tomgilb - Posts: 2267
If I want to use your horizontal line study on two separate chartbooks that are both on the same computer, can I create another Line intervals from Open.scss and name it Line intervals from open(2).scss?
Yes, you'll need to give it a unique name for each chartbook. If you concurrently use the same named spreadsheet file in two chartbooks, you could start a recalc loop.

If so, then how would I get each chartbook to recognize the correct .scss file?
You can either copy/paste it in Windows Explorer (in the \Data folder) which will append the name with (2).
Or you can Save As the spreadsheet within Sierra.
You would then Select it in the Spreadsheet Name field of the spreadsheet study's settings.
[2019-09-12 01:35:39]
User357195 - Posts: 23
Hello Tom,

I created a CL oil chart with and set the spreadsheet start time to 09:00:00 and set the horizontal line intervals from the open to be 15 ticks and the spreadsheet is not calculating the lines correctly. From the open it is calculating 14 on the upside and 16 ticks below the open print. I even copied the files from above and reentered them again and it is still not calculating them correctly. Also note that the CL chart is on a separate computer. It seems like the spreadsheet is calculating from 09:30:00 even though it is set for 09:00:00 and the interval is set to 15. The interval is close but is still wrong and the start time seems to want to start at 09:30:00 even though it is set to 09:00:00.

What am I doing wrong now?

The spreadsheet that I have for the ES and NQ are calculating as they should. These charts are on a separate computer from the CL chart with the issue listed above. The ES and NQ are set with a start time of 09:30:00.

I have not even tried to do two separate chartbooks on one computer since i can't seem to get it to work when changing the start time and the interval from the default of 09:30:00 and 10 ticks.


Thanks in advance.
Date Time Of Last Edit: 2019-09-12 01:40:39
[2019-09-12 03:41:48]
tomgilb - Posts: 2267
Are you sure you're not using the uncorrected version? This is the same symptom.

Look at the formula in AN3. Is it referencing $J$2 or TIMEVALUE("09:30:00") ?
[2019-09-12 12:09:46]
User357195 - Posts: 23
Oops. It was an error on my end. Thanks again, Tom.
[2019-09-13 16:51:39]
User357195 - Posts: 23
Hello Tom,

I tried to delete the columns in the spreadsheet for the 16th column to the 29th column so that only the first 15 lines would be drawn and the memory resources could be saved and when I did, I got all types of strange results. I also changed the formula from AN to AA...thought that would work but as usual, I was doing something wrong. I just exited out without saving and it loaded back as it was with no problem.

How would i remove columns 16 to 29 for both above and below the open print line? Please keep in mind that you have to explain it as if you are writing to a dummy....like the books.....How to change spreadsheets for dummies. :)
[2019-09-13 18:03:06]
tomgilb - Posts: 2267
How would I remove columns 16 to 29 for both above and below the open print line?
You'll need to edit the formulas in 31 cells before you can delete columns,
Then you could reduce the Number of Formula Columns to 30,
Then you'd need to edit some Subgraph colors, and create a new Study Collection to capture the changes.

Do you want instructions or maybe it would be easier if I did this. So you only want 15 pairs of lines?
[2019-09-13 20:43:56]
User357195 - Posts: 23
It would be better if you fixed it. Lord only knows how would end up if I "fixed" it. :)

You wrote: So you only want 15 pairs of lines?
You are correct, Tom. 15 lines above and below the opening print.
Maybe you can save it as quick-line-interval....
[2019-09-13 21:15:54]
tomgilb - Posts: 2267
See attached.
attachmentQuick Line Interval.scss - Attached On 2019-09-13 21:15:16 UTC - Size: 100.85 KB - 3 views
attachmentQuick Line Interval+.StdyCollct - Attached On 2019-09-13 21:15:38 UTC - Size: 9.41 KB - 1 views
[2019-09-13 23:26:36]
User357195 - Posts: 23
That worked perfect.

The only thing i noticed is when I started up the quick line interval.scss file my left monitor bounced up and down and then spun around in a circle three times and then sat right back down and it all ran perfect from there.

Is that a new feature in the quick line update? :-)

Thanks again. Let me know if you would like for me to send you my entire chartbook.
Date Time Of Last Edit: 2019-09-13 23:27:10
[2019-09-14 01:53:56]
User357195 - Posts: 23
The following if from post 19 above:

I wrote: If so, then how would I get each chartbook to recognize the correct .scss file?

You wrote: You can either copy/paste it in Windows Explorer (in the \Data folder) which will append the name with (2).
Or you can Save As the spreadsheet within Sierra.



I saved it as an unique name but how to do the other instruction you wrote below?

You wrote: You would then Select it in the Spreadsheet Name field of the spreadsheet study's settings.

I looked but can't figure out which field to change to my new unique name on the additional spreadsheets study?
Sorry..but not very good with spreadsheets, which, I am sure you have noticed. :)
Date Time Of Last Edit: 2019-09-14 01:57:26
[2019-09-14 02:36:47]
tomgilb - Posts: 2267
You first need to create the new uniquely named spreadsheet file.
Once that is done go to the spreadsheet study settings and use the Select button next to the Spreadsheet Name field to choose it.
[2019-09-14 14:12:32]
User357195 - Posts: 23
Thanks Tom. Now I see which one to use.

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

Login

Login Page - Create Account