Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sun, 09 Mar 2025 01:31:46 +0000

Spreadsheet Formula

View Count: 676

[Page 1 of 1] First Page -- 1 -- Last Page

[2022-02-20 03:59:40] #1 [Go To First Post]
User483852 - Posts: 16
Hello, is there a way to reference the entry bar in the Spreadsheet formula study? Currently, this is available in the Spreadsheet Study, but I am unable to achieve it in the Spreadsheet Formula Study.
0x Thank you

[2022-02-21 14:55:21] #2 [Go To First Post]
John - SC Support - Posts: 38516
Sorry, but we are not understanding what you mean exactly by "Entry Bar". Do you mean the Open of a bar, or a specific bar in the chart? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
0x Thank you

[2022-02-22 15:36:49] #3 [Go To First Post]
User483852 - Posts: 16
By entry bar - I meant the bar in which the order was filled as shown in the attached screenshot.
0x Thank you
For Sierra Chart Support.JPG / V - Attached On 2022-02-22 15:36:01 UTC - Size: 42.25 KB - 150 views

[2022-02-23 16:08:42] #4 [Go To First Post]
John - SC Support - Posts: 38516
There is not a way to get at that information directly. You would have to use the Spreadsheet System for Trading to get the information and then get what you need out of that Spreadsheet. Refer to the following: Spreadsheet Systems, Alerts and Automated Trading For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
0x Thank you

[2022-02-23 20:12:32] #5 [Go To First Post]
Sawtooth - Posts: 4181
is there a way to reference the entry bar in the Spreadsheet formula study? You could add the Trading: Position Quantity study and find the bar with a change in quantity with the Spreadsheet Formula study, then have it return a value at that bar. Like this: =IF(ID1.SG1<>ID1.SG1[-1],C,ID5.SG1[-1]) This returns the persistent Close price of the bar where the entry was made, until flat where it goes to zero. where ID1 is the Trading: Position Quantity study and ID5 is the Spreadsheet Formula study Or you could add the Trading: Position Average Price study use it's price output as the persistent entry price, until flat where it goes to zero.
0x Thank you

[2022-02-23 23:37:40] #6 [Go To First Post]
User483852 - Posts: 16
This is brilliant tombilb. As always you are wonderful !
0x Thank you

[Page 1 of 1] First Page -- 1 -- Last Page