Login Page - Create Account

Support Board


Date/Time: Wed, 15 May 2024 05:51:32 +0000



Post From: Spreadsheet

[2015-01-27 16:14:02]
User43824 - Posts: 9
Hi Tom,unfortunately, check Trade >> Show Order Fills did not helped. I have tried a formula without using sell J9. The formulas were in collumns K and M. There were TRUE results in both collumns. The problem was, that I could see this situation: One arrow for long position and then two arrows in same direction for short position or two long positions in a row. In cell J26 I set only 1 position. In cells in collumns K and M was $J$8=0. When in cells in collumn M, as a part of formula, was $J$8<0, the result was FALSE. The same result (False) was if there was $J$8>0 in collumn M (as a part of formula).
I need to have only one position.
Can you also please write me, how to set stop loss? I used sell J9 in formulas but you have written that Position Average Price is not retained. I also would need to solve problem with showing two same positions in a row in one direction. I need only one open position.
Maybe its a stupid question, but what exactly mean „to be flat“? I thought that means to have closed position (to have no open position).
Second step will be to add formulas in collumns L and N. But first I would like to resolve mentioned problems (I have already tried put formulas in collumn L, but with FALSE results).
I used formulas set on price movement.
I attached pics with setting the Spreadsheet. Could you please check it?

Could you please answer my questions?

Thanks a lot.



attachmentsc1.pdf - Attached On 2015-01-27 16:13:41 UTC - Size: 769.23 KB - 338 views