Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 02:56:15 +0000

How to Post a Message for Support

Accing study data from a preadsheet?

View Count: 1106

[2014-10-17 20:50:12] #1 [Go To First Post]
calitrader - Posts: 28
Hi I haven't been able to figure this out from the docs. Can someone tell me how to plot SG1, SG4 and SG5 in columns K, L and M? And is there a way to only display the Close value in the spreadsheet? Rather than having the O/H/L also? Thank you. Chris


Attachment Deleted. ss01.png / V - Attached On 2014-10-17 20:48:43 UTC - Size: 6.67 KB - 268 views ss02.png / V - Attached On 2014-10-17 20:49:08 UTC - Size: 22.01 KB - 274 views

[2014-10-17 23:20:55] #2 [Go To First Post]
Sawtooth - Posts: 3976
Can someone tell me how to plot SG1, SG4 and SG5 in columns K, L and M? In the New Spreadsheets version: In cell K3: =AA3 or =ID1.SG1@3 In cell L3: =AD3 or =ID1.SG4@3 In cell M3: =AE3 or =ID1.SG5@3 where SG1 is in column AA, SG4 is in column AD, SG5 is in column AE And is there a way to only display the Close value in the spreadsheet? In cell N3: =E3 or =ID0.SG4@3 See this thread: New Non-CLR Spreadsheet Study Study Reference Method

[2014-10-18 00:01:21] #3 [Go To First Post]
calitrader - Posts: 28
Perfect thank you for your reply Tom. I have one follow-up question. Is there a simple way to set all the cells in that column like that? I'd like to have SD1.0, VWAP and -SD1.0 for each time period. I think in Excel you can click and drag but I couldn't find a similar way to do this in the SC spreadsheet. Best regards, Chris

[2014-10-18 00:12:57] #4 [Go To First Post]
Sawtooth - Posts: 3976
Focus the chart, and go to Chart >> Recalculate. This will fill all rows in the column.

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