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)
You cannot reference a spreadsheet sheet in another chartbook.
You cannot reference a spreadsheet sheet in a differently named spreadsheet in the same chartbook.
You can only reference sheets in the same-named spreadsheet in the same chartbook.
The way to do what you want is to have all your charts in the same chartbook, and add a sheet that is not associated with a chart to be the master sheet.
To add a sheet that is not associated with a chart:
- Go to Spreadsheet >> Add Sheet
- Give it a unique name. Keep it short. Don't accept the default name of a Sheet#.
This sheet will be empty where you can create a master sheet that can reference any other sheet in the same-named spreadsheet, and vice versa.
Then follow what I said in the post you quoted.
Can you help answer these questions from other members on NexusFi?
Thanks for the notes; only issue is that the number of Chart windows would be in the hundreds, hence my pondering of having several Chartbooks, each within a separate instance of SC, to distribute the load.
I'll just keep going the programmatic route on this.
Noticing Sierra Chart docs saying the resetting bit at the end is done manually?
Is this a troubleshooting suggestion, or what?
Still working on this before throwing in the towel...question about the reset formula, can one of the "J"'s be used, or will that not work... presently trying in a long exit:
$J$5>0
as your page's "H5", thinking first it will be false, then true, which will enable locking the "H3" state once it goes true, then false again once trade ends, resetting.
Also a bit confusing is, in the SC doc, using in the H4 spot
"K3>0"
and your page having
"H4>1"
is it meant to be greater than 0 or 1?
I haven't downloaded the spreadsheet they offer as an example,yet.
Resetting can be done automatically, but how to do it can get convoluted quickly.
At the very least, you'll be doing lots of trial and error.
It's not something that I can give a quick answer to because there are so many caveats.
The K3 in SC's example corresponds to the H3 in my example. This is the returned reference formula that locks.
The E3 in SC's example corresponds to the H4 in my example. This is the trigger formula that initiates the lock.
The H3 in SC's example corresponds to the H5 in my example. This is the reset formula. This is the tricky one because it must transition twice for each cycle.
In SC's example, their H3 must be FALSE before the lock, go TRUE to reset, and go FALSE again for the next cycle.
In my example, my H5 must be TRUE before the lock, go FALSE to reset, and go TRUE again for the next cycle.
I would like to auto trade hours of 22:00 to 02:00 (10pm to 2am).
I have tried using
=AND(J8 = 0, OR(OR(FRACTIME(J41) < TIMEVALUE("22:00:00"), FRACTIME(J41) > TIMEVALUE("02:00:00")), AND(FRACTIME(J41) > TIMEVALUE("02:00:00"), FRACTIME(J41) < TIMEVALUE("22:00:00"))))
to allow trading between 10 pm to 2am and exclude trades between 2am and 10pm, however it does not appear to work.
I suspect crossing over midnight (i.e. a new day ) may add complexity.
Any help with a formula to allow trading between 10 pm and 2am, and exclude trades between 2am and 10pm would be appreciated.
Including J8=0 in your J28 disable formula allows you to exit after the latest time in the formula, while disallowing entries after the latest time. Therefore, you'll want the J29 flatten time to be later than the latest time in J28.
So if you want to flatten at 01:59:50, the latest time in J28 should be something like 01:59:00 instead of 02:00:00.
(But then you have to ask yourself if you want to take an entry 50 seconds before you flatten.)
Try this in J29:
=FRACTIME(J41)>TIMEVALUE("01:59:50")
BTW, you can use FRACTIME(J41) instead of J41-INT(J41), if you want. They both do the same thing.
Hi Tom,
Thanks for your previous help.
I would like to build upon the disabling (J28) to add loss and profit bounds.
If we assume I
- want to consider open daily P/l (j10) and closed daily (J45)
- Q3 formula is =(($j$45)<=-4)
- R3 formula is =(($j$45)>=12)…. i.e. I risk 4 to make 12
Then I have tried to expand upon your formula as below