Support Board
Date/Time: Sun, 02 Feb 2025 23:41:12 +0000
[Programming Help] - Cell spreadsheet study snapshot?
View Count: 956
| [2019-10-07 19:19:22] |
| GreegT - Posts: 23 |
|
Is there a way to do this? For example: a cell that only calculates once or taking only the 1st value of a cell or disabling autorecalculate for 1 cell only or a formula that populates a column with every changing value of a cell, etc.? Thanks |
| [2019-10-07 20:10:49] |
| Sawtooth - Posts: 4164 |
|
There is no way to capture an intrabar value with a spreadsheet study. You can capture an intrabar true/false event using this method: Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition Here's another example: https://www.sawtoothtrade.com/example-9.html |
| [2019-10-08 03:53:16] |
| GreegT - Posts: 23 |
|
Thank you for the response. I looked over the links, they're on the right track but maybe you know a solution to the main problem. My 1 tick spreadsheet study is waiting for the next tick before posting a changing cell. So if 1 trade happens at 10:12:11 AM and another at 10:12:20 AM, the spreadsheet waits for the 2nd trsde before saving the contents of a changing cell, which implies movements that did not take place. So I guess my question: is it possible I can force the 1 tick spreadsheet study to print the most recent trade as it happens? Or is it possible to force a 1 second chart to move every 1 second and add blank data during times of inactivity? Unfortunately the add empty column option still waits for a trade before adding the columns. Either one of these would solve the problem in a roundabout way. Date Time Of Last Edit: 2019-10-08 03:55:27
|
| [2019-10-08 05:06:14] |
| Sawtooth - Posts: 4164 |
|
is it possible I can force the 1 tick spreadsheet study to print the most recent trade as it happens?
What do you mean by 'print the most recent trade' ? If it's a value, it can't be retained unless it exists at bar close. If it's boolean, it could be retained using Locking a True State.is it possible to force a 1 second chart to move every 1 second and add blank data during times of inactivity?
No. Time-based charts cannot be made to do this. This is because new bars are only created if there is a chart update. In the case of a very short time-based bars, bars that don't appear between chart updates can only be backfilled when a chart update occurs.
|
| [2019-10-08 14:06:15] |
| GreegT - Posts: 23 |
|
I worded it poorly. I meant printing the spreadsheets changing cell at the most recent tick. Currently the sheet will wait for the next tick before stamping a changing cell to the previous tick. It is a value, not a boolean, so you answered my question. Thanks again
|
To post a message in this thread, you need to log in with your Sierra Chart account: