Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 00:06:18 +0000



[User Discussion] - How to add a Clock on Spreadsheet for autotrade cell?

View Count: 1107

[2013-12-17 18:10:20]
jagoankita - Posts: 24
Hi,
Is there any possibility to display a clock at one of the auto trade spreadsheet cells? I couldn't find the function for this purpose. Thanks.
[2013-12-18 00:23:33]
Sawtooth - Posts: 3976
Cell J41 is the chart time, and you could reference it from any cell. If you are using live data, this will the current time in the time zone set in Data/Trade Service Settings. If you are doing a chart replay, it will be the replayed time.

You could also use the NOW() function in a cell, but note that it is your computer's time, and is only updated when the chart updates, or the bid/ask changes.


[2013-12-18 16:46:29]
jagoankita - Posts: 24
Hello tomgilb, I believe Cell J41 is updated when there is a trade occur. On Sundays night I watched it kept stopping for several minutes when there wasn't any trade. This happened even with ES the most liquid futures. For the illiquid ones even worse. I prefer to use the NOW() function. Thanks.

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

Login

Login Page - Create Account