Login Page - Create Account

Support Board


Date/Time: Tue, 22 Apr 2025 21:13:50 +0000



how to find entry price on spreadsheet

View Count: 128

[2024-12-28 23:22:19]
User970210 - Posts: 100
Hi,
how to find entry price of open position on spreadsheet? thx
Song
[2024-12-30 14:52:13]
John - SC Support - Posts: 39428
On the Spreadsheet System for Trading is an item in Columns I/J for "Last Entry Fill Price". This will give you the fill price for the last order that was put in and filled. This is different from the Position Average Price, as it is only the last filled order. Refer to the following:
Spreadsheet Systems, Alerts and Automated Trading: Last Entry Fill Price [J48]

There is not way with the Spreadsheets to get each of the fills, if you are needing them for multiple orders that make up a position. To do this, you would need to create a Custom Study. Refer to the following:
Automated Trading From an Advanced Custom Study

https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2025-01-02 21:20:51]
User970210 - Posts: 100
thanks for your reply.
does entry price is automatically recorded in spreadsheet study too?
Song
[2025-01-03 15:11:36]
John - SC Support - Posts: 39428
That field (Last Entry Fill Price) is only available in the "Spreadsheet System for Trading" it is not available in the standard "Spreadsheet Study".
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2025-01-03 16:01:54]
User970210 - Posts: 100
does spreadsheet system for trading only record last fill entry price for the system or it can record live position from manual or other trading system?
Song
[2025-01-03 16:11:05]
John - SC Support - Posts: 39428
It is whatever the last entry price was, regardless of how that entry was done.
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