Support Board
Date/Time: Wed, 27 Nov 2024 06:42:32 +0000
Post From: Basic question about a spreadsheet system for trading
| [2024-08-19 15:21:31] |
| AntoineOpala - Posts: 66 |
|
Here's how I have it set: K3 is = E3 = 119.2 J71 is L J22 is 119.2 This was a long play on the XOM stock at 10:15 today. I'd like to trigger this trade again in simulation mode when I replay the chart from 10:14 onwards. The way I have it set up, it still doesn't trigger anything. I tried changing K3 to ID0.SG4@3 = 119.2. I tried keeping J22 empty too. Edit : the problem seems to be with rounding numbers. The only way to make this work is to change K3 to "= E3 > 119.19". In other words, use a great than sign instead of an equal sign. The K column never shows TRUE or 1 as long as I keep an equal sign. With a greater than sign, it's recognized when the price goes above 119.19 and it becomes true. Even though the E3 cell displays 119.2, the actual underlying number may be 119.20099199 or something approximately close but not exactly equal to 119.2. How to round it so it triggers regardless? Edit #2: setting E3 to =MROUND(E3, 0.01) seems to be doing the trick. Date Time Of Last Edit: 2024-08-19 16:16:30
|