Login Page - Create Account

Support Board


Date/Time: Mon, 16 Jul 2018 00:50:59 +0000



[User Discussion] - Spreadsheet Study Column H question

Support Request:
[2013-04-07 15:39:17]
User22396 - Posts: 186
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: 1873
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: 186
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: 1873
For a 10 bar rolling numberline, you could reference H3 to H12 in, for example, K3 with something like this:

IF(ROW()>12,0,H3)

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: 186
gotcha thanks...will give it a go

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

Login


Login Page - Create Account