Login Page - Create Account

Support Board


Date/Time: Sat, 31 Oct 2026 05:42:15 +0000



LastTradingDate

View Count: 212

[2026-09-15 17:32:18]
User841161 - Posts: 357
Is there Spreadsheet Study field or spreadsheet function inside of the Spreadsheet that will list the LastTradingDate like can bel listed inside of Quoteboard?
[2026-09-15 17:51:10]
John - SC Support - Posts: 48377
That information is not made available anywhere. It is only displayed in the Quote Board.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2026-09-15 22:21:20]
Sawtooth - Posts: 4359
Is there Spreadsheet Study field or spreadsheet function inside of the Spreadsheet that will list the LastTradingDate
There are read-only fields 'LastEntryTradeDate-Time' and 'LastExitTradeDate-Time' in the Spreadsheet System for Trading study (v1) in cells J42, J43.
In v2, these are in all three spreadsheet studies, in cells J47, J49.

V1 is the default. To use v2, set 'Use Column I and J Values Version 2' to Yes.

To extract only the Date, use a formula like this:
=INT(J42)

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

Login

Login Page - Create Account