Support Board
Date/Time: Thu, 31 Oct 2024 12:18:13 +0000
horizontal line
View Count: 370
| [2024-09-14 11:57:37] |
| User734593 - Posts: 39 |
|
Hello John, I want from 9.30 a.m. EST (at the opening of the candle) until 12.30EST to draw a horizontal line marking the opening price level of the candle at 9.30 a.m. EST. At the moment I am using the study Horizontal line at time, I also tried the study High/Low for Time Period - Extended.... they reflect well what I want to mark for myself.... Unfortunately, their disadvantage is that: - they automatically extend to the next day until 9:30 am EST (Horizontal line at Time), - study High/Low for Time Period-Extended draws the correct dash (without extension) if I have only one day on the screen, however, if there are consecutive days on the screen then the end of the horizontal line at 12.30EST will merge with a diagonal line with the opening of the bar at 9.30EST on the next day - this diagonal line I want to avoid - it pointlessly blurs the image. Thank you for your help. Greetings Michal |
Private File |
| [2024-09-16 14:17:51] |
| John - SC Support - Posts: 35639 |
|
The "High/Low for Time Period - Extended" is the best study for this. It looks like you have changed the default Draw Style from "Stair Step" to "Line". Make sure the subgraphs Draw Style is set to "Stair Step". Refer to the following: Chart Studies: Stair Step (ACSIL: DRAWSTYLE_STAIR_STEP) 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-09-16 14:18:17
|
| [2024-09-16 16:35:53] |
| User734593 - Posts: 39 |
|
Hello John, great ... just what I was looking for, great job .... For full happiness I still need a study that will draw two lines parallel to this designated High/Low for Time Period - Extended (opening at 9.30 EST - blue line). This study should draw lines at the same time as the H/LfTP-E (from 9.30 a.m. EST to 3.30 p.m.) however, shifted 50 ticks up and the other shifted 50 ticks down in relation to the study High/Low for Time Period - Extended. I tested with study Subgraph Add, but on this study I get out graphs like Horizontal line at Time and some strange vertical dashes (- they tend to zero ?). Also, I don't know how to set an offset of exactly 50 Ticks up (-50Ticks down) in this study Subgraph Add - there is only Amount to Add - but it's not ticks.... Thanks again for your quick help Best regards Michal |
Private File |
| [2024-09-16 18:58:24] |
| John - SC Support - Posts: 35639 |
|
The easiest way to get what you want is to use the Spreadsheet Study. To do this, you would enter the following in cell K3 in order to get a line 50 ticks above the High line: =IF(ID1.SG1@3, ID1.SG1@3 + 50 * $J$21) Where ID1 is the ID of the "High/Low for Time Period - Extended" study, SG1 is the High Subgraph of the "High/Low for Time Period - Extended" study and $J$21 is an absolute reference to cell J21 that contains the Tick Size for the symbol of the chart. You would then repeat this in other columns in order to get other lines relative to where you want them. Be sure to set the subgraph Draw Style for the subgraphs you use in the Spreadsheet Study to be "Stair Step" and that the Input for "Draw Zero Values" on the Spreadsheet Study is set to "No". For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-09-16 20:03:28] |
| User734593 - Posts: 39 |
|
Hello John, I have never worked with Study Spreadsheet. (I have read a little bit even now about this Study, but I have not found a solution.) Something didn't work for me - despite my best intentions. Are you able to give me a hint where I made a mistake? Subsequent values e.g.-50T, +100T, - 100T where should I enter? In a new SpreadsheetStudy or in one but in another cell ? Thank you and kind regards Michal |
Private File |
| [2024-09-16 21:09:39] |
| John - SC Support - Posts: 35639 |
|
Sorry, my mistake. I did not give the correct formula. It should be the following: =IF(ID1.SG1@3, ID1.SG1@3 + 50 * $J$21, 0) You need that last zero for where you do not want the line. You will need to enter a formula in each column for which you want a line. So you would enter the above in cell K3, which populates down through the K column. Then in L3 you would enter the formula you want for a line at -50 ticks and so on. Keep in mind that if you want to reference the Low line of the "High/Low for Time Period - Extended" then you change the subgraph reference from SG1 to SG2. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-09-17 11:48:25] |
| User734593 - Posts: 39 |
|
Hello John, thank you sincerely for your support so far. Everything is working superbly... Thanks to your support. In my decision making process in addition to Study High/Low.... I still use Study Moving Average. I also use its offsets by e.g. 50 T - up to now I was making these offsets using Study Subgraph Add (not an exact solution). Therefore, now I used your formula. I made the offsets of both Study (High/Low and Moving Average) in one Study Spreadsheet, according to the formula you sent (adjusting the ID and changed the Stair Step to line). From all this, I made (saved) Study #5. Unfortunately, after a few minutes, only the orginal lines determined by Study High/Low for Time Period - Extended and Moving Average remain on the graph (on the graphs they are blue lines) and I don't know where the unwanted vertical dashes appear from. When I press Analysis/ Study 5 again everything is ok, exactly as it should be.... for a few minutes and again the situation repeats- vertical dashes appear. I again select saved Study 5 and everything is as it should be. On contract No. 1 after a few minutes everything remains as it was. On Contract #2 after a few minutes only the blue lines (determined by the orginal Study High/Low and Study Moving Average), the vertical unwanted dashes and the remains of the Moving Average lines shifted by 50T and 100T) remain. I am unable to find a solution to this problem. Thank you sincerely for your help. Greetings Michael |
Private File |
| [2024-09-17 14:16:01] |
| John - SC Support - Posts: 35639 |
|
We do not know off hand what exactly is occurring. Please get us the Chartbook that has those charts and the Spreadsheet file you created for this so we can take a look and see what is occurring. Refer to the following for how to get us files: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-09-19 13:22:52] |
| User734593 - Posts: 39 |
|
Hello John, it took a while... in the meantime, I also updated Sierra Chart (from version 2550). However, this did not help. I also noticed that on the 5 minute Study5 John chart it works fine (it starts to show strange signs after a while), while on the 1 minute chart the same Study5 John never looks like it should. I have no idea what this depends on - everything is the same except the time frame scale. Thank you sincerely for your help Greetings Michal |
Attachment Deleted. Private File Private File |
| [2024-09-19 13:31:15] |
| User734593 - Posts: 39 |
|
Hello John, it took a while... in the meantime, I also updated Sierra Chart (from version 2550). However, this did not help. I also noticed that on the 5 minute Study5 John chart it works fine (it starts to show strange signs after a while), while on the 1 minute chart the same Study5 John never looks like it should. I have no idea what this depends on - everything is the same except the time frame scale. Thank you sincerely for your help Greetings Michal |
Private File Attachment Deleted. Private File |
| [2024-09-19 16:06:00] |
| John - SC Support - Posts: 35639 |
|
The main thing that we see is that the Spreadsheet Studies are somehow not correct. In particular, the data that should be showing in columns A through F (Time, Open, High, Low, etc.) are not there. And there is a study reference in columns A/B, which is very confusing. Additionally, the spreadsheet for the 1 minute chart is set to use Sheet 10, but the 1 minute chart is chart #9, so it should be using Sheet 9. You have to be very careful with the Spreadsheet Study and make sure that each chart is referencing its own, correct, sheet. We recommend removing the Spreadsheet studies from your charts and removing the spreadsheet file (DefaultSpreadsheetStudy.scss) from your Data folder and start over. Do not copy any data from the studies to the A-G columns, and make sure each chart is referencing its own sheet. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-09-24 08:40:29] |
| User734593 - Posts: 39 |
|
Hello John, where can I download the factory DefaultSpreadsheetStudy.scss file - unfortunately I saved mine as you wrote earlier .... and now I don't have the original file that I can configure correctly. Since I started with a file-based study (DefaultSpreadsheetStudy.scss) the computer crashes very often and RAM consumption (by Sierra Chart) is 16-18 GB - all the time Sierra is open . Unfortunately, I do not know what was the previous memory consumption (it did not hang then I did not check). At the moment, using Sierra Chart is very inconvenient. I have to turn it on 30 minutes before trading for everything to update (I turn it on for a few hours every day, so there is not that much to update). I'm considering going back to the study that I used to do on study Subgraph Add - however, in this solution there is no accuracy (measured in ticks) that I care about. Thank you sincerely for your help Regards Michal |
| [2024-09-24 14:16:24] |
| John - SC Support - Posts: 35639 |
|
Close your chartbooks by selecting "File >> Close All Chartbooks". Then select "File >> Open Spreadsheet". You will see the file 'DefaultSpreadsheetStudy.scss' listed there. Single click on that filename and then select the "Delete File" button towards the bottom. When you open your Chartboooks up, you will need to redo the Spreadsheet studies on your charts. Make sure you have the correct sheet numbers associated with each chart so things do not get messy. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-09-26 08:52:54] |
| User734593 - Posts: 39 |
|
Hi John, Everything works very well - after rewriting all the information. Thank you very much. I still have questions that I could not find answers to (in the help materials): 1) In the DefaultSpreadSheetStudy workbook I want to write my formula in cell AA3 and AB3, unfortunately after typing it and pressing "OK" the formula disappears in both cells .... as if formulas cannot be written in them .... What could be the reason for this? (In the study itself on the chart, everything is set to display this study on the chart; In the settings value "Number of formula columns" I set it to 20, so it should be visible and not disappear immediately after pressing OK). 2) I am puzzled why I can't edit the formulas in the Y3 and Z3 fields - I wanted to edit these formulas in connection with the fact that I couldn't add formulas in the AA3 and AB3 fields - but editing turned out to be impossible. After changing the formula and pressing OK, the old formula from that cell appeared.... I do not know what could have caused this. 3) Are there any tools that allow you to study a given value over time? For example, I have a contract 6J and I would like to find out if it behaves similarly in the month of June in 2024, 2023 and 2022. Or that it would be possible to display this 6J contract on three monitors - June'24, June'23 and June'22. Thank you very much for your help so far. Best regards Michal |
| [2024-09-26 14:03:20] |
| John - SC Support - Posts: 35639 |
|
1) 2) These should not be occurring. Given that you changed the "Number of Formula Columns" to 20, you should be able to enter formulas in the AA and AB columns. You state that you are entering these in row 3, just like you would with any other column, so there should not be a problem. The same is true for columns Y and Z not editing properly. Please get us that spreadsheet file and the chartbook again by following these instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile 3) You can open specific contracts for a symbol, you just need to type in the name of the symbol on the Find Symbol window. For instance, to view the data for the June 2023 contract for 6J, you would enter the following symbol (per Interactive Brokers symbol specifications): JPY-202306-CME You will get a notice that the symbol needs to be rolled over, just ignore this and it will go away after 2 minutes. You can then open as many charts as you want for whatever symbols you need. Alternatively, you can use the Continuous Futures Contract as a way to view historical data. Refer to the following: Continuous Futures Contract Charts For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-09-30 10:02:54] |
| User734593 - Posts: 39 |
|
Hi John, 1) I addressed this issue - I added new columns and was able to edit the SpreadsheerStudy, or maybe my mistake was that I originally edited this study for sheet #10 (and that's why I couldn't edit it when I had sheet #4 selected in the .scss study file). Ad 3) In the question: "Are there any tools that allow you to study a given value over time? For example, I have a 6J contract and I would like to find out if it behaves similarly in the month of June in 2024, 2023 and 2022". Rather, I meant to have, for example, a 6J contract (5 minute candles) set up for June 2024, June 2023 and June 2022 on separate monitors .... and be able to move them in parallel .... If I move the contract on one monitor, can it move simultaneously on the other monitors ....? Unless there is another tool in Sierra Chart to check the seasonality of the behavior of a given contract based on past years. 2) The economic data provided has an impact on the futures market. I have created an Excel file with this data and what it means for the markets. One sheet with positive data for the dollar (sheet #1), the other sheet with negative market data for the dollar (sheet #2). Is there a tool that allows me to import the date and time of the data into my chart? Until now, I have been manually applying these dates to all the charts of the contracts I follow (but this is a rather time-consuming task). I used the "Date Marker" tool (I marked the data from Sheet 1 with a green arrow (with time) and the data from Sheet 2 with a red arrow (with time) .... and now I would like to automate this and download this data from an Excel file - ultimately to all charts that are connected by a link, for example. My chart looks like this Region 1 - price chart, Region 2 - chart with volume and in region 3 I would like to place "green/red arrows with time" based on the Excel file. Thank you very much for your help so far. I wish you a good week Best regards Michal |
| [2024-09-30 18:01:24] |
| John - SC Support - Posts: 35639 |
|
1. Very good. 3. Since you are inherently looking at different dates, there is not a tool to align the dates. There are options to align charts to the same date and time, but not to the same time with a different date. It sounds like the "Relative Volume" study my give you what you are looking for. Refer to the following: Relative Volume 2. There is no built-in method to do this. You would need to create a custom study to ready in your data and then use it as you want. Refer to the following: ACSIL Programming Concepts: ACSIL File Functions https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-09-30 19:35:18] |
| User734593 - Posts: 39 |
|
Hi John, It's too bad you can't study the seasonality of contract behavior. As for ACSIL programming - that's too high a threshold for my skills.... I have another question... is it normal that Chartbook of a futures contract (time scale 1 minute, 5 minutes, 15 minutes, 4 hours, daily and weekly) - nothing else I have open - with my study SpreadSheet can take up to 12GB of RAM with 32GB of available memory and 15% CPU utilization - Intel Core i7-8850H 2600MHz, GPU load %, Network 0% - 0.2MB/s And very high power consumption? The total transaction latency is about 3 seconds. I recently lost my SL due to the delays described above. Even disconnecting from my broker (i.e. File->Disconnect) does not change much - CPU load 0.1% but RAM load remains at 11.3 GB. Please help... Because these transaction delays are ruining me. Thanks and best regards Michal |
Private File |
| [2024-09-30 19:59:45] |
| John - SC Support - Posts: 35639 |
|
We can not answer the question you are asking. If you are seeing a delay in your charts, then you may need to reduce the overall load. Refer to the following: High CPU Usage | Inactive User Interface | Poor Performance | Long Time to Load Chart Data | Charts Reloading Often Also, you state that "I recently lost my SL due to the delays described above.". This does not make any sense to us, as the Stop Loss should have been on the exchange, unless you were using a specifically client-side Stop Loss. If the Stop is on the exchange, and did not do what you were expecting, then you need to check with your broker or the exchange, to find out what occurred with that order. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-09-30 21:44:41] |
| User734593 - Posts: 39 |
|
Hello John, thanks to the information you sent me I realized that SpreadSheetStudy had too long response time (more than 6000ms) - in Study I reduced the number of Number of Rows (it was 1,000,000) and the number of days on the charts - and now the response time is 300ms ( RAM consumption dropped from 12GB to 3GB and CPU load from 15% to 5% ) and everything works very well. Thank you sincerely and best regards Mcihal |
| [2024-10-02 07:34:49] |
| User734593 - Posts: 39 |
|
Hi John, What can I do to transfer what SpreadSheetStudy draws on the 15 minute chart to the 5 minute chart (same contract, in the same chartbook)? The SpreadSheetStudy drawn on the 5 minute chart (based on the 5 minute chart) has a little too much margin of error, so I want to transfer the SpreadSheetStudy analysis from the 15 minute chart to the 5 minute chart. Thank you very much and best regards Michal |
| [2024-10-02 13:59:11] |
| John - SC Support - Posts: 35639 |
|
If we are understanding correctly, you would use the "Study/Price Overlay" to draw what is calculated on the 15 minute chart to the 5 minute chart. Refer to the following: Study/Price Overlay Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-10-02 19:02:02] |
| User734593 - Posts: 39 |
|
Hi John, that's exactly what I meant, it works great (even the response time dropped from 300ms to 18ms...) Super, thank you very much In my chartbook I have a 1 minute chart and a 7 minute chart. Is it possible to automatically mark on the 1-minute chart (e.g. with a dot drawn with the marker tool) the moment when each successive 7-minute candlestick starts to draw? Thank you very much for your help, best regards Michal |
 wykres 1 i 7 min.jpg / V - Attached On 2024-10-02 19:01:36 UTC - Size: 30.08 KB - 14 views |
| [2024-10-02 19:48:06] |
| John - SC Support - Posts: 35639 |
|
You can not use the Marker tool to do this. This is going to sound a bit weird, but the following is the easiest way to do this (otherwise you would need to use a Spreadsheet and look at the Session Start Time and check the times against each other based on the start times): - Add a Study/Price Overlay to the 1 Minute chart and overlay the Main Price Graph from the 7 minute chart. You can hide this study. On this Study/Price overlay set the following: -- Study to Overlay: 7 minute chart's Main Price Graph -- Data Copy Mode: Use Earliest Value from Corresponding Time Frame in Source Chart -- Bar Time Matching Method: Containing Match -- Fill Blanks with Last Value: No - Then add a "Study Subgraph Reference" study to the 1 minute chart and set the following: -- Study Subgraph to Reference: Select the Study/Price Overlay and any of the Open, High, Low, or Close (it doesn't matter which one) -- On the Subgraph tab set the "Draw Style" for the subgraph to be "Point on High". -- On the Subgraph tab set the "Size" for the subgraph to be the size you want (start with 10 and adjust from there). For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-10-20 21:30:19] |
| User734593 - Posts: 39 |
|
Hi John, I am using two different studies on one chart. From 9:30 am to 10:30 am EST my study 1 gives me better signals, while from 10:30 am to 15:30 EST my study 2 gives me better signals. At the moment I switch them manually ... and is it possible in Sierra Chart to automate this process, i.e. from 9.30 to 10.30 Study 1 is displayed on the chart (Study 2 is hidden) while from 10.30 to 15.30 Study 2 is drawn on the chart (and during this time Study 1 is hidden). Thank you very much for your support. Best regards Michal |
To post a message in this thread, you need to log in with your Sierra Chart account: