Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 09:01:20 +0000

How to Post a Message for Support

[Programming Help] - Momentum bar chart Indicator needed

View Count: 2425

[2016-12-04 00:47:05] #1 [Go To First Post]
sean mathes - Posts: 10
I have searched the boards here and looked at the available indicators and I haven't found anything in Sierra that does what I am looking to do. I can't find this with any other charting provider either for that matter. I understand that Sierra can't provide indicators for every request but I would be happy to pay to have it developed if someone can give me a referral. The indicator is very simple. I would like momentum plotted for high, low and close on a bar chart versus the average of a prior period, usually 3 period averages. I have found several indicators that do a HLC / 3 and plot with a line chart but that isn't what I am looking for. I have attached a couple of shots that show graphically what I am looking for as well as the math. Currently this is being done with Excel and would like to have a more convenient way to do this. Thank you I have attached images of an example chart and the math explained.


chart example 3 day.png / V - Attached On 2016-12-04 00:46:03 UTC - Size: 22.66 KB - 536 views math explained.png / V - Attached On 2016-12-04 00:46:13 UTC - Size: 356.11 KB - 554 views Attachment Deleted.

[2016-12-04 02:07:57] #2 [Go To First Post]
Sawtooth - Posts: 3992
This can easily be done with the Spreadsheet Study study. -Put the attached in your Sierra Chart \Data folder -Click on Analysis >> 3bar Momentum- -Choose No when asked 'Clear Existing Studies on Chart?'


3bar Momentum.scss - Attached On 2016-12-04 02:00:55 UTC - Size: 61.58 KB - 291 views 3bar Momentum-.StdyCollct - Attached On 2016-12-04 02:01:10 UTC - Size: 9.4 KB - 300 views 3bar Momentum.PNG / V - Attached On 2016-12-04 02:07:11 UTC - Size: 70.05 KB - 430 views

[2016-12-05 00:14:17] #3 [Go To First Post]
sean mathes - Posts: 10
That's great thank you for putting that together. Would it be possible to change the average calculation to a user defined input? For example if I wanted a daily range vs. the 50 day average rather than always being the static 3 period average? Another example would be a a monthly range versus a 36 month average?

[2016-12-06 02:41:40] #4 [Go To First Post]
sean mathes - Posts: 10
Any other suggestions? I have one now that uses an average HLC simple moving average so that I can set it to whatever period I want for the compare. But the numbers don't match the ones on the spreadsheet study that Tom did and I know that is correct. Not sure why that would be? I attached a shot of what it looks like. The middle study is the one using the MA and doesn't calculate correctly. Date Time Of Last Edit: 2016-12-06 02:45:04


momentum compare.png / V - Attached On 2016-12-06 02:44:00 UTC - Size: 79.23 KB - 346 views

[2016-12-06 06:44:55] #5 [Go To First Post]
Sawtooth - Posts: 3992
The formula you gave in post#1 is a 3-period average of 3 HLC averages. Do you want to change the 3-period to a user defined 50-period? Date Time Of Last Edit: 2016-12-06 14:00:54

[2016-12-06 07:21:14] #6 [Go To First Post]
sean mathes - Posts: 10
Yes I'm sorry I should have been clearer on what I was trying to do. Yes that is exactly what I would like to be able to do. Sometimes it's a 3, a 50 or even 200, depending on the timeframe I am working on.

[2016-12-06 14:18:10] #7 [Go To First Post]
Sawtooth - Posts: 3992
Try this: -Add the Moving Average-Simple study -Set the Input Data to HLC Avg -Set the Length to 50 On the 3bar Momentum spreadsheet, replace the formula in cell L3 with this: =ID2.SG1@3 where ID2 is the Moving Average-Simple study; edit the ID# as needed.

[2016-12-06 18:13:00] #8 [Go To First Post]
sean mathes - Posts: 10
Thank you that did it there are some small differences but I think that must be because of the rounding. So now my issue is that I am unable to save the changes to the sheet. When I close the sheet Sierra asks me if I want to save it, I click yes but then when I reopen the changes are not saved. Better to do this in Xcel? Thanks so much for the help. edit: I tried to rename as a csv in Excel and it just looks like gibberish? Date Time Of Last Edit: 2016-12-06 18:21:56

[2016-12-06 18:31:46] #9 [Go To First Post]
Sawtooth - Posts: 3992
The Formula Source Sheet Number is set to 1, so you must edit formulas on Sheet1.

[2016-12-06 20:47:45] #10 [Go To First Post]
sean mathes - Posts: 10
Thank you so much for your help, I got it all figured out and working!

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