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)
Hi Tom, sorry to bother you again on this. I thought I had everything working but when testing further I think I'm still mis-understanding how the Spreadsheet System works and I haven't been able to find anything in the documentation that clarifies.
In my Sheet2 (re-named to EntryCriteria) tab I want to eventually have a list of 1000 separate date/time combinations for the backtest to run on. The formula I currently have in K3 for my Buy Entry references this list. When I run my backtest it's only executing on the first two date/times in my EntryCriteria list.
Does the Study not iterate through the lines? For example, looks at K3, executes, moves to K4, executes, moves to K5, executes... to K1002? Or would doing what I'm trying to do require me to have an OR formula in K3 that references each of the 1000 lines within my EntryCriteria tab (ie. =OR($J$41=EntryCriteria!$A$1,$J$41=EntryCriteria!$A$2,$J$41=EntryCriteria!$A$3,...$J$41=EntryCriteria!$A$1000)?
To make the study iterate thru each row on the EntryCriteria sheet, try this:
Use column H on Sheet1:
- In cell H1: =AND(J41>=EntryCriteria!A1,J41<EntryCriteria!A1+5/86400)
- In cell H2: =AND(J41>=EntryCriteria!A2,J41<EntryCriteria!A2+5/86400)
-repeat for each row in column A on the EntryCriteria sheet.
On Sheet1 cell K3:
=OR($H$1,$H$2,$H$3,$H$4,...[repeat for each row in column H] )
Note: I did not test this so I'm not sure how efficient this will be, or if it will cause some lag, especially with 1000 rows.
Makes sense now why it wasn't working for me, thank you for the clarification.
I was hoping to expand this to have unique stops/targets attached to the individual buy/sell orders based on volatility conditions that I've calculated so I don't think this is going to work for me.
Thanks again for all your help with this Tom, I really appreciate it and your insight has saved me hours of bungling around. I'll have to see if there's another software solution out there for what I'm trying to do.
Another time related question, Tom
I was using the actual FRACTIME second value, after division, for formulas, like the previous post, and it was working until recently (and still on version 2150)
...you know .000012
Here what was working;
=FRACTIME($J$41)<(FRACTIME(AW3)+(($J$36/2)*.000012))
It would be true until half-way through bar.
And, just confirming, L,N-Z Signal on bar close is No in the speadsheet study.
Those were terms used unsuccessfully for a formula that was true until half-way through bar.
Using $J$36/2 would probably be the only thing kept in a solution you may suggest.
sorry for the confusion, Tom
It was the AW3, it works if corrected to A3.
Hadn't noticed it became transposed when moved from another spreadsheet.
Thanks for the added perspective, Tom, you are welcome to simplify if there is another solution.
Using sum e.g
= SUM( AB3:AB10 )
an entry candidate is being "kept alive" for 7 bars.
Is there something you have to suggest to substitute for the 10 in that formula (like a variable),
so then a value in the H column can increase or decrease that number of bars