Login Page - Create Account

Support Board


Date/Time: Fri, 13 Jun 2025 08:00:04 +0000



Post From: study spreadsheet

[2022-11-07 22:09:03]
John - SC Support - Posts: 40407
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