Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 03:22:43 +0000



[Programming Help] - global/profit loss

View Count: 555

[2018-03-28 01:30:12]
User315986 - Posts: 5
I have read the instructions, and am trying to get my spreadsheet for trading, to flatten and cancel for the day when profit of $200 is reached. Although it does work some days, but on others when I have am -$800 for the day then I make the $200 , it flattens and cancels, but the problem is I am still -$600 for the day. I would like to continue trading to see if I can make my money back and have a $200 day, I tried adding the global , daily loss, but does not change the results. I have also tried using a formula in cell J29 FLATTEN AND CANCEL .=OR($J$10>=200,(J41-INT(J41))>TIMEVALUE("15:00:00") BUT GET A SYNTAX ERROR. I want my trading to stop at 15:00:00 daily and for autotrading to disable at pure $200 profit, but hopefully get back to $200 if not then it will flatten and cancel at 15:00:00, I sure it is user error , but any help would be appreciated.
[2018-03-28 02:03:13]
Sawtooth - Posts: 3973
You'll need to include J45 in your J29 formula:
=OR(J10+J45>=200,J41-INT(J41)>TIMEVALUE("15:00:00"))
[2018-03-28 03:17:44]
User315986 - Posts: 5
thank you , the code looks good, but i tried it and it does not work. no syntax error,for some reason it keeps trading, ? still not sure why the global profit management does not work
[2018-03-28 04:22:51]
Sawtooth - Posts: 3973
You need to put the same formula in J28.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account