Home >> Support Board

Support Board

Date/Time: Tue, 23 Apr 2024 11:52:42 +0000

How to Post a Message for Support

Quoteboard - moving average

View Count: 1000

[2019-10-20 14:30:49] #1 [Go To First Post]
User495158 - Posts: 106
Hi! Is it possible to display moving average for a number of symbols in a quote spreadsheet? What would be the easiest way to acomplish this? See the attached screenshot. Thanks!


Quote_MA.jpg / V - Attached On 2019-10-20 14:30:06 UTC - Size: 73.78 KB - 306 views

[2019-10-20 22:43:51] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
This can be done by using the Study Summary window: Study Summary Window 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

[2019-10-21 10:46:29] #3 [Go To First Post]
User495158 - Posts: 106
I have one more related question. Would it be possible to save the last price of an instrument with a press of a key to the last column at the time when the key was pressed? In that way a similar functionality to DOM re-centering option would be accomplished. Ie. if the last price is 2950.00 than when I press the key that value would be saved to the last column. If, afterwards the prices moves to 2960.00 than I could easily see the difference in prices, without having to remember what the previous price was. Thanks

[2019-10-21 14:51:51] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You really just have to do your own custom development using a study and then you can output whatever values you want to the study aat the last chart bar which will be displayed in the Study Summary window: Advanced Custom Study Interface and Language (ACSIL) All of this is possible with ACSIL. Or you could just display that particular price directly on the chart or Trading DOM as text. 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-10-21 14:52:08

[2019-10-21 16:29:00] #5 [Go To First Post]
User495158 - Posts: 106
Ok, thanks. It looks like I will have to learn ASCIL :) Is it possible to add blank rows between instruments (charts) in study summary for better visibility?

[2019-10-21 17:22:57] #6 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
No, blank rows are not supported. 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

[2019-10-22 06:22:24] #7 [Go To First Post]
User495158 - Posts: 106
Sorry, but that is not ideal. If I can't use ASCIL to control spreadsheet values (only specific cells) and have to use study summary to display my quotes, being able to customize the appearance of study summary window is very important. That would include the ability to insert blank rows. There is really no point in having a lot of quotes in study summary window if you can't easily see what is going on. I understand that study summary has a different function to spreadsheets, but maybe some workaround is possible? Thanks!

[2019-10-22 22:56:33] #8 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You can use ACSIL to set spreadsheet cells: sc.SetSheetCellAsDouble() 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

[2019-10-23 02:08:28] #9 [Go To First Post]
Sawtooth - Posts: 3976
I understand that study summary has a different function to spreadsheets, but maybe some workaround is possible? There is a workaround using the Spreadsheet System/Alert study. - You'd need a chart for every symbol, same as for the Study Summary. - All charts would need to be in the same chartbook. - The spreadsheet study would need to be added to each chart making available the outputs from other studies on each chart. - You would then add a blank sheet that is not associated with a chart where you would create a 'quoteboard' by referencing each chart's sheet. - Rows can be left blank. - Alerts could be from spreadsheet study formulas. - You can manually color text and backgrounds but conditional formatting is not supported. - You can't sort the table; it would be static. You could manually edit it.

[2019-10-23 06:18:37] #10 [Go To First Post]
User495158 - Posts: 106
Great! Thanks!

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