Support Board
Date/Time: Wed, 27 Nov 2024 22:35:25 +0000
Accing study data from a preadsheet?
View Count: 1167
| [2014-10-17 20:50:12] |
| 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| [2014-10-17 23:20:55] |
| Sawtooth - Posts: 4120 |
|
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@3See this thread: New Non-CLR Spreadsheet Study Study Reference Method |
| [2014-10-18 00:01:21] |
| 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] |
| Sawtooth - Posts: 4120 |
|
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: