Spread Data Logger

0
(0)
姓名:
Spread Data Logger
作者: supertrade (2011.01.31 09:37)
已下載: 2167
下載:
Spread Data Logger 1
Spread Logger Write.mq4 (2.7 KB) 看法
Spread Data Logger 1 Spread Logger Read.mq4 (7.0 KB) 看法
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?


描述:

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. 還, draws live spread data to chart.

 

Directions:

Save both files in terminal\experts\indicators 文件夾

Spread Logger Write:

Attach Spread Logger Write to any chart. (Insert > 指標 > 風俗 > 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.

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

Spread Data Logger 3

筆記: All files created by Spread Logger Write are saved to the terminal\experts\files 文件夾.

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.

筆記: 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
  • 模式 & 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. 然而, 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, 最大限度, 平均的 & 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. 例如, 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) 曾是 2.2 with the mode being 2. Imagine though, if I had tik data.. Id have at least 100,000 data points... 可能 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. 然而, 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, 最大限度, 平均的 & 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(體積[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" 這些???

I've uploaded the .ex4 versions.

Just save these in the ...\experts\indicators 文件夾 & it should show up under Insert > 指標 > 風俗

01.02.2011 07:44 supertrade

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

"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 > 指標 > 風俗 > ...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(體積[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(體積[0]==1) ?

 

這篇文章有多有用?

點擊一顆星即可對其進行評分!

平均評分 0 / 5. 計票數: 0

目前還沒有投票! 成為第一個評價這篇文章的人.

很抱歉這篇文章對您沒有用!

讓我們改進這篇文章!

告訴我們如何改進這篇文章?



作者: 外匯維基團隊
我們是一支經驗豐富的外匯交易員團隊 [2000-2023] 致力於以我們自己的方式生活的人. 我們的主要目標是實現財務獨立和自由, 我們追求自我教育並在外匯市場上獲得豐富的經驗,以此作為實現自我可持續生活方式的手段.