Support Board
Date/Time: Thu, 02 Jul 2026 16:55:23 +0000
SpreadSheet Functions
View Count: 139
| [2026-05-07 19:29:38] |
| User38682 - Posts: 25 |
|
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: 4335 |
|
These are the available Spreadsheet Functions: Spreadsheet Functions |
| [2026-05-11 16:27:16] |
| User38682 - Posts: 25 |
|
I'm sorry but your response doesn't tell me anything or help me figure out what specific function will work? Can you be more specific?
|
| [2026-05-11 17:43:34] |
| John - SC Support - Posts: 47009 |
|
You are using a function called "ScStudyValue()". This is not a valid function.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-05-11 18:20:46] |
| Sawtooth - Posts: 4335 |
|
=ScStudyValue(12,2,"Close",0)
Not only are you using a non-existent Spreadsheet Function, you are using an unknown syntax.The 'Study/Price Overlay' study has its own outputs which appear in columns AA and above. You should be able to access the Close (Last) value there. If this doesn't solve your problem, you'll need to describe specifically what you are trying to do. |
To post a message in this thread, you need to log in with your Sierra Chart account: