Support Board
Date/Time: Sun, 24 Nov 2024 03:18:35 +0000
[User Discussion] - Spreadsheet Study Column H question
View Count: 2526
| [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] |
| Sawtooth - Posts: 4118 |
|
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] |
| Sawtooth - Posts: 4118 |
|
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: 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: