Simple Trailing Stop calculation - EXCEL RELATED JOB

MQL4 Diğer

İş tamamlandı

Tamamlanma süresi: 35 gün
Müşteri tarafından geri bildirim
Completed the job and was easy to talk to regarding issues during the development stage. Will use again in future.

İş Gereklilikleri

Hello everybody, 

Just to clarify, this is a quick job in Excel I was hoping somebody here had the knowledge to help me with. I AM LOOKING FOR QUOTES IN TERMS OF HOW MUCH IT WOULD COST TO DO THIS AND HOW LONG IT WOULD TAKE.


I have a spreadsheet that I put together to do some simple backtesting. 

Basically it is in a similar format to that attached. Time periods going down the rows. Every time a trade is entered the Traded Price, Stop Loss and Take Profit are recorded.



The first column has the closing prices of every 1HR bar. 
The second column will have a value only if a trade has been entered (+ve if it is a buy, -ve if it is a sell).
The third column has the initial stop-loss simply calculated as the entry level +or- 1pt.
The fourth column has the take-profit value simply calculated as the entry level +or- 2pts.
As you can see a lot of trades in either direction can currently be opened at any one time.

I am trying to incorporate a trailing loss system whereby the stop is moved so that it is always at max 1pt worse than the current closing price.
So in the first example, where we bought at 81.981 with initial stop of 80.981. If the close in a few bars rises to 82.45 then I want to move the stop to 81.45.
Eventually we get to a point where the trailing stop would stop updating because of 1 of 2 things occurring. 
1) the take profit level gets hit. So in the above example the take profit was at 83.981. The last trailing stop would be around 1pt away from here then (depending on where the close was).
2) the price moves against and the trailing stop gets triggered.

I currently know how to calculate the number of rows away that the take-profit gets triggered since it is a static number I am searching for.
However I am having difficulty doing the same for the trailing stop since this number is supposed to be updated with the new closing prices (depending on if it is moving in our favor).
In the final column where I left "?" I am trying to determine where the trailing stop will end up getting triggered. Ideally, trying to figure out how many rows away from the trade entry it is.
Is there a way to use excel formulas in the cell to try and achieve this (by index() or match() or something like that) or will a macro have to be created for this purpose?

How much would you charge to help solve my conundrum and how long would it take?

 Thanks. 

Yanıtlandı

1
Geliştirici 1
Derecelendirme
(272)
Projeler
394
63%
Arabuluculuk
70
53% / 26%
Süresi dolmuş
198
50%
Serbest
Benzer siparişler
I have an equity reporter. This equity reporter displays the maximum and minimum equity reached over a specific interval. So, if the interval is set to 24 hours, the script will generate data in the format: "Profit ATT" (profit AtThatTime) shows max./min. during the specific interval This specific report shows data in pips. It can also be set to display in price or percentages. The interval is also easily adjustable
Hey, great developer I have a thinkorswim script I want to convert it into TradingView. Can you please let me know if you can i will be looking for great developer that will bid for it best regards
Hey, great developer I have a thinkorswim script I want to convert it into TradingView. Can you please let me know if you can i will be looking for great developer that will bid for it best regards
Tradingview developer 30 - 35 USD
Hey greetings. I am in need of tradingview developer that can modify an open source PineScript indicator code to add additional features. Kindly bid for this project if it is what you handle and let proceed with the project
In summary 1) The bot will only take Firm Buy and Firm Sell Signals . 2) The bot will use the SL and TP based on the indicator . 3) the risk to reward is 2:1 but when the price reaches 1:1 set SL to Breakeven 4) the bot will take Firm Buy and Firm sell after the candle closes with a firm buy or firm sell 5) make sure to give an option for number of contracts to be traded . 6) Bot will close all the trades EOD
Hello, I'd like to get a developer for converting tradingview indicator script to NT8 indicator. I have attached rough c# code and working pine script. indicator is nothing but just 7 horizontal lines drawn with 3 types of colors, 3 lines for support level, 3 lines for resistance level and 1 mid line. Purpose of the indicator is to draw colored horizontal lines with labels when a text is pasted with predefined
The Bot will use 2 Indicators and should follow these rules: Trade Entry: You must always enter the trade EXACTLY at the close of the current candle, with the expiry time set to the end of the next candle. It will only work if you click BUY or SELL EXACTLY in the last second of the current candle. I don't need to mention that you need a good internet connection and obviously should use the trading platform app. DO
I have choch indicator I want to use it for my strategy but the ea will have two options the second option will base on manual example I will do my analysis of a pair then decide if buy or sell before putting those pairs in the ea base on the direction I choose for it but first option will make use of the indicator. Will explain better on video screen pls check my attachments below for better communication
Hi, I need someone who have an idea of IG Market I am running into a problem I need to have at least 50pips between my order and stoploss. Can you check with me where it goes wrong
I need an expert to convert a TradeStation script over to pine please let me know if this is something you can do perfectly. I will be expecting your message. thanks

Proje bilgisi

Bütçe
50- USD
Son teslim tarihi
to 10 gün