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)
I would recommend one of the online training sites, Lynda.com is known for business application training, Pluralsight is good for development stuff. Here is the link to the excel stuff on Lynda, im self taught through work but have a lot of holes in stuff I haven't needed to learn, so I am currently going through their lessons as well:
Google for the free 7 day trial, it costs $25/mo for unlimited access to all their videos which I think is a pretty good deal. If you get into other languages look to Pluralsight, same type of deal, I like to watch a C# video on their app while having lunch etc.
Can you help answer these questions from other members on NexusFi?
Tom thanks for the help I got from you in the past. I have had great use of how to lock a cell true statement. I wonder is it possible to lock a value in a cell? Lets say I have the value 50 in a cell and want to lock this value until I release it? Any help would be kind. Regards Outlander
I don't know of a way to lock a value in a cell, only T/F.
The only way I know to do something like it is to use formulas in the K-Z-AX array that update on each bar, but this only works with values that are updated at each bar, which is why I have asked for more Trading: ........ studies.
I have manage to use the formula for catching H/L from the ZigZag. So I can get the High values as intended. But the problem is that I want to use the value at the bar in progress. Now it catches the value on bar close. Regards Outlander
Hi Tom,
Thanks for answering a question previously on the SC forum.
Posting here this time, as looking to fire off a few more, and most recent one was ignored there
I'm assuming this is a different forum, but also realize futures.io does integrate the SC forum,
So here goes
1.
I was thinking of creating small calculations in scattered cells and referencing them, instead of managing a long string in the entry/exit cells
Which subject was the last question sent to SC, maybe it fell under "we don’t debug formulas” category.
I had asked where best to put those, and they were suggesting at the bottom of I/J columns
Asked if using the H column was as good, as it seems to be working ok, and is more conveniently located.
2.
A general question.... are formulas a decent substitute for ASCIL?
One obstacle encountered was when signal is set to the end of the candle, and I don’t think an ss formula is able to unset that.
Just looking for a "my experience is" sort of answer, as you may not have tried ASCIL.
3.
How manageable are stops in formulas, for an example, can a stop be tightened if a moving average shifts direction.
4.
Along the same lines, could a target be changed, if criteria is met, from a value in formula, to instead use one of the (trend following) studies
5.
Two more questions unanswered but guessing the answer is no.
Functions used with StudyChart Alerts And Scanning cannot be used, correct?
such as
Referencing Data Other than Last Bar
Base Graph Identifiers
(tried links but was prohibited)
can these be used in spreadsheet system for trading?
1) Use Formula Columns to separate portions of your entry formulas, and then reference them in K3/M3 with AND or OR. This makes formula management and debugging much easier. Use non-repeating cells in column H for user parameters, and intermediate calculations that are not associated with chart bars.
Note: Formulas in non-repeating cells must reference row 3 for intrabar triggers and row 4 for close-of-bar triggers. The 'Signal Only On Bar Close' setting only affects Formula Columns.
2) I don't understand what you mean by 'unset', but spreadsheet formulas are capable of doing most things ACSIL can do.
3,4) Stops and targets can definitely be managed with spreadsheet formulas. If you are not using Attached Orders, they are not pending in the market. If you are using Attached Orders, they can be managed with spreadsheet formulas using the Trade Management by Study study. If you are scaling in or scaling out, the Trade Management by Study study will only move the stop/target closest to the current price, but there is a complicated solution to this.
The Trade Management by Study study can be used with any study's subgraph value, including a spreadsheet study.
5) Simple Alert syntax and spreadsheet formula syntax are not the same, but the format is the same. A few spreadsheet functions can be used in Simple Alert formulas, but Base Graph Identifiers cannot be used in spreadsheet formulas. Spreadsheet row 3 is the current bar, and rows below are previous bars. Simple Alerts use bracketed references to previous bars, e.g. [-1] for the previous bar. So it is possible with both to reference data in previous bars.
The best way to learn is to use trial and error. Don't be afraid to try anything. When you can't figure something out, go to the documentation, which is very good. When neither of these answers your questions, then post on this forum or Sierra's forum.
Thanks for the encouragement and guidance, Tom.
Interesting that Attached orders can be managed using the Trade Management by Study study, will look at that soon.
For #2, a setting such as 'Signal Only On Bar Close' looks to be read only.
Was working on an exit formula with 2 conditions where one was best end of bar, and the other would have been best intrabar.
I'm not sure that can be switched on the fly in an ss formula, but it may not be able to be switched in ASCIL either
Hi Tom,
I am looking different Moving Average slope angles using the simple formula
=IF(AG3-AG4>.0001,1,0)
and seeing differing results depending on the range bar value being used, which isn't unexpected.
Range bar values (or day/minute/second values) aren't obviously seen to be accessed from/on the spreadsheet (in order to make this more universal across time frames and ranges).
Do you know of any studies in Sierra Chart that do this, or can frames/ranges be accessed in a spreadsheet formula?
Jeff