Support Board
Date/Time: Fri, 29 Nov 2024 04:29:25 +0000
[Programming Help] - Output which Formula was used on spreadsheet trader through order text tag
View Count: 375
| [2023-03-10 14:37:55] |
| User763002 - Posts: 27 |
|
Hello, I have a spreadsheet that utilizes 2 separate strategies, Strat 1 Long and Short params are in Columns P and Q and Strat two Long and Short params are in R and S. The buy/sell formula is =OR(P3,R3) and same for the sell using the correct cells. Everything works great but I am looking to see if there is a formula to tag which strategy was used when the trade executed using the order text tag cell on the spreadsheet? I have tried a few but I am having no luck with anything. As an aside, this spreadsheet trader is very impressive, its much simpler then having to dust off my c++. So thank you for that! Thanks in Advance |
| [2023-03-11 13:21:35] |
| Sawtooth - Posts: 4120 |
|
Are you able to get cell J102 to set any text tag?
|
| [2023-03-11 18:15:47] |
| User763002 - Posts: 27 |
|
Yes thank you for the response, the "Use config as text tag" was checked off, and the formula I got set up as =IF(P4=1,"LE",IF(Q4=1,"SE",IF(R4=1,"LM",IF(S4=1,"SM","")))) Thank you again though! |
| [2023-03-12 20:25:27] |
| User763002 - Posts: 27 |
|
Now I am running into an issue with a random lot being opened after a signal fires. I am using columns P,Q,R,S as mentioned above for two systems long and short signals. I then have an OR function grabbing when one condition is true in the buy/sell column and the trade executes with an attached bracket. Then occasionally a lot will open with no signal and no bracket. I am looking to see if anyone has had a similar issue ruining multiple systems from 1 spreadsheet or if there is a setting I missed somewhere. The trade log does not show the lot as an opening or closing trade and the alert window doesn't show anything either. Any help is greatly appreciated. Thank you |
| [2023-03-12 22:03:53] |
| Sawtooth - Posts: 4120 |
|
The trade log does not show the lot as an opening or closing trade and the alert window doesn't show anything either.
Which trade log? The Trade Service Log should show entries, and log why or why not. In the spreadsheet study settings, you can also set 'Enhanced Auto Trade Signal Logging' to Yes. This will give you lots of log entries, but it might help in finding the cause. Date Time Of Last Edit: 2023-03-12 22:10:00
|
| [2023-03-13 15:17:45] |
| User763002 - Posts: 27 |
|
Excellent and thank you! And the trade log I am referencing is both the service log and the trade activity log. It appears on neither, just on the trade DOM. Thank you again |
To post a message in this thread, you need to log in with your Sierra Chart account: