Home >> Support Board

Support Board

Date/Time: Tue, 16 Apr 2024 21:00:38 +0000

How to Post a Message for Support

[User Discussion] - Spreadsheet Question

View Count: 1252

[2014-03-06 16:25:18] #1 [Go To First Post]
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] #2 [Go To First Post]
Sawtooth - Posts: 3973
=IF(ROW()=3,YourConditions,0) Date Time Of Last Edit: 2014-03-06 16:36:28

[2014-03-06 17:07:20] #3 [Go To First Post]
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] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #5 [Go To First Post]
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] #6 [Go To First Post]
Sawtooth - Posts: 3973
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] #7 [Go To First Post]
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] #8 [Go To First Post]
Sawtooth - Posts: 3973
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] #9 [Go To First Post]
User15451 - Posts: 27
Tom, Thank you again - Yes i recalculated and reloaded twice to no avail. Strange

[2014-03-07 04:12:05] #10 [Go To First Post]
Sawtooth - Posts: 3973
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] #11 [Go To First Post]
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] #12 [Go To First Post]
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] #13 [Go To First Post]
Sawtooth - Posts: 3973
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] #14 [Go To First Post]
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] #15 [Go To First Post]
Sawtooth - Posts: 3973
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] #16 [Go To First Post]
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: