Support Board
Date/Time: Thu, 12 Jun 2025 08:31:09 +0000
[Locked] - study spreadsheet
View Count: 665
| [2022-11-05 17:28:17] |
| User591166 - Posts: 9 |
|
bonjour j'ai mis en place un study basé sur un spreadsheet afin d'afficher les niveaux des support closeCash; openIB; openCash .. j'utilise un spreadsheet basé sur un chart OHLC en 30mn. je limite le nb de ligne du SC a 1 journée. j'identifie dans les colonnes klm les valeurs correspondantes aux TPO souhaitées. jusque la tout va bien, je recupere bien par calcul les niveaux de prix pour chaque ligne support souhaité. le probleme vient a l'affichage: tout s'affiche correctement si je met un diamant, une croix ou un point, mais pas moyen d'afficher une ligne. j'ai essayé pour les subgraphs a afficher les "Draw style" suivant sans succes : line; line-skip zero; line extend to edge; stair step to edge -> s'arrete au chandelier suivant line at last bar to edge; line at last bar to left/right side -> l'affichage disparait j'ai essayé d'ajouter un "study subgraph add" basé sur le spreadsheet mais j'ai exactement le meme resultat. y a t'il une erreur a mon niveau ou y a t'il un autre moyen pour tracer une ligne sur un niveau determiné par spreadsheet ? enfin le study line "based on" le study spreadsheet ne renvoie pas les parametres permettant de lui affecter la valeur souhaitée. cordialement |
| [2022-11-07 22:09:03] |
| John - SC Support - Posts: 40376 |
|
From Google Translate: I set up a study based on a spreadsheet to display closeCash support levels; openIB; openCash..
I use a spreadsheet based on an OHLC chart in 30mn. I limit the number of SC lines to 1 day. I identify in the klm columns the values corresponding to the desired TPOs. until then everything is fine, I recover well by calculation the price levels for each desired support line. the problem comes in the display: everything is displayed correctly if I put a diamond, a cross or a dot, but no way to display a line. I tried for the subgraphs to display the following "Draw style" without success: line; line-skip zero; line extend to edge; stair step to edge -> stops at the next candlestick line at last bar to edge; line at last bar to left/right side -> display disappears I tried to add a "study subgraph add" based on the spreadsheet but I have exactly the same result. Is there an error at my level or is there another way to draw a line on a level determined by spreadsheet? finally, the study line "based on" the study spreadsheet does not return the parameters allowing it to be assigned the desired value. You mention TPOs, are you trying to display the information on a TPO chart? That would be the reason why it would not work. There are a limited set of studies that can be used with the TPO study. Refer to the following: Time Price Opportunity (TPO) Profile Charts: Using Other Studies on a TPO Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-11-08 14:45:58] |
| User591166 - Posts: 9 |
|
hello I confirm to you that I am on an OHLC chart in 30 minutes (candle that I improperly call TPO). in the attachment you can see that I display the desired levels with a diamond a dot or..., but impossible to display a line. thank you |
 supportSierra.png / V - Attached On 2022-11-08 14:44:40 UTC - Size: 6.15 KB - 101 views |
| [2022-11-08 18:47:17] |
| John - SC Support - Posts: 40376 |
|
We only see one data point for each of the items (1 yellow diamond, 1 red dot, and 1 blue dot). Therefore, if you are trying to use the Line option, this will not work as you only have 1 data point and you really need to have 2 to create a line. If, however, you want a line at the level of that one point that extends left or right (or both), then refer to the following Draw Styles: Line at Last Bar to Edge: Chart Studies: Line at Last Bar to Edge (ACSIL: DRAWSTYLE_LINE_AT_LAST_BAR_TO_EDGE) Line Extend to Edge: Chart Studies: Line Extend To Edge (ACSIL: DRAWSTYLE_LINE_EXTEND_TO_EDGE) Line at Last Bar to Left Side: Chart Studies: Line at Last Bar to Left Side (ACSIL: DRAWSTYLE_LINE_AT_LAST_BAR_TO_LEFT_SIDE) Line at Last Bar Left to Right: Chart Studies: Line at Last Bar Left to Right (ACSIL: DRAWSTYLE_LINE_AT_LAST_BAR_LEFT_TO_RIGHT) Line from End of Chart Left to Right: Chart Studies: Line From End of Chart Left to Right (ACSIL: DRAWSTYLE_LINE_FROM_END_OF_CHART_LEFT_TO_RIGHT) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-11-08 19:27:25] |
| User591166 - Posts: 9 |
|
good evening that's exactly what you want. but as I explained to you in my first post, if the diamond elements are displayed well, the elements that you propose have already been tested and do not work precisely. hence my ticket. post 1: "everything is displayed correctly if I put a diamond, a cross or a dot, but no way to display a line. I tried for the subgraphs to display the following "Draw style" without success: line; newline zero; the line extends to the edge; stair step to edge -> stops at the next candlestick line at last bar to edge; line at last bar to left/right side -> display disappears" Attached is the test result. Cordially |
| supportSierra.png / V - Attached On 2022-11-08 19:26:59 UTC - Size: 73.31 KB - 125 views |
| [2022-11-08 23:03:37] |
| John - SC Support - Posts: 40376 |
|
So sorry - you did state that you tried the other options. And also sorry that the line options did not work, we thought the Line Extend to Edge would work in this case, but we just tried it and we see that it is not doing what you need. The solution is to use the Spreadsheet Study to do the work for you. In an empty calculation column (K - Z by default) enter the following: ==IF(ISNUMBER(EARLIESTNONZEROVALUE(K3:K200)), EARLIESTNONZEROVALUE(K3:K200), L2) Where K3:K200 is the range of the data in which the data point exists and L is the column in which you are entering this formula. Then set the subgraph for column L (or whatever row you are using) to a Draw Style of Line. This will then give you a straight line across the range of the data in the Spreadsheet Study. 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: