The script is very nice, but I would like more if the data could go to excel directly, via a RTD server, to use excel's RDTR function. Do you have something like that planned?
Jose Luis Perez Navarro: The script is very good, but I would like more if the data could go to excel directly, through a RTD server, to use excel's RDTR function. Do you have something like that in mind?
Thank you for the job. Unfortunately, when I run the script, no file is created. I updated the script to write in C:/temp/. When i run in debug I can see that the filename is correct and I don't get any error but there is no file.
Any clue ?
If you check the handle, it will probably is returning -1. (invalid handle)
Print ( "fileHandle Value=", fileHandle);
For some reason MT5 doesnt´like that you save files in different places from default. Just let as original code and it will write in ...MQL5\Files path
Congratulations on the script, I am exporting the values of the volatilitypivot flag to csv, but the script only correctly exports the high values, in the lines that should appear the low values an error appears.
Can someone help me please ?
VolatilityPivot script
#property indicator_chart_window//--- 4 buffers are used for calculation and drawing the indicator#property indicator_buffers4//--- 4 plots are used#property indicator_plots4//+----------------------------------------------+//| Bullish indicator drawing parameters |//+----------------------------------------------+//--- drawing indicator 1 as a line#property indicator_type1DRAW_LINE//--- blue color is used for the indicator line#property indicator_color1clrBlue//--- the indicator 1 line is a dot-dash one#property indicator_style1STYLE_DASHDOTDOT//--- indicator 1 line width is equal to 2#property indicator_width12//---- displaying of the the indicator label#property indicator_label1"Upper VolatilityPivot"//+----------------------------------------------+//| Parameters of drawing a bearish indicator |//+----------------------------------------------+//--- drawing indicator 2 as a line#property indicator_type2DRAW_LINE//--- HotPink color is used for the indicator line#property indicator_color2clrHotPink//--- the indicator 2 line is a dot-dash one#property indicator_style2STYLE_DASHDOTDOT//--- indicator 2 line width is equal to 2#property indicator_width22//---- displaying of the the indicator label#property indicator_label2"Lower VolatilityPivot"//+----------------------------------------------+//| Bullish indicator drawing parameters |//+----------------------------------------------+//--- drawing the indicator 3 as a label#property indicator_type3DRAW_ARROW//--- DeepSkyBlue color is used for the indicator#property indicator_color3clrDeepSkyBlue//--- indicator 3 width is equal to 4#property indicator_width34//--- displaying the indicator label#property indicator_label3"Buy VolatilityPivot"//+----------------------------------------------+//| Parameters of drawing a bearish indicator |//+----------------------------------------------+//--- drawing the indicator 4 as a label#property indicator_type4DRAW_ARROW//--- red color is used for the indicator#property indicator_color4clrRed//--- indicator 4 width is equal to 4#property indicator_width44//--- displaying the indicator label#property indicator_label4"Sell VolatilityPivot"//+----------------------------------------------+//| declaration of constants |//+----------------------------------------------+#define RESET 0// A constant for returning the indicator recalculation command to the terminal//+----------------------------------------------+//| Declaration of enumeration |//+----------------------------------------------+enum Mode_
{
Mode_ATR=0, //ATR
Mode_Price //Price deviation
};
//+----------------------------------------------+//| Indicator input parameters |//+----------------------------------------------+inputuint atr_range=100;
inputuint ima_range=10;
inputdouble atr_factor=3;
input Mode_ Mode=Mode_ATR;
inputuint DeltaPrice=200;
inputint Shift=0; // Horizontal shift of the indicator in bars//+----------------------------------------------+//--- declaration of dynamic arrays that//--- will be used as indicator buffersdouble ExtMapBufferUp[];
double ExtMapBufferDown[];
double ExtMapBufferUp1[];
double ExtMapBufferDown1[];
//---double dDeltaPrice;
//--- declaration of integer variables for the indicators handlesint ATR_Handle;
//--- declaration of integer variables for the start of data calculationint min_rates_total;
//+------------------------------------------------------------------+//| CMoving_Average class description |//+------------------------------------------------------------------+#include <SmoothAlgorithms.mqh>
//+------------------------------------------------------------------+//| Custom indicator initialization function |//+------------------------------------------------------------------+ intOnInit()
{
//--- Getting the handle of the ATR indicatorif(Mode==Mode_ATR)
{
min_rates_total=int(atr_range+ima_range)+1;
ATR_Handle=iATR(NULL,0,atr_range);
if(ATR_Handle==INVALID_HANDLE)
{
Print(" Failed to get handle of the ATR indicator");
return(INIT_FAILED);
}
}
else
{
min_rates_total=3;
dDeltaPrice=DeltaPrice*_Point;
}
//--- set ExtMapBufferUp[] dynamic array as an indicator bufferSetIndexBuffer(0,ExtMapBufferUp,INDICATOR_DATA);
//---- shifting the indicator 1 horizontally by ShiftPlotIndexSetInteger(0,PLOT_SHIFT,Shift);
//--- shifting the start of drawing the indicator 1PlotIndexSetInteger(0,PLOT_DRAW_BEGIN,min_rates_total);
//--- indexing buffer elements as timeseries ArraySetAsSeries(ExtMapBufferUp,true);
//--- setting the indicator values that won't be visible on a chartPlotIndexSetDouble(0,PLOT_EMPTY_VALUE,EMPTY_VALUE);
//--- set ExtMapBufferDown[] dynamic array as an indicator bufferSetIndexBuffer(1,ExtMapBufferDown,INDICATOR_DATA);
//---- shifting the indicator 2 horizontally by ShiftPlotIndexSetInteger(1,PLOT_SHIFT,Shift);
//--- shifting the starting point of calculation of drawing of the indicator 2PlotIndexSetInteger(1,PLOT_DRAW_BEGIN,min_rates_total);
//--- indexing buffer elements as timeseries ArraySetAsSeries(ExtMapBufferDown,true);
//--- setting the indicator values that won't be visible on a chartPlotIndexSetDouble(1,PLOT_EMPTY_VALUE,EMPTY_VALUE);
//--- Set the ExtMapBufferUp1[] dynamic array as an indicator bufferSetIndexBuffer(2,ExtMapBufferUp1,INDICATOR_DATA);
//---- shifting the indicator 1 horizontally by ShiftPlotIndexSetInteger(2,PLOT_SHIFT,Shift);
//--- shifting the start of drawing of the indicator 3PlotIndexSetInteger(2,PLOT_DRAW_BEGIN,min_rates_total);
//--- indexing buffer elements as timeseries ArraySetAsSeries(ExtMapBufferUp1,true);
//--- setting the indicator values that won't be visible on a chartPlotIndexSetDouble(2,PLOT_EMPTY_VALUE,EMPTY_VALUE);
//--- indicator symbolPlotIndexSetInteger(2,PLOT_ARROW,118);
//--- Set the ExtMapBufferDown1[] dynamic array as an indicator bufferSetIndexBuffer(3,ExtMapBufferDown1,INDICATOR_DATA);
//---- shifting the indicator 2 horizontally by ShiftPlotIndexSetInteger(3,PLOT_SHIFT,Shift);
//--- shifting the start of drawing of the indicator 4PlotIndexSetInteger(3,PLOT_DRAW_BEGIN,min_rates_total);
//--- indexing buffer elements as timeseries ArraySetAsSeries(ExtMapBufferDown1,true);
//--- setting the indicator values that won't be visible on a chartPlotIndexSetDouble(3,PLOT_EMPTY_VALUE,EMPTY_VALUE);
//--- indicator symbolPlotIndexSetInteger(3,PLOT_ARROW,118);
//--- creation of the name to be displayed in a separate sub-window and in a pop up helpIndicatorSetString(INDICATOR_SHORTNAME,"VolatilityPivot");
//--- determining the accuracy of the indicator valuesIndicatorSetInteger(INDICATOR_DIGITS,_Digits);
//--- initialization endreturn(INIT_SUCCEEDED);
}
//+------------------------------------------------------------------+//| Custom indicator iteration function |//+------------------------------------------------------------------+intOnCalculate(constint rates_total, // number of bars in history at the current tickconstint prev_calculated,// amount of history in bars at the previous tickconstdatetime &time[],
constdouble &open[],
constdouble& high[], // price array of price maximums for the indicator calculationconstdouble& low[], // price array of minimums of price for the indicator calculationconstdouble &close[],
constlong &tick_volume[],
constlong &volume[],
constint &spread[])
{
//--- checking if the number of bars is enough for the calculationif((BarsCalculated(ATR_Handle)<rates_total && Mode==Mode_ATR) || rates_total<min_rates_total) return(RESET);
//--- declarations of local variables double DeltaStop,Stop;
staticdouble PrevStop;
int limit,bar;
//--- indexing elements in arrays as in timeseries ArraySetAsSeries(close,true);
//--- calculation of the 'limit' starting index for the bars recalculation loopif(prev_calculated>rates_total || prev_calculated<=0) // checking for the first start of calculation of an indicator
{
limit=rates_total-min_rates_total-1; // starting index for calculation of all bars
PrevStop=close[limit+1];
}
else limit=rates_total-prev_calculated; // starting index for calculation of new bars//---if(Mode==Mode_Price)
{
//--- main indicator calculation loopfor(bar=limit; bar>=0; bar--)
{
ExtMapBufferUp1[bar]=EMPTY_VALUE;
ExtMapBufferDown1[bar]=EMPTY_VALUE;
DeltaStop=dDeltaPrice;
//---if(close[bar]==PrevStop) Stop=PrevStop;
else
{
if(close[bar+1]<PrevStop && close[bar]<PrevStop) Stop=MathMin(PrevStop,close[bar]+DeltaStop);
else
{
if(close[bar+1]>PrevStop && close[bar]>PrevStop) Stop=MathMax(PrevStop,close[bar]-DeltaStop);
else
{
if(close[bar]>PrevStop) Stop=close[bar]-DeltaStop;
else Stop=close[bar]+DeltaStop;
}
}
}
//---if(close[bar]>Stop) ExtMapBufferUp[bar]=Stop; else ExtMapBufferUp[bar]=EMPTY_VALUE;
if(close[bar]<Stop) ExtMapBufferDown[bar]=Stop; else ExtMapBufferDown[bar]=EMPTY_VALUE;
if(ExtMapBufferUp[bar+1]==EMPTY_VALUE && ExtMapBufferUp[bar]!=EMPTY_VALUE) ExtMapBufferUp1[bar]=ExtMapBufferUp[bar];
if(ExtMapBufferDown[bar+1]==EMPTY_VALUE && ExtMapBufferDown[bar]!=EMPTY_VALUE) ExtMapBufferDown1[bar]=ExtMapBufferDown[bar];
if(bar) PrevStop=Stop;
}
}
//---if(Mode==Mode_ATR)
{
//--- declarations of local variables double ATR[];
int to_copy,maxbar;
//--- declaration of the CMoving_Average class variables from the SmoothAlgorithms.mqh file static CMoving_Average EMA;
//--- indexing elements in arrays as in timeseries ArraySetAsSeries(ATR,true);
to_copy=limit+1;
if(CopyBuffer(ATR_Handle,0,0,to_copy,ATR)<=0) return(RESET);
maxbar=rates_total-min_rates_total-1;
//--- main indicator calculation loopfor(bar=limit; bar>=0; bar--)
{
ExtMapBufferUp1[bar]=EMPTY_VALUE;
ExtMapBufferDown1[bar]=EMPTY_VALUE;
DeltaStop=atr_factor*EMA.EMASeries(maxbar,prev_calculated,rates_total,ima_range,ATR[bar],bar,true);
//---if(close[bar]==PrevStop) Stop=PrevStop;
else
{
if(close[bar+1]<PrevStop && close[bar]<PrevStop) Stop=MathMin(PrevStop,close[bar]+DeltaStop);
else
{
if(close[bar+1]>PrevStop && close[bar]>PrevStop) Stop=MathMax(PrevStop,close[bar]-DeltaStop);
else
{
if(close[bar]>PrevStop) Stop=close[bar]-DeltaStop;
else Stop=close[bar]+DeltaStop;
}
}
}
//---if(close[bar]>Stop) ExtMapBufferUp[bar]=Stop; else ExtMapBufferUp[bar]=EMPTY_VALUE;
if(close[bar]<Stop) ExtMapBufferDown[bar]=Stop; else ExtMapBufferDown[bar]=EMPTY_VALUE;
//---if(ExtMapBufferUp[bar+1]==EMPTY_VALUE && ExtMapBufferUp[bar]!=EMPTY_VALUE) ExtMapBufferUp1[bar]=ExtMapBufferUp[bar];
if(ExtMapBufferDown[bar+1]==EMPTY_VALUE && ExtMapBufferDown[bar]!=EMPTY_VALUE) ExtMapBufferDown1[bar]=ExtMapBufferDown[bar];
//---if(bar) PrevStop=Stop;
}
}
//--- return(rates_total);
}
Allow the use of cookies to log in to the MQL5.com website.
Please enable the necessary setting in your browser, otherwise you will not be able to log in.
You are signed in. Two-factor authentication has been disabled. Set it up again and scan a new QR code, or continue with two-factor authentication disabled.
Search for the file in the folder
C:\Users\XXX\AppData\Roaming\MetaQuotes\Terminal\ZXVVDASDADDEDADS23132\MQL5\Files
Exporting Indicator Values:
Author: NFTrader
Exporting Indicator Values:
Author: NFTrader
The script is very good, but I would like more if the data could go to excel directly, through a RTD server, to use excel's RDTR function. Do you have something like that in mind?
Yes it works. You need to look at ...MQL5\Files path, its there the CSV file.
I´ve modified to save values of OBV (real volume) just change the code below
Hi,
Thank you for the job. Unfortunately, when I run the script, no file is created. I updated the script to write in C:/temp/. When i run in debug I can see that the filename is correct and I don't get any error but there is no file.
Any clue ?
If you check the handle, it will probably is returning -1. (invalid handle)
For some reason MT5 doesnt´like that you save files in different places from default. Just let as original code and it will write in ...MQL5\Files path
Congratulations on the script, I am exporting the values of the volatilitypivot flag to csv, but the script only correctly exports the high values, in the lines that should appear the low values an error appears.
Can someone help me please ?
VolatilityPivot script
This one is very useful.
The author is bull.