Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 02:24:10 +0000



Post From: Improvement Suggestion: Alert on reaching Daily Loss Limit

[2020-06-27 18:15:21]
j4ytr4der_ - Posts: 918
On this note, I found another way to get the alert we're after. I wanted an alert when I've hit a certain loss level, net of commissions. Turns out this is pretty easy to do with a Spreadsheet System for Trading study. I put my RoundTrip comsissions in cell AB3, and then put this formula in an alert column (Cell R3 in my case):

=J10 + J11 - (J35 * AB3)

This just adds the open P&: to the closed P&L, subtracts commissions, and then I can set the alert within the Spreadsheet System study to do whatever I want when this is true. In my case I als added some logic to automatically flatten and cancel any additional orders that attempt to place after this is true, just in case I were to do something stupid like completely ignore the alarm (and the hot pink screen!) and trade anyway. I like this better than the Global P&L Management because it's specific to the chart/account being traded in this moment rather than global across the entire platform. It's also very easy to adjust the amount on the fly without dealing with the settings dialog for GPLM.

Seems to work nicely! I'm finding that having a Spreadsheet Trading System open for just about any chartbook is incredibly useful and almost a necessity.