NexusFi: Find Your Edge


Home Menu

 





Sierra Chart Worksheet System For Trading/Alert Discussions


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one Sawtooth with 73 posts (125 thanks)
    2. looks_two luckcity with 43 posts (2 thanks)
    3. looks_3 RT912 with 12 posts (0 thanks)
    4. looks_4 bxman with 10 posts (0 thanks)
      Best Posters
    1. looks_one Sawtooth with 1.7 thanks per post
    2. looks_two aBuzz54 with 1 thanks per post
    3. looks_3 tradermark2009 with 0.5 thanks per post
    4. looks_4 MWG86 with 0.3 thanks per post
    1. trending_up 66,133 views
    2. thumb_up 139 thanks given
    3. group 44 followers
    1. forum 182 posts
    2. attach_file 9 attachments




 
Search this Thread

Sierra Chart Worksheet System For Trading/Alert Discussions

  #181 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603


Quoting 
Basically I want to compare 2 different values - A and B.
If A is greater than B , then do this calculations
if B is greater than A, then to other calculation.

Since you want to return the result of a calculation, and not just a T/F, you need to use the IF function:
=IF(id0.sg1[0] > id0.sg2[0], id0.sg1[0] / id0.sg2[0], IF(id0.sg2[0] > id0.sg1[0], id0.sg2[0] / id0.sg1[0],0))
If A is greater than B , then do this calculation, else
if B is greater than A, then do another calculation, else zero.

Note: This syntax is Simple Alert syntax, and can only be used with the Spreadsheet Formula study.
Despite its name, the Spreadsheet Formula study is not a spreadsheet study.
(A spreadsheet study uses spreadsheet syntax.)

Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
MC PL editor upgrade
MultiCharts
Strategy stop orders partially filled
EasyLanguage Programming
Self sabotage reframed
Psychology and Money Management
Trade idea based off three indicators.
Traders Hideout
What broker to use for trading palladium futures
Commodities
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
26 thanks
What is Markets Chat (markets.chat) real-time trading ro …
15 thanks
GFIs1 1 DAX trade per day journal
13 thanks
ApexTraderFunding.com experience and review
13 thanks
EG Indicators
11 thanks
  #182 (permalink)
fxSOL
Belgrade Serbia
 
Posts: 60 since Mar 2020
Thanks Given: 37
Thanks Received: 25


tomgilb View Post
Since you want to return the result of a calculation, and not just a T/F, you need to use the IF function:
=IF(id0.sg1[0] > id0.sg2[0], id0.sg1[0] / id0.sg2[0], IF(id0.sg2[0] > id0.sg1[0], id0.sg2[0] / id0.sg1[0],0))
If A is greater than B , then do this calculation, else
if B is greater than A, then do another calculation, else zero.

Note: This syntax is Simple Alert syntax, and can only be used with the Spreadsheet Formula study.
Despite its name, the Spreadsheet Formula study is not a spreadsheet study.
(A spreadsheet study uses spreadsheet syntax.)

Brother I can not thank you enough for helping me out. Did not know you could use two if statements and I thought OR was enough (either one of the conditions).
However the last 0 what is it for?
I wish there was a donate button somewhere so I could send some coins as thanks!

Reply With Quote
  #183 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603



Quoting 
However the last 0 what is it for?

When sg1=sg2, it will return 0.

Started this thread Reply With Quote
Thanked by:




Last Updated on January 3, 2022


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts