Support Board
Date/Time: Tue, 26 Nov 2024 02:27:15 +0000
Indicator (ROC) when underlying data source (OI) shows zero
View Count: 232
| [2024-01-08 19:41:21] |
| User875622 - Posts: 17 |
|
When ROC source data (OI) necessarily must show zero for current day because data is only available next day; this skews ROC results because of entering a zero value into ROC formula. It basically turns ROC into a flatline especially for short term calcs. How to fix? |
| [2024-01-09 15:23:53] |
| John - SC Support - Posts: 36286 |
|
We are not fully understanding the situation you are describing. Please give us the exact studies and how you have them setup so we can understand what you are trying to do.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-01-09 22:12:41] |
| User875622 - Posts: 17 |
|
I'm using ROC Points 4 period with Open Interest as the source data. Displaying ROC in a separate window. Using this on Livestock markets - HE and LE; daily chart. This impacts charting twice. For an example; for this current day 01/09/24, the daily chart must show zero for OI for this current session because the OI number doesn't yet exist; it's not released by CME until +/- 10:00 PM CT when CME releases it post-close. It's not about SC. SC cannot post what doesn't exist, I understand this. SC applies the OI figure sometime later probably in the early morning pre-open - I don't know when SC posts it and I'm not finding fault with SC's practices. I can - and do- get the number from CME website at the time CME posts it in my Pacific Time evening. I can use the number but it's not on the charts. My analysis can be done without it but it would be nice to have it on the chart. Not an issue. So, #1 During my post-close analysis of a market, or #2 during the next current day while using real time charting, the OI indicator has a 'placeholder' of zero for the OI. Tomorrow at the open of the new session for 01/10 the OI will have updated for 01/09/24, but the now-new session of 01/10 will show zero for OI for 01/10. The placeholder figure (zero OI) is entered by ROC and calculated in the formula and that zero OI number completely throws off the ROC. "Placeholder" is just a term I'm using to describe this I don't know if I'm using correct terminology. Hope I have given an explanation you can use. Thank you for the assistance. |
| [2024-01-10 15:34:04] |
| John - SC Support - Posts: 36286 |
|
We understand the situation you are dealing with now (thank you), but we are not sure how you want to deal with it. There are a few options, but it depends on what you need, or want to see. For example, if you want to have the ROC from yesterday showing on today's bar, then you can use the "Displacement" option for the ROC Subgraph and set it to +1. This will shift the data forward one bar, therefore yesterday's ROC calculation is showing on today's bar. It will still show the "incorrect" data for tomorrow on the chart. Other possible solutions are to use the Spreadsheet Study and shift the OI data forward one day and then calculate the ROC on that. Or, you can shift the ROC forward so you will not have the extra day showing like you do with the displacement. If you need help with any of these let us know. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-01-14 19:35:07] |
| User875622 - Posts: 17 |
|
I understand the answers, thanks. Btw, OI data is incorrect as shown on the chart HEJ24 (or any HE month as OI is Total OI for complex). Correct data follows (as provided from CME) 12/14/23 193026 12/15 191165 12/18 191532 12/19 177725 12/20 179652 Also, might be nice to have Settlements posted sooner than the next morning. CME and Barchart have them at close + 2 hrs. Regards.... |
| [2024-01-17 20:55:29] |
| Sierra_Chart Engineering - Posts: 17179 |
|
Check this setting: Data/Trade Service Settings: Download Total Volume for All Contracts for Futures Daily Data (Global Settings >> Data/Trade Service Settings >> Common Settings >> Historical Daily Data) If you change the setting, then re-download all of the data. Re-download all the data in the chart by going to the chart and selecting "Edit >> Delete All Data and Download" from the main Sierra Chart menu. You just need to do this once per symbol and not for each chart. This command is on the main Sierra Chart menu at the top. Only use it from that location. 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 Date Time Of Last Edit: 2024-01-17 20:56:09
|
To post a message in this thread, you need to log in with your Sierra Chart account: