Support Board
Date/Time: Tue, 04 Mar 2025 19:09:32 +0000
[User Discussion] - Timer based copy paste formula in Spread sheet
View Count: 576
| [2021-12-09 11:43:40] |
| VolTrader73 - Posts: 136 |
|
Hello, Id like a formula in spread sheeet that can copy (capture) the value only of a cell to another. For example - I have a formula in Cell A that dose some manipulation on the price. It shows a continually updating value. Id like to have a timer that will copy that value (only the static value captured) every 60 seconds to another cell. I had this working in Microsoft excel but have no clue as to how and do this with SC.. Thank you |
| [2021-12-09 13:14:06] |
| Sawtooth - Posts: 4179 |
|
Id like to have a timer that will copy that value (only the static value captured) every 60 seconds to another cell.
It's not possible to capture a cell's dynamic value intrabar.The solution would involve using a 1 min chart so that every new bar had the static value. You could then overlay that to another chart using the Study/Price Overlay study. |
| [2021-12-31 15:41:55] |
| |
|
For something like this you have to use ACSIL to interact with a Spreadsheet Sheet: ACSIL Programming Concepts: Direct Programmatic Interaction with Spreadsheet Sheets Therefore, it is definitely possible to do what you want. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2021-12-31 15:42:31
|
To post a message in this thread, you need to log in with your Sierra Chart account: