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)
Sierra Chart Worksheet System For Trading/Alert Discussions
Until I get a new account set up with a new broker, all I can tell you is that I replayed it at a very slow speed and the buy limit order went out as expected, above where the low of the bar would soon be established, but mysteriously the fill was registered as below the low of the bar. Once I am up and running again, I will let you know about the J values. J71 was properly set to L and I will let you know what J22 is keyed to, in relation to BCDE values. And I will provide a screenshot. Thank you.
Can you help answer these questions from other members on NexusFi?
I have noticed that when backtesting, whether fast or slow, price improvement of limit orders (not achievable in real market conditions) is recorded by the SC backtesting system.
I have guessed that this is due to the tick data in the scid file.
Is this an artifact of my spreadsheet coding or SC's problem?
So I've been trying to set up a spreadsheet system with two charts, where chart 2 generates the signals and chart 1 places the trades, same 15 minute bars and RTH session times: 845 - 1515 CT. I used multiple study/price overlays, putting everything on one sheet.
The entry signals seem to be working. However, now I must generate a stoploss order based on a theoretical chart 2 entry price. Of course the spreadsheet keeps track of the fill price based on the chart 1 price, but I need to determine a stoploss order based on a chart 2 price at the time the chart 1 fill occurred. Not sure how to register the chart 2 price at the time of the chart 1 fill. Any ideas?
I assume the 15 min charts each use a different symbol.
You could use a blank cell H42 on Chart2's sheet with a formula like this:
=Sheet1!J42
Then use a Formula Column on Chart2's sheet with a formula like this to find the bar where that time occurred:
=AND($H$42>A3,$H$42<A2)
You will only be able to use the bar's timestamp, so if the entry occurred intrabar, that intrabar price will not be available.
If your entries are at close-of-bar, this shouldn't be a problem.
Yes, different symbols, and chart 2 prices are overlaid on sheet 1.
Intrabar prices are what I'm dealing with, so I guess there's no straightforward or possible way to lock in the value. We can lock in T/F values, but not numbers. In any event, thanks again for your reply and help.
For situations like this I use the Trade Management By Study study to move stops. It would reference a price in a Formula Column (a subgraph) that a formula returns. https://www.sierrachart.com/index.php?page=doc/AttachedOrders.html
Scroll down to 'Study Controlled Targets and Stops'.
Note: the TMS study moves targets/stops of Attached Orders on the Trade Window.
So you would need a formula that does this:
=IF(Filter=1,TrailStopPriceFormula,IF(Filter=-1,FixedStopPriceFormula,0))
Each stop formula returns the price of the Stop, and the TMS study moves the Stop to that price.
To keep the formula simple, I also use two instances of the TMS study, and two spreadsheet Formula Columns, one for Longs and one for Shorts.
You could also separate the trailing stop and fixed stop by using two more instances of the TMS study.
You could also use a combination of the TMS study for the trailing stop, and L3/N3 for the fixed stop.
If so, set 'Cancel All Working Orders On Exit (ln:24)' to Yes.
Hi to all,
A very nice thread. I am using spreadsheet formula to test some easy calculations and decisions.
Problem is that I can not get it to work. Basically I want to compare 2 different values - A and B.
If A is greater than B , then do this calculations
if B is greater than A, then to other calculation.
Have tried many options but I can not get it to work.
What I have done is this -
