Support Board
Date/Time: Sun, 16 Mar 2025 22:52:40 +0000
Increased ms in study calculations
View Count: 747
| [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. |
SC_ms.png| [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: