Support Board
Date/Time: Sun, 19 Jan 2025 08:55:13 +0000
[Programming Help] - Spreadsheet trading averaging entries
View Count: 1363
| [2016-09-21 00:53:43] |
| kagein - Posts: 2 |
|
Hi, I've tried and failed to come up with formulas that would average entries. So after the initial entry, i would like to generate a few equidistant limit orders, that use the entry price as their reference. Any idea how i can go about this?
|
| [2016-09-21 01:11:33] |
| Sawtooth - Posts: 4155 |
|
Assuming your initial entry is at market: For a long entry, try this: J22: =IF(J8>0,J48-J21*4,0) J71: =IF(J8>0,"L","M") This will allow a market order if flat, but set a buy limit 4 ticks below the most resent entry price when in a long position. |
| [2016-09-22 00:46:35] |
| kagein - Posts: 2 |
|
thanks thats exactly what i needed
|
| [2018-02-06 22:26:37] |
| User713273 - Posts: 409 |
|
Assuming my entry is at market and long. How would I set a Buy Exit (LIMIT) at a specific percentage above and below my average entry price? Is this doable? Thanks Date Time Of Last Edit: 2018-02-06 22:35:45
|
| [2018-02-06 22:53:09] |
| Sawtooth - Posts: 4155 |
|
Assuming my entry is at market and long. How would I set a Buy Exit (LIMIT) at a specific percentage above and below my average entry price? Is this doable?
This is how I would approach it: -Don't use columns L and N for these exits. -Create a trade window config that brackets the entry price with a target and stop. -Check 'Use Attached Orders' on the Trade Window. -Use two Formula Columns to calculate the stop and target prices you desire. -Move the target and stop with two instances of the Trade Management By Study study, each one referencing one of the Formula Columns/subgraphs. |
| [2018-02-07 04:39:30] |
| User713273 - Posts: 409 |
|
Thx@tomgilb The problem here in lies the trade window. When I create more than 60 charts within 1 chartbook I get an error stating "Error Creating Trade Window" Is there a way problematically to create simple formulas within spreadsheets that would allow be to sell based on offset percentages? Thanks again! |
| [2018-02-07 05:13:29] |
| Sawtooth - Posts: 4155 |
|
Is there a way problematically to create simple formulas within spreadsheets that would allow be to sell based on offset percentages?
I was unaware there is a limit to the number of open Trade Windows.If this is an all-out exit, my second choice is to use J29 (instead of L3/N3). Reference row 3 so it will happen intrabar, like this: =OR(AND(J8>0,OR(C3>=offsettargetformula,D3<=offsetstopformula)),AND(J8<0,OR(D3<=offsettargetformula,C3>=offsetstopformula))) |
| [2018-02-16 20:53:33] |
| User713273 - Posts: 409 |
|
Thanks @ tomgild Yes this is from the SC Engineering team There is no way the Windows operating system can handle this. This is an insane amount at least according to Microsoft. You are going to need multiple computers. There is no other way around this. Is there a way to actually trail the price action using a stop as well? |
| [2018-02-16 23:07:56] |
| Sawtooth - Posts: 4155 |
|
You can trail any price using the Trade Management by Study study.
|
| [2018-04-03 15:11:18] |
| User713273 - Posts: 409 |
|
Hey Tom, What do you typically input when looking at offsettargetformula and offsetstopformula? Thanks again |
| [2018-04-03 16:13:24] |
| Sawtooth - Posts: 4155 |
|
The offsettargetformula returns the target price and the offsetstopformula returns the stoploss price.
|
To post a message in this thread, you need to log in with your Sierra Chart account: