Login Page - Create Account

Support Board


Date/Time: Sun, 16 Mar 2025 20:31:00 +0000



Increased ms in study calculations

View Count: 745

[2022-08-20 17:23:43]
user_xyz - Posts: 453
I use three separate "Color Bar/Background Based on Alert" studies to place a marker on charts based on dates. Recently the ms usage shown has really increased this seems high for simply calculating a date and placing a single pixel arrow beneath a bar.


Alert code used below. This is calculating 24ms in attached image.
=OR(
BARDATE=WORKDAY(EOMONTH(DATE(2020,3,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2020,6,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2020,9,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2020,12,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2021,3,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2021,6,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2021,9,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2021,12,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2022,3,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2022,6,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2022,9,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2022,12,1),0)+1,-1))
Attachment Deleted.
imageSC_ms.png / V - Attached On 2022-08-20 17:22:57 UTC - Size: 9.14 KB - 114 views
[2022-08-20 17:35:00]
user_xyz - Posts: 453
Just added 2019 and 2018 dates as a test and now calculating 52ms for the study...
[2022-08-22 13:46:45]
Sierra_Chart Engineering - Posts: 18799
One thing to be aware of is that is not the incremental calculation time but the calculation time for all bars the formula is being applied to.
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, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-08-23 12:03:15]
user_xyz - Posts: 453
Once the calculation is done and a marker is placed on a chart why is it continuing to calculate such a high ms number? I would think it would be 0ms? It's a daily historical chart. By comparison I have a spreadsheet study that is calculating dozens of formulas with maybe 60 columns of data and it's only 2ms.

Maybe there is a better method for highlight/marking dates on a chart then using an alert and I'm missing something. Calculated or list of dates in a spreadsheet?
[2022-08-23 12:38:11]
Sierra_Chart Engineering - Posts: 18799
That millisecond time does not show the incremental calculation time. Only the full calculation time.

The most efficient study is going to be one that you would create yourself using ACSIL.
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, use the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account