Support Board
Date/Time: Sun, 24 Nov 2024 08:30:45 +0000
Post From: Change chart background color after loss threshold (e.g. -5%)
| [2013-09-27 21:45:19] |
| Sawtooth - Posts: 4118 |
|
You can do this with the Spreadsheet Study study. Add the Spreadsheet Study study -give it a name in the Spreadsheet Name field -set the Chart Region to 1 -check 'Draw Study Underneath Price Graph' -set the K(SG1) Draw Style to Background, and choose color On the spreadsheet: -put this in cell K3: =$J$10+$J$45<$H$1*(1-$H$2) -put your acct balance in cell H1 -put your max % loss in cell H2 -format cell H2 for Percentage: ---right click in H2, choose Number Format, choose Percentage, choose 0%. This will color the chart's background when the Open P/L + Closed Daily P/L is n% less than the acct balance. |