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 have a spreadsheet strategy programmed and my chart populates with Up/Down arrows that mark the entry bars (column K & M.) Also marked on the entry bar is my programmed Entry/Exit levels (column L & N.) When I run a backtest I mostly I get an entry price that looks like a market entry at bar close or some price marked on the next bar.
In the Spreadsheet For Trading study settings I've tried numerous combinations with the "Bar Close" and "Order Type" settings and different Chart Trade settings but I can't get an entry or exit at my programmed price.
What I'm trying to accomplish is to only enter after price moves in the intended direction of the trade. I want to place a Stop-Limit Order for entry and a Market Order Stop for exit. For example, a Stop-Limit Buy order one (1) ES point above the entry (signal) bar and a Market Stop below the signal bar.
First I need to get the Stop-Limit entry working. The next feature I want is for when the Exit price is traded before the Entry price, in that case I'd like both the Entry and Exit orders to cancel without having entered a position.
Any help with this is greatly appreciated.
Can you help answer these questions from other members on NexusFi?
You can set Limit orders with the spreadsheet. I think "Market Stop below the signal bar" is called "Market if Touched".
For limit order entries: Use Cells J71 and J73 to set the order type to Limit, and J72 and J74 to MIT. Then set the price levels in J22 through J25 using a formulas that involve your signal.