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)
In the current strategy, often seeing two signals on successive bars.
When any signal triggers, there is meant to be an stop order placed some distance away, and because it is offset, doesn't always execute.
So there is also a cancel working orders formula in J26, to cancel after 1 bar.
After 1st signal (bar complete), am seeing order placed, and the cancel after the 2nd bar completed is also seen.
The problem is, not seeing the 2nd offset order placed after the 2nd bar completes.
Will also add that the ss study has "Strict signal only on bar close evaluation" as N, otherwise wasn't seeing stop order placed.
Is the the only way we can enable J26?
It's not possible to create a persistent variable of an intrabar value in a spreadsheet study. Only close-of-bar values can be made persistent.
The only intrabar values that are kept are J42, J43, J48, J49, J93, J94, J95, J96, but only the most recent one is kept.
Depending on what you are doing, sometimes these values can be used.
Is there anyway to have the TIMEVALUE(s) changeable by using a variable in the H column?
Have tried formatting the cell to Time format, and no luck
Jeff
Thought it could work that way, but there must be a trick...
=J41-INT(J41)>TIMEVALUE(H8)
=J41-INT(J41)>TIMEVALUE("H8")
=J41-INT(J41)>TIMEVALUE($H$8)
=J41-INT(J41)>TIMEVALUE("$H$8")
found suggested elsewhere:
=FRACTIME(J41)>TIMEVALUE(H8)
=FRACTIME(J41)>TIMEVALUE("H8")
=FRACTIME(J41)>TIMEVALUE($H$8)
=FRACTIME(J41)>TIMEVALUE("$H$8")
for H8 tried Default (with and w/o quotes) and Time cell formats
You'll need an absolute reference to H6 for a formula in W3:
=IF(AND(!X3,AA3),1,IF(FRACTIME(A3)>$H$6,0,W4))
Also, X3 must be a numeric value when using !
If X3 = 0, !X3 will return 1
If X3 <> 0, !X3 will return 0