Login Page - Create Account

Support Board


Date/Time: Fri, 29 Nov 2024 12:56:22 +0000



Indicator value from a specified time

View Count: 321

[2023-02-06 13:45:26]
User800756 - Posts: 2
Hi,
I need to get value of indicator from a specified time, Last Entry Trade DateTime to be more specific.
Are there any standard options that can help me?
If there aren't any what ACSIL functions should be used to get it?
[2023-02-06 18:16:26]
John - SC Support - Posts: 36350
The "Last Entry Trade DateTime" is available in the Spreadsheet System for Trading in cell J42.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-02-07 13:21:59]
User800756 - Posts: 2
Hi John,
That's right however it's not what I'm trying to find out.
As an example: Last Entry Trade DateTime (read-only):  2023-01-31 13:48:11. How to get a value of DMI DI+ at that time, 2023-01-31 13:48:11?
[2023-02-07 16:28:38]
John - SC Support - Posts: 36350
You would need to use the Spreadsheet System for Trading and do not use it for trading (unless you want to). You would want to compare the value in J42 against the Time in Column A. Refer to the following for information on Date/Time and specifically refer to the sub-section on "Comparing Serial Date-Time Values":
Spreadsheet Functions: Serial DateTime Values

Note that you will not be able to get the actual value of the DMI DI+ at that exact time - you will get the value of the DI+ for the time of the bar that contains that time.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account