Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 04:52:29 +0000



[User Discussion] - Haw can spreadsheet save readings at the moment of order

View Count: 602

[2019-03-24 19:00:37]
User14686603 - Posts: 14
For the trading system , I use study data indicators in columns AA АС АH АI, lines 3 to 12. How can I save the results from these cells at the time of the release of trade orders in columns K or L using a spreadsheet system for further research?
image ПО СПРЕШИТ СОХРАНЕНИЕ ИНФОРМАЦИ.png / V - Attached On 2019-03-24 18:59:36 UTC - Size: 136 KB - 220 views
[2019-03-25 01:06:34]
Sawtooth - Posts: 3993
The only way to 'save' a value in a certain row is to create a persistent variable in a Formula Column.
Note: only close-of-bar values can be persistent.

Here are some examples of persistent variable formulas:
Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables
[2019-03-25 08:49:25]
User14686603 - Posts: 14
Thank you so much tomgilb for the quick reply! Great, that the forum has your posts, I learn from your examples.

Please tell me how to organize the storage of information cells spredshit. Perhaps it should be an array, or something like that, so that the information can be identified with the executed orders in the journal allert manager or trade active log

I do not speak English, so I translate via Google, if something is not clear, please ask again...

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account