Login Page - Create Account

Support Board


Date/Time: Tue, 01 Jul 2025 09:44:23 +0000



Spreadsheet Buy/Sell Cells Format

View Count: 850

[2016-01-26 09:28:17]
sigmadict - Posts: 95
Hello,
My request is a little bit funky, but I would like your opinion on it.

1- When I run the Automated Trading with Spreadsheets, sometimes I like to analyse the Cells of the Buy/Sell Entries, but it is hard to try to find the Cells punching 1 or 0.
Would it be possible to have an option to color the Buy/Sell Entries (positions) to have a quick reference to the Eye, when we scroll down to analyse some trades ?

2-Would it be possible in some way to trace the Buy/Sell Exits on the Sreadsheet generated by the Chart Trade Window Attached Orders, and not the Buy/Sell Exit Cells from the Spreasheet ?

Thanks !
Regards
Date Time Of Last Edit: 2016-01-26 09:30:07
[2016-01-26 09:45:30]
Sierra Chart Engineering - Posts: 104368
1. This is not supported.

2. You can determine this through the Order Action Source field in the Trade Activity Log:
Trade Activity Log
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2016-01-30 06:12:43]
sigmadict - Posts: 95
Thanks for the response,

I tried your Solution, but with the Order Action Source I can not get the details of the Studies Formulas and Data.
I was Interested in Analyzing what happened at some specific Trades, by seeing the Data from the Studies.
But when the Systems does Not Trade on Bar Close (so we get a Entry/Exit Signal) it is merly impossible to figure out where the Trades actually happened, from my understanding.

Would it be possible to achieve this Task ?

Regards
[2016-01-30 06:16:54]
sigmadict - Posts: 95
To be more specific, I would like to know if it is possible to see from inside the Spreadsheet, where the Trades occured, when the Conditions of Entry/Exit are not on Bar Close (0 value in Cell of Columns K, M, but trade actually occured), and go threw the Data in Cells of the Studies on the Spreadsheet).

Regards
[2016-01-30 06:43:56]
sigmadict - Posts: 95
Hello,
I think I understood that by accessing the Trade Activity Log, I will get the Times of the Transactions, so then I can refer to the Spreadsheet Data, even if there is no Entry/Exit Signal, I have the exact Row with the Time of the Trade Activity Log.
Sorry about that, now I understood.

So if we can get the information from the Trade Activity Log about the Times of the Trades, is there a quick way to go to the Specific Rows in the Spreadsheet, without having to scroll down many lines ?

Thank you
Regards
[2016-02-02 21:31:56]
Sierra Chart Engineering - Posts: 104368
No.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to 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