Support Board
Date/Time: Mon, 25 Nov 2024 04:55:47 +0000
Post From: Question for Spreadsheet Master
| [2014-01-02 19:16:00] |
| 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-50*J21, 4), "") J25, Limit or Stop Price - Sell Exit (N) (read/write): =IF(J5>0, ROUND(J9+50*J21,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. |