Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 02:14:32 +0000



[User Discussion] - Double simple alert question

View Count: 1540

[2013-07-12 05:41:06]
User86222 - Posts: 10
Under Chart and Chart settings, I can for example create a simple alert like C>10450 to alert me when price is above that level.

But what if I also want another alert to go off if C<10350.

So I want 2 alert conditions. Not just 1. How do I set that up?

Would I use something like

C>10450 OR C<10350



[2013-07-12 06:41:39]
Sierra Chart - Max - Posts: 5554
You will want to do it this way:

=OR(C>10450,C<10350)
Sierra Chart Support
[2013-07-30 13:44:07]
gabby alindogan - Posts: 49
Hi. what is the best way to have SC internally resolve various indicators into a single true or false to signal a buy entry?

Eg. If my buy trigger is LastPr> Mvg Avg(20) and Custom Study1 > custom study2 and ADX > 50 then BuySignal=TRUE. I would like to have this "true" into a study spreadsheet where my VB program can pick it up and submit orders.

I've searched hi and low for examples in the user contributed dll's and can't find much. Thanks.

[2013-07-30 14:28:47]
Sawtooth - Posts: 3952
This is an example:

=AND(E3>AA3,AC3>AE3,AG3>50)

where :
AA3 is the MA(20)
AC3 is the custom1
AE3 is the custom2
AG3 is the ADX
[2013-07-30 14:37:33]
gabby alindogan - Posts: 49
Hi Tomgilb. so you are exporting each study value onto Excel and doing the calculation in it to resolve it to true or false. I was hoping to resolve it inside SC for efficiency since I am not using the native spreadsheet study BUT I guess I can try this for now and see if the slowness is even material. Thanks again!
[2013-07-30 14:40:09]
Sawtooth - Posts: 3952
The above example was intended to be put in a row 3 cell of the spreadsheet study's spreadsheet. If you put it in K3 of the Spreadsheet System for Trading study's spreadsheet, it will trigger an buy entry when TRUE.
Date Time Of Last Edit: 2013-07-30 14:40:37
[2013-07-30 14:53:53]
gabby alindogan - Posts: 49
I don't think I want the 'spreadsheet system for trading' merely the 'spreadsheet study' with all the chart data including the one you suggested (ie true /false)coming into sheet1 thru sheet7 ( if I have 7 tickers). I will then add another Excel sheet and capture the trues/false from the 7 sheets. The last sheet has say 7 tickers in column 1 and 7 t/f in column 2. I will then fire off my VB program and hunt for those true values and fire off orders accordingly. I hope there are no cell access issues when the VB program tries to read from a cell at the same time SC is updating it. Thanks tomgilb.
[2013-07-30 15:11:23]
Sawtooth - Posts: 3952
Have you seen this?:
https://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudyInputs.html#UseExcel

Sierra has standalone spreadsheets that can be inter-referenced from the spreadsheet study's spreadsheet.
Unless your VB programming is doing something unique, you can probably do what you want within SC.
[2013-07-30 15:59:26]
gabby alindogan - Posts: 49
Yes I did look at that and I wish i could keep it inside Sc for efficiency but my broker (MBTrading) is not a supported trading partner so i have to use their API which is the COM model. I do have an IB account so if I move past the smaller fx contracts of MBT into the bigger IB contracts, then I probably would use the SC spreadsheets. Thanks.

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

Login

Login Page - Create Account