Support Board
Date/Time: Wed, 27 Nov 2024 22:38:22 +0000
[User Discussion] - feature request - cumulative delta while a position is open
View Count: 1917
| [2014-10-03 06:35:46] |
| Bedhog - Posts: 179 |
|
Hello Support, I would like to see a text study that can be placed in the fill area that shows 0000 on the screen when a trade position is flat. I would like that number to go non-zero and display the cumulative delta at the moment a trade is put on. The number itself could be colored based on above/below zero. I've been doing this manually by marking the delta with a horizontal line and have not been able to pull this together using the spreadsheets. http://www.sierrachart.com/image.php?l=1412318037203.png Thank you very much for implementing my last request. Isolating the triggered study name in its own column is working great. ( Alert Manager Column Order ) Date Time Of Last Edit: 2014-10-03 06:57:29
|
 bedhog-main-display.jpg / V - Attached On 2014-10-03 06:57:20 UTC - Size: 283.24 KB - 554 views |
| [2014-10-03 14:33:49] |
| Sawtooth - Posts: 4120 |
|
You can do this with the Spreadsheet System for Trading study, and the Text Display for Study study. 1) Add the Spreadsheet System for Trading study, give it a name in the Spreadsheet Name field. Use these formulas: H1: =INDEX(AD3:AD1002,MATCH(TRUE,O3:O1002,0),1) (This assumes the cumulative delta close value is in column AD.) O3: =AND($J$42>A3,$J$42<A2) P3: =IF($J$8<>0,$H$1,0) J28: =TRUE DO NOT put any formulas in K3,L3,M3,N3. 2) Add the Text Display for Study study -Set the Study and Subgraph to Display to the spreadsheet study and SG6. |
| [2014-10-05 16:50:43] |
| Bedhog - Posts: 179 |
|
Thank you tomgilb, I'm seeing #REF! in H1. These are 'new spreadsheets' and circular references are not allowed. Is that the issue? I'm also not certain about the reference in O3 regarding A2 as the value of A2 will always show the string 'Date Time'. Same issue - new spreadsheets? H1: =INDEX(AD3:AD1002,MATCH(TRUE,O3:O1002,0),1) AD: [ID2.SG4] Cumulative Delta Bars - Volume - Close O3: =AND($J$42>A3,$J$42<A2) Date Time Of Last Edit: 2014-10-05 16:51:23
|
| [2014-10-05 17:28:36] |
| Bedhog - Posts: 179 |
|
Thank you tomgilb - solved!!! I downloaded the old spreadsheets version and made these changes: Q3: =IF(P3=0,0,AD3-$H$1) Set the Study and Subgraph to Display to the spreadsheet study and SG7. Date Time Of Last Edit: 2014-10-05 17:44:41
|
| [2014-10-20 12:23:28] |
| Bedhog - Posts: 179 |
|
Tomgilb, this is working great. Take a look at the new feature from SC. v1200 added ChartDOM columns for Current Traded ASK/BID Volume! The image shows how the numbers are displayed and I've also tied audio alerts to the delta numbers when they move for/against my favor. Thanks again and good trading to you. Date Time Of Last Edit: 2014-10-20 12:23:48
|
| CHARTDOM.JPG.jpg / V - Attached On 2014-10-20 12:22:09 UTC - Size: 206.92 KB - 505 views |
To post a message in this thread, you need to log in with your Sierra Chart account: