Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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!