Support Board
Date/Time: Mon, 25 Nov 2024 23:20:00 +0000
[User Discussion] - Spreadsheet Question
View Count: 1320
| [2014-03-06 16:25:18] |
| User15451 - Posts: 27 |
|
Dear Support, I have a simple question albeit remedial. Is there a way to only calculate one row 3 in a spreadsheet. Thank You for your Support |
| [2014-03-06 16:36:14] |
| Sawtooth - Posts: 4120 |
|
=IF(ROW()=3,YourConditions,0)
Date Time Of Last Edit: 2014-03-06 16:36:28
|
| [2014-03-06 17:07:20] |
| User15451 - Posts: 27 |
|
Tom, Thank you - that worked however in the spreadsheet however it still draws on the chart. Anyway to stop that and only draw one bar? Thank You for your Support |
| [2014-03-06 17:12:56] |
| |
|
Post #2 is a possible suggestion. If you are using the Sierra Chart Spreadsheet study, you can reduce the number of rows outputted with the Number of Rows input, but the minimum is 10. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2014-03-06 17:22:26] |
| User15451 - Posts: 27 |
|
Thank You Support, Unfortunately i need to use all the rows in other calculations and then combine drawing all but the last row and drawing only the last row from another column. Thank you for your support |
| [2014-03-06 18:51:52] |
| Sawtooth - Posts: 4120 |
|
that worked however in the spreadsheet however it still draws on the chart.
Set the Draw Styles to Ignore or Hidden of all unwanted spreadsheet columns/subgraphs. If another study is drawing something unwanted, either check Hide Study or set its Draw Styles. |
| [2014-03-06 19:15:57] |
| User15451 - Posts: 27 |
|
Tom, I very grateful for your input. Probably trying to do too much only drawing one cell of a spreadsheet. The calcs only populate that one row now however still draws all cells as if they are filled. Trying to just draw one and only one cell without all the others in past drawing. Then overlaying another study for all other periods. Thank you for your support. |
| [2014-03-07 01:16:45] |
| Sawtooth - Posts: 4120 |
|
The formula I offered will only draw in the current bar. Have you done a Recalculate since you entered the formula in row 3? Chart >> Recalculate |
| [2014-03-07 03:35:35] |
| User15451 - Posts: 27 |
|
Tom, Thank you again - Yes i recalculated and reloaded twice to no avail. Strange |
| [2014-03-07 04:12:05] |
| Sawtooth - Posts: 4120 |
|
The formula I offered won't draw anything earlier than the current bar, so what you see is coming from either another column in the spreadsheet, or from another study. |
| [2014-03-07 04:46:19] |
| User15451 - Posts: 27 |
|
Ok, well it's getting late here i will rebuild everything in the morning from scratch and try and see whether that fixes it.
|
| [2014-03-07 18:24:59] |
| User15451 - Posts: 27 |
|
Tom, I re-built a fresh chartbook and spreadsheet. Put the study in and then tried this formula to move and use just the last value. =IF(ROW()=3,AA3,0) |
| [2014-03-07 22:11:31] |
| Sawtooth - Posts: 4120 |
|
Does it work OK? Remember, the formula must go in a row 3 cell of a Formula Column, K-Z...BR, relative to the Number of Formula Columns set in the study settings, 16 to 60. |
| [2014-03-07 22:27:16] |
| User15451 - Posts: 27 |
|
Tom, i understand that the formula must go in row3 in the column i am trying to chart which it is. It still draws every row in spreadsheet when all i am trying to draw Y3 which is where your column draws. Sincerely Jim |
| [2014-03-07 22:29:56] |
| Sawtooth - Posts: 4120 |
|
Please send me your chartbook (.cht) and spreadsheet file (.scwbf), and I'll take a look: tom@sawtoothtrade.com They will be in your Sierra Chart \Data folder Date Time Of Last Edit: 2014-03-07 22:31:35
|
| [2014-03-08 04:42:32] |
| User15451 - Posts: 27 |
|
Tom, I rebuilt all the spreadsheets from scratch in order to export to you and Magically it works now. You are the MANNNNNNNNNNN I don't know if anything changed however i will rebuild all my sheets and see on Monday. Your help as always has been amazing. Sincerely Jim |
To post a message in this thread, you need to log in with your Sierra Chart account: