Support Board
Date/Time: Mon, 10 Mar 2025 20:28:50 +0000
Is it possible to get drawings data entered in a spreadsheet?
View Count: 2194
| [2017-10-31 04:07:36] |
| 4646ed - Posts: 230 |
|
Without using the horizontal line study, is it possible to draw a horizontal ray and have the price level data show up in a spreadsheet? Also when moving it by hand have that change in value immediately reflected in the spreadsheet? Other drawings would be good too - rays,rectangle edges, extending rectangles edges, etc. This would be good because you could then incorporate that data point into an alert formula that uses other indicator data as well, like slow stochastic oversold and overbought regions. For example you could set the alert formula to include the following conditions: 1. LL from the horizontal ray you yourself drew on the chart 2. slow stochastic less than 20 It would work on rays the same way. The alert conditions could be when price touches the ray while slow stochastic is at a certain level. With an extending rectangle you could have price entering the region of the rectangle at the same time as slow stochastic indicates overbought or oversold. Etc. Doing this you wouldn't be wed to the horizontal line study which is unwieldy to program with every time you want to change a level on the fly. And the ray starts at a particular point on the chart whereas the horizontal line study extends in both directions - even though supply and demand/pivot points/support and resistance levels are frequently shifting depending on which forex markets are open. I draw a bunch of these rays on a bunch of my charts daily - and if i could incorporate them into the spreadsheet that would be phenomenal. Otherwise I have to figure out visually whether the ray being hit and the slow stochastic being overbought or oversold corresponds. The overall goal is to automate it for a couple dozen charts simultaneously. Other studies that wouldn't work are the High/Low and HighestHigh/LowestLow studies -- since they are frequently missing the points that I pinpoint myself, and they are hard to program to get the points I want. Like I said - it has to be something that I can change and incorporate on the fly while trading. The horizontal ray and the ray drawing tools would be the best. Date Time Of Last Edit: 2017-10-31 04:13:46
|
| [2017-11-01 02:48:54] |
| |
|
This is not specifically supported, but Chart and Study Alerts do support accessing the values of a Chart Drawing. Refer to: Study/Chart Alerts And Scanning: Referencing Chart Drawings Here is a link to the top of that page: Study/Chart Alerts And Scanning Let us know if this is a good solution for you. It really should as we understand what you want. You must also update to the current version of Sierra Chart: Software Download: Fast Update 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: 2017-11-01 02:49:37
|
| [2017-11-01 06:29:39] |
| 4646ed - Posts: 230 |
|
I get the point -- too much info. Here's the short version: Generally - This technique is like support and resistance but confirmed by the slow stochastic. I want to place a horizontal ray at a peak or valley if and only if it corresponds to an overbought/oversold region on the slow stochastic. When I have placed the ray I want the data point to show up in the spreadsheet say in a cell-column specific to the horizontal-ray tool. If it shows up there then I can incorporate it into a formula that will alert me -- and instigate a trade -- the next time price approaches/hits that ray's data-point and the slow stochastic is in that same region. The end-goal is to automate the trade. I could program the price point into the formula on the sheet each time -- but that takes a lot of work and time and with 10-20 instruments going simultaneously I certainly couldn't automate it. Is there a modified drawing tool whose every single use sends data to the top of a single column in the spreadsheet? Or can a horizontal ray be modified to do that easily? If so is there a programming cost? Date Time Of Last Edit: 2017-11-02 07:25:44
|
| [2017-11-01 18:09:07] |
| |
|
We are declining support. This support request is way too much information. This is going to be a chargeable request if you want us to read this. Cost will be 25 USD.
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: 2017-11-01 18:09:24
|
| [2022-04-11 03:34:26] |
| User547290 - Posts: 69 |
|
Hey 4646ed, Noticed you posted this years ago so not sure if this helps anymore. I was looking for the same thing, what I did was put a zig zag over the top of the stochastic and this gives me the numbers i'm looking for for tops and bottoms. Then I can use this in the spreadsheet if needed. anyway, very simple and give the info needed |
To post a message in this thread, you need to log in with your Sierra Chart account: