Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 01:42:04 +0000



Post From: spreadsheet questions

[2013-05-16 04:37:50]
Sawtooth - Posts: 3952
Maybe you need to round the times in E1 and F1 to a 1 second multiple, like this:

=MROUND(NOW()-INT(NOW()),1/86400)

1/86400 = 1 second

Also, use the MROUND function on the formula in F1.

If I am running the spreadsheet study on a chart would I be able to see the price of any limit orders that I have placed (not filled positions yet)?
No, the spreadsheet study cannot do that.

Date Time Of Last Edit: 2013-05-16 04:38:04