Support Board

Date/Time: Sat, 04 May 2024 05:48:17 +0000

Post From: Question for Spreadsheet Master

[2014-01-02 19:16:00] Link To Thread - Link To Post [Go To First Post]
vegasfoster - Posts: 444
Hi Tom, what did you do? :) http://www.sierrachart.com/supportboard/showthread.php?t=39816&highlight=spreadsheet+orders I've never done this before and I can't figure out what I am doing wrong either. I scale in and out of all my positions and I want to be able to place a safety stop 50 ticks off my average price in case my system goes down. I also want it to update in real time for the current quantity and flip based upon whether I am currently long or short. I prefer to use a spreadsheet so I can see where my order is and be able to manually override the price as necessary. J23, Limit or Stop Price - Buy Exit (L) (read/write): =IF(J5<0, ROUND(J9-50J21, 4), "") J25, Limit or Stop Price - Sell Exit (N) (read/write): =IF(J5>0, ROUND(J9+50J21,4), "") J26, Order Quantity (read/write): =ABS(J5) and then everything else is set as follows: http://www.sierrachart.com/image.php?l=1388690071364.png Thanks for any help.