Login Page - Create Account

Support Board

Date/Time: Mon, 27 Jun 2022 02:44:08 +0000

[User Discussion] - Spreadsheet Study Column H question

View Count: 1691

[2013-04-07 15:39:17]
User22396 - Posts: 191
Is it possible to manually enter a value into the spreadsheet that will stay linked to a specific trade date say in column H?

for example using a daily chart at the end of day I would evaluate my take on the days price action and then assign it a number for example say +2, +1, 0, -1, -2...then I could take that data set and plot as a simple rolling 10day numberline

[2013-04-07 16:14:40]
tomgilb - Posts: 3325
Column H is open for the user's static values/formulas, but its cells are not linked to the chart's bars. To plot a numberline you will need to use a formula in row 3 of columns K-Z (or up to column AX in v947 and later). The formula could reference cells in column H.
[2013-04-07 16:59:40]
User22396 - Posts: 191
so sounds like definitely no way to link to date?

and to use Column H I guess I could just 'insert' then shift columns down to keep in line with date?

thanks for the reply Tom
[2013-04-07 17:31:27]
tomgilb - Posts: 3325
For a 10 bar rolling numberline, you could reference H3 to H12 in, for example, K3 with something like this:


Then you would have to daily manually update H3-H12 with your ratings, shifting the ratings down to match the dates.
[2013-04-07 18:59:21]
User22396 - Posts: 191
gotcha thanks...will give it a go

To post a message in this thread, you need to log in with your Sierra Chart account:


Login Page - Create Account