Spread Data Logger

0
(0)
Nombre:
Spread Data Logger
Autor: supertrade (2011.01.31 09:37)
descargado: 2167
Descargar:
Spread Data Logger 1
Spread Logger Write.mq4 (2.7 Kb) Vista
Spread Data Logger 1 Spread Logger Read.mq4 (7.0 Kb) Vista
Are you getting the spread you've been quoted by your broker?

Ever wanted to verify spread data stats from another source or create your own data?


Descripción:

Spread Logger consists of two indicators:

Spread Logger Write - Creates a CSV file containing spread data as a function of time. This is done in real-time.

Spread Logger Read - Reads CSV file created, displays some stats, & draws collected data to chart. También, draws live spread data to chart.

 

Direcciones:

Save both files in terminal\experts\indicators carpeta

Spread Logger Write:

Attach Spread Logger Write to any chart. (Insertar > Indicadores > Costumbre > Spread Logger Write)

Name your file under the inputs tab or leave the default filename.

Leave the MT4 terminal running and chart open for the time desired, Spread Logger will collect data in real-time.

Nota: For most accurate data, attach Spread Logger Write to a 1-Minute chart.

Spread Data Logger 3

nota: All files created by Spread Logger Write are saved to the terminal\experts\files carpeta.

Spread Logger Read:

Open chart of currency pair for which you have logged data & attach Spread Logger Read to chart. If you used a custom file name, make sure you type the file name correctly.

nota: While you may attach Spread Logger Read to a chart of any timeframe, using a chart of the same timeframe for which you collected data will yield the best results visually.

 

Spread Logger Read will display some stats:

  • Time tested & number of bars tested
  • Mean spread
  • Modo & frequency of the mode as a percentage

Spread Data Logger 4

If the time interval for which data was collected is within the range of the portion of the chart currently being displayed, you will see the spread data you collected drawn to the chart. The live spread will also be displayed as of the time Spread Logger Read was attached to the chart.

Spread Data Logger 5

Please post your data and results.

Happy logging! 🙂

brewmanz:
This is a good idea. Sin embargo, should this program start to be widely used, brokers will catch on & give the FIRST quote of the minute a good spread, and make it worse for others.

I would suggest tracking Minimum, Máximo, Promedio & Std Dev for each minute. Whether Average & SD is by number or 'time active' is debatable

I agree. I wrote this program for personal use just to get some rough numbers so I didnt put much effort to getting very high accuracy or efficiency. Certainly, tik data would be the most reliable and impossible for brokers to skew. The main barrier to writing such a program for tik data is the massive data files that would be created. Im not a professional programmer, thus my algorithms for analyzing the data are probably relatively inefficient and resource-consuming (Ive done no research at all on which algorithms would be best for this application) and thus analysis is slowed down considerably with more data points. Por ejemplo, I left this indicator running almost the whole of last week which resulted in 6737 datapoints. When I loaded the data in Spread Logger Read, it took about 30 seconds to analyze the data..at first I thought it had crashed metatrader. Nonetheless the results were good! For those of you interested, the mean spread for Forex.com during last week (1/31/11 - 2/4/11) era 2.2 with the mode being 2. Imagine though, if I had tik data.. Id have at least 100,000 data points... posiblemente 5 minutes of computation assuming the computation-time relationship is linear.. in all practicality it will freeze the MT terminal if not crash it. I'll work on a tik data version nonetheless when I have some time.

06.02.2011 01:45 supertrade

This is a good idea. Sin embargo, should this program start to be widely used, brokers will catch on & give the FIRST quote of the minute a good spread, and make it worse for others.

I would suggest tracking Minimum, Máximo, Promedio & Std Dev for each minute. Whether Average & SD is by number or 'time active' is debatable

02.02.2011 02:56 brewmanz

supertrade:
sergery:
I am now confused by tick/spread write to CSV file.

Could you please explain what is the function of if(Volumen[0]==1) ?

 

This statement ensures that data is written only once per bar, for the very first tik of a new bar rather than for every tik. While this is less accurate than collecting spread data for each tik, my feeling is that the difference in accuracy is marginal when using the indicator on the 1-minute chart and it leads to a much smaller data file to read. When writing the indicator I decided spread data for each tik is an unnecessary degree of accuracy and that per minute is more than sufficient to get meaningful results. I am aware of the possibility of this line causing a bug when a bar opens with volume immediately >1 but in my testing this never seemed occur so I did not address it.

Thank you for your detailed explaination !

01.02.2011 08:49 sergery

151948:
I'm new to this! how do "attach" estos???

I've uploaded the .ex4 versions.

Just save these in the ...\experts\indicators carpeta & it should show up under Insertar > Indicadores > Costumbre

01.02.2011 07:44 supertrade

151948:
I'm new to this! how do "attach" estos???

"Attach" simply means to open them on a chart in MT4. Download the file, open it in MetaEditor, then click "Compile". This should create an .ex4 file which you can "attach" to a chart in MetaTrader. Go to Insert > Indicadores > Costumbre > ...you should see the indicator name in the drop-down menu.. you may have to scroll down some.

01.02.2011 07:40 supertrade

sergery:
I am now confused by tick/spread write to CSV file.

Could you please explain what is the function of if(Volumen[0]==1) ?

 

This statement ensures that data is written only once per bar, for the very first tik of a new bar rather than for every tik. While this is less accurate than collecting spread data for each tik, my feeling is that the difference in accuracy is marginal when using the indicator on the 1-minute chart and it leads to a much smaller data file to read. When writing the indicator I decided spread data for each tik is an unnecessary degree of accuracy and that per minute is more than sufficient to get meaningful results. I am aware of the possibility of this line causing a bug when a bar opens with volume immediately >1 but in my testing this never seemed occur so I did not address it.

01.02.2011 07:34 supertrade

I am now confused by tick/spread write to CSV file.

Could you please explain what is the function of if(Volumen[0]==1) ?

 

¿De cuánta utilidad te ha parecido este contenido?

¡Haz clic en una estrella para puntuarlo!

Promedio de puntuación 0 / 5. Recuento de votos: 0

Hasta ahora, ¡no hay votos!. Sé el primero en puntuar este contenido.

¡Siento que este contenido no te haya sido útil!

¡Déjame mejorar este contenido!

Diez centavos, ¿cómo puedo mejorar este contenido?



Autor: Equipo Wiki de Forex
Somos un equipo de comerciantes de Forex altamente experimentados [2000-2023] que se dedican a vivir la vida en nuestros propios términos. Nuestro principal objetivo es lograr la independencia financiera y la libertad., y hemos buscado la autoeducación y adquirido una amplia experiencia en el mercado Forex como nuestro medio para lograr un estilo de vida autosostenible..