Support Board
Date/Time: Mon, 25 Nov 2024 01:59:22 +0000
[User Discussion] - Question for Spreadsheet Master
View Count: 1699
| [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. |
| [2014-01-02 21:09:31] |
| Sawtooth - Posts: 4120 |
|
I didn't pursue that issue because the client abandoned that approach in his system, and I never retested it later to resolve it. Just in case you don't know this already: -If you are not using Attached Orders for your stops and targets, it is so much easier to use them for a disaster stop. -J22-J25 are prices only. They need a formula to go TRUE in K3-N3 to place the order. -When the order is placed by the spreadsheet, J26 controls both the entry and exit quantity and it overrides the Trade Window quantity. To alter the quantity of a pending order from the spreadsheet would require that you to cancel it with a formula in J29, and enter another. You could compare J3 and J5 to cancel it, then L3/N3 would need to go TRUE again. If this doesn't cover it, what is it not doing? |
| [2014-01-03 05:08:23] |
| Sawtooth - Posts: 4120 |
|
OK, I had a few minutes to try this. You need to reverse the comparison operators in your J23 and J25 formulas. Try this: J23: =IF(J5>0,ROUND(J9-50*J21,4),0) J25: =IF(J5<0,ROUND(J9+50*J21,4),0) J26: =ABS(J5) J29: =AND(ABS(J5)<>J3,J3>0) L3: =AND($J$5>0,$J$3=0) N3: =AND($J$5<0,$J$3=0) |
| [2014-01-03 18:21:49] |
| vegasfoster - Posts: 444 |
|
Hi, I caught that the prices were backwards, but the rest of it was all messed up. Because I am scaling I had to change $J$3=0 to $J$3<>$J$5, but now it works perfectly!!! You da man!!! Thanks a bunch.
|
To post a message in this thread, you need to log in with your Sierra Chart account: