Custom indicator to be updated every 24 hours and export data in real time to excel sheet cells

MQL4 Indicators

Job finished

Execution time 5 days
Feedback from employee
Great client!
Feedback from customer
The programmer did an excellent job. The indicator was perfect.

Specification

Hi, I need a technical indicator that updates every 24 hours and is guided by the candlestick close of 00:00 metatrader 4 time every day.

This indicator will work for timeframe of 1 hour or less and should show only seven price levels of the last 48 hours in chronological order.

Example:

Today is 30-03-2022 and the first candle of the day which is the 00:00 hour EURUSD closed, when this happens the following prices will be displayed in chronological order:

*Candle closing price 00:00 on 28-03-2022

*Maximum price of the day 28-03-2022 including wick, this one is not worked at the closing.
*Minimum price of the day 28-03-2022 including wick, this is not worked at the close.

(for this day's high and low price will be displayed in chronological order, according to the one that occurred first)

*Candlestick closing price 00:00 of 29-03-2022

(for this day's high and low price will be displayed in chronological order, whichever occurred first)

*Maximum price of the day 29-03-2022 including wick, it is not worked at the close.
*Minimum price of the day 29-03-2022 including wick, it is not worked at the close.

(for this day's high and low price will be displayed in chronological order, according to the one that occurred first)

*Candle closing price 00:00 of 30-03-2022.


These would be the seven data to show according to this example and then when the closing price of the opening of the day 31-03-2022 is reached, the indicator updates the data shown in real time and repeats the cycle again of the last 48 hours giving way to the following example:

Today is 31-03-2022 and the first candle of the day which is at hour 00:00 of the EURUSD closed again, when this happens the following prices will be shown in chronological order since at this point the indicator updates all the data again showing again:

*Closing candle price 00:00 of 29-03-2022

*Maximum price of the day 29-03-2022 including wick, this one is not worked at the close.
*Minimum price of the day 29-03-2022 including wick, this is not worked at the close.

(for this day's high and low price will be displayed in chronological order, according to the one that occurred first)

*candlestick closing price 00:00 on 30-03-2022

(for this day's high and low price will be displayed in chronological order, whichever occurred first)

*Maximum price of the day 30-03-2022 including wick, it is not worked at the close.
*Minimum price of the day 30-03-2022 including wick, it is not worked at the close.

(for this day's high and low price will be displayed in chronological order, according to the one that has occurred first)

*Candle closing price 00:00 of 31-03-2022.


This example explains very well what would be the proper functioning of the indicator, it should be compatible with the markets 24/5 from Monday to Friday and not present problems on Mondays that opens the weekly trading session, since the data to be displayed for this day would be the prices of Thursday and Friday of last week. And for the 24/7 cryptocurrency markets it should not present any chronological problems either.

The logic of this indicator is super simple as is the data update interval, although the explanation was long it is for you as a developer to understand what will be the operation.

And the seven data shown in chronological order must be able to be passed in real time to cells of an excel sheet, where the main coordinate in the sheet will start with the respective currency pair, for example, would be 
Cell coordinates of the asset: EURUSD

Cell where the data 1 will be placed in chronological order.
Cell where data 2 will be placed in chronological order.
Cell where data 3 will be placed in chronological order.
Cell where data 4 will be placed in chronological order.
Cell where data 5 will be placed in chronological order.
Cell where data 6 will be placed in chronological order.
Cell where data 7 will be placed in chronological order.

If for example in the asset coordinates cell is changed to GBPUSD the price data should automatically change in all seven cells. Since the indicator will be active in several charts at the same time and excel will control which ones to show in the sheet according to the asset that is placed in the respective cell.

PLEASE DO NOT SEND REQUESTS FOR THIS WORK FOR A HIGHER PRICE THAN INDICATED, AS IT IS NOT NEGOTIABLE. 30 USD FOR THIS INDICATOR...


Responded

1
Developer 1
Rating
(12)
Projects
25
24%
Arbitration
2
50% / 50%
Overdue
2
8%
Free
Similar orders
Indicador Maximas e Minimas + Super Trend O Indicador MAX/MIN é um indicador de análise técnica para o MetaTrader 5 , desenvolvido para ajudar você a identificar regiões importantes de preço e possíveis oportunidades de compra e venda. O que ele faz MAX/MIN: identifica máximas e mínimas relevantes do mercado e mostra os preços no gráfico. HH / HL / LH / LL: ajuda a visualizar a estrutura do mercado, mostrando quando
Hello Traders, Have a trading strategy or idea you want to automate? I specialize exclusively in MQL5 development, helping traders turn their concepts into professional trading solutions. Custom Expert Advisors — automate your strategy and reduce manual execution Custom Indicators — transform your market ideas into powerful trading tools Fix & Debug — identify errors and get your existing code working properly
I DO NOT need any programming or strategy development. I already have a working NinjaTrader 8 automated strategy based on a 3/5 EMA crossover. I need you to run my existing strategy through NinjaTrader Strategy Analyzer/Optimizer, test the existing adjustable parameters, and find robust settings with the best profit factor and lowest reasonable drawdown. I will provide the existing NinjaScript ZIP. I do not want the
I'm looking for an experienced developer to create an automated gold trading bot. The bot should be compatible with MetaTrader 4/5 and TradingView. Key Requirements: - Automated trading bot - Compatible with MetaTrader 4/5 and TradingView - Implement scalping and swing trading strategies Ideal Skills and Experience: - Proficiency in trading algorithms - Experience with gold trading - Familiarity with MetaTrader and
I need a robust optimization of my MT5 EA, mainly for XAUUSD (Gold). Please optimize the existing adjustable parameters such as entry/exit settings, SL/TP, trailing/break-even settings, and any other strategy parameters that are appropriate. I want the optimization focused on stable profitability, low/moderate drawdown, and robustness rather than simply the highest possible profit. Please use out-of-sample testing
NinjaTrader 8 / NinjaScript Phase 1 build: convert an existing Auction Market Theory (AMT) strategy into objective, alert-only decision-support logic. Not a bot, no auto-execution — trades stay manual. Covers NQ/MNQ, ES, CL, MGC using 30-min TPO/Volume Profile context with 5-min confirmation: one 5-min close outside VAH/VAL = acceptance, close back inside = rejection. Dashboard shows bias, auction state, location
Hello, I need a custom NON-REPAINT MT5 indicator that gives sell/buy arrow signals 1–2 candlesticks before a spike on Crash and boom indices respectively occurs. Requirements: Works perfectly on MT5 Shows arrows before the spike (1–2 candles earlier). Non-repaint – once the arrow appears, it must stay. Should be accurate, not quantity — only quality signals. Must work on both demo and live accounts. I want the
Hello, I saw an indicator on TradingView and would like to know if you will be able to convert it for use on Thinkorswim platform? Thanks. if anyone can help me with it kindly do well to bid it urgent thanks looking forward too see you
calcVolume( void ) { //--- MqlRates rates[]; if ( CopyRates ( _Symbol , PERIOD_CURRENT , startTime, endTime, rates) > 0 ) { double rangeHigh = rates[ 0 ].high, rangeLow = rates[ 0 ].low; int count = MathAbs ( iBarShift ( _Symbol , PERIOD_CURRENT , startTime) - iBarShift ( _Symbol , PERIOD_CURRENT , endTime)) + 1 ; //---VERTICAL PRICE RANGE for ( int b = 0
Create an MT5 Expert Advisor (EA) for trading Gold (XAUUSD). The EA should provide BUY and SELL signals based on trend direction, market momentum, and price action. It should automatically place trades only when the entry conditions are met. Risk management: Use a small adjustable lot size. Include Stop Loss (SL) and Take Profit (TP). Include a maximum daily loss limit. Include a maximum number of open trades. Do not

Project information

Budget
30+ USD