Support Board

Date/Time: Wed, 01 May 2024 22:27:55 +0000

Post From: Prevent spreadsheet trading if there was already an order

[2013-12-01 22:04:31] Link To Thread - Link To Post [Go To First Post]
JordiE - Posts: 38
Hi tomgilb, thank you for coming back so quick. Each Automated System for a Symbol, has 8 identical Range charts, except for the Range Value, all of them different. And yes, in all eight Charts, there is one Autotrading Spreadsheet each, and Cell J28 on each Sheet is driven by a unique Cell at Sheet1!B4 with the following Formula: NOT(Sheet1!B4=3)(e.j. for Chart/Sheet3!. In this way, just one Chart/Sheet at a time is the one responsible to send Orders to the market. The value at Sheet1!B4 depends on the trend acceleration measured on each Chart. From your comments, I went into a double-checking on that formulas, and found a problem on Sheet7!J28, where there was, since long time ago starting with the development, a different formula which kept Sheet7!J28 at FALSE status (it means "active to trade"), while the Sheet selected by Sheet1!B4 was another one. This fact could be a reasonable reason, as you mentioned, for double entries....Let's wait and see... It had never happened, during several months backtesting, a double entrie but, maybe the reason could be the different delays between a local backtesting order and a real market order. What do you think about it ? Thanks a lot tomgilb, your comments made me go for a double-check tonight.. Have a nice Monday !! Best regards Jordi