Support Board
Date/Time: Fri, 08 May 2026 01:11:44 +0000
SpreadSheet Functions
View Count: 14
| [2026-05-07 19:29:38] |
| User38682 - Posts: 24 |
|
Hi I'm currently working on a spreadsheet that gives me the Prem levels using the formula =ScStudyValue(24,2,"Close",0) in cell K3 I then use Chart #12 to pull the closing price for SPX500 using formula: =ScStudyValue(12,2,"Close",0) to be inserted into cell L3 my spreadsheet study keeps giving me #NAME? error code, I've doubled checked my Overlay Study on both charts and I've confirmed it's not a wrong chart # or ID. I believe SierraChart doesn't like the =ScStudyValue function? I've also tried K3 = SC_StudyValue(24,2,"Close",0), and L3 = SC_StudyValue(12,2,"Close",0), with no luck. Can you help me figure out how to populate K3 and L3 correctly?
|
| [2026-05-07 19:49:18] |
| Sawtooth - Posts: 4329 |
|
These are the available Spreadsheet Functions: Spreadsheet Functions |
To post a message in this thread, you need to log in with your Sierra Chart account: