Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 15:29:46 +0000



Post From: spreadsheet questions

[2013-05-14 22:48:57]
WarEagle - Posts: 67
I have a couple of questions about the spreadsheet that I could not find in the docs.

1) Can I access information about my orders and/or positions from within a sheet? For example, if I enter a limit order on a chart or DOM I would like to be able to track it in a spreadsheet. I thought perhaps with the auto trading capability that this information might be exposed to the sheet.

2) How often is the spreadsheet recalculated...by a new tick or each second?

3) Can the time that is returned for "LastTime" in the quote line in the spreadsheet be formatted so that it can be compared with the NOW() function? I tried this myself and even though both times are the same, I never get a return of true when comparing them (see pic).

https://www.sierrachart.com/Download.php?Folder=SupportBoard&download=436

Thanks!
imagetime_comparison.png / V - Attached On 2013-05-14 22:44:23 UTC - Size: 3.8 KB - 765 views