Support Board
Date/Time: Mon, 03 Feb 2025 19:50:14 +0000
Post From: Spreadsheet Trading not recording values correctly?
| [2019-12-01 20:50:57] |
| J4yTr4der - Posts: 20 |
|
I'm assuming I must not be understanding something correctly, but I thought I should ask here in case there is something wrong. I've been trying to use Spreadsheet Trading lately for a few different things. But in reading the documentation, something doesn't seem to be behaving correctly. For example, the spreadsheet has columns K through N, labeled Buy Entry, Buy Exit, Sell Entry, and Sell Exit. And the documentation says things like this: Formula to Count Bars Since An Event
The following formula will count the number of bars since a Buy Entry event occurred (cell K3). This will also stop counting if a Sell Entry event occurs (cell M3). This could be used to cancel an unfilled Order at some number of bars. The formula below would be entered in cell P3. =IF(M3, 0,IF(OR(K3, P4 > 0), P4 + 1, P4)) This seems to say that there should be values in K3 and M3 if a long trade is entered and exited. But these cells are always empty for me. Even when a trade enters or exits, they never have anything in them. Ideally I am trying to define time based exits. I see that there is a field which contains the last entry date/timestamp, but I haven't been able to figure out how to subtract it from the current time in order to determine how long it's been since the trade was opened. I found the above documentation passage looking for solutions since it was about number of bars since trade entry and came up in my searches. What am I missing with this? How is it supposed to work? So far I just don't understand it. |