Exporting news calendar from myfxbook as ASCII
Jul 21, 2011 at 19:03
4,171 Tampilan
10 Balasan
Menjadi Anggota Sejak Jul 20, 2011
31 postingan
Jul 21, 2011 at 19:03
I'm trying to feed my EA news information so it knows when to avoid entering the market. I've coded some subroutines to do that, and I'm using them in combination with a .csv file. Myfxbook seems to be an excellent source of news, and it allows you to filter by high and medium impact, and even displays time based on the broker time you select. I can use this to write a new input file every weekend, but this is rather tedious and error-prone. Is there a way to automatically export this data from myfxbook?
It'd be even easier if it was in this format, too:
2011.07.21 14:00;EUR EcoFin Meeting
2011.07.21 17:00;USD Bernanke Testifies
2011.07.22 04:30;AUD Import Price Index
It'd be even easier if it was in this format, too:
2011.07.21 14:00;EUR EcoFin Meeting
2011.07.21 17:00;USD Bernanke Testifies
2011.07.22 04:30;AUD Import Price Index
forex_trader_28881
Menjadi Anggota Sejak Feb 07, 2011
691 postingan
Jul 22, 2011 at 11:03
(diedit Jul 22, 2011 at 11:05 yang lalu)
There is an fxbook API...so I guess most things would be possible...
Ok, maybe not - I looked, didn't see anything pertaining to it, perhaps they can include it in the API.
Ok, maybe not - I looked, didn't see anything pertaining to it, perhaps they can include it in the API.
Menjadi Anggota Sejak Jul 20, 2011
31 postingan
Jul 22, 2011 at 21:27
It's ok, I found another site that makes the news exportable via csv file at logical URLs. I just coded some VBA excel macros to import the data for the week as a web query, perform the formatting I need, and store it as a .csv in the various locations I need to run my multiple terminal windows.
I know this is a quick and dirty solution, and not the most elegant, but it works and I got it all automated with single click.
I know this is a quick and dirty solution, and not the most elegant, but it works and I got it all automated with single click.
forex_trader_33781
Menjadi Anggota Sejak Apr 11, 2011
200 postingan
Jul 23, 2011 at 06:16
If you want a more direct link, the data actually comes from Fxstreet.com
https://www.fxstreet.com/fundamental/economic-calendar/
https://www.fxstreet.com/fundamental/economic-calendar/
Menjadi Anggota Sejak Jul 20, 2011
31 postingan
Jul 24, 2011 at 01:28
Menjadi Anggota Sejak Jan 14, 2010
541 postingan
Jul 25, 2011 at 16:25
gatornuke posted:
I'm trying to feed my EA news information so it knows when to avoid entering the market. I've coded some subroutines to do that, and I'm using them in combination with a .csv file. Myfxbook seems to be an excellent source of news, and it allows you to filter by high and medium impact, and even displays time based on the broker time you select. I can use this to write a new input file every weekend, but this is rather tedious and error-prone. Is there a way to automatically export this data from myfxbook?
It'd be even easier if it was in this format, too:
2011.07.21 14:00;EUR EcoFin Meeting
2011.07.21 17:00;USD Bernanke Testifies
2011.07.22 04:30;AUD Import Price Index
Very interesting. How do you decide what's an "important" news? Based on the impact devised?
Menjadi Anggota Sejak Jul 20, 2011
31 postingan
Jul 25, 2011 at 20:35
I'm using dailyFX's classification... anything "medium" or "high" importance according to them is "important" to the EA.
Menjadi Anggota Sejak Jan 14, 2010
541 postingan
Jul 26, 2011 at 06:29
gatornuke posted:
I'm using dailyFX's classification... anything "medium" or "high" importance according to them is "important" to the EA.
And what happens when you're trading these events? Does you system fail? Maybe you should adjust your system for these specific periods, so you would run different versions of your system per different market scenarios.
Menjadi Anggota Sejak Jul 20, 2011
31 postingan
Jul 26, 2011 at 13:15
I'm not trading these events. This is for a news avoidance subroutine. In other words, the EA is prevented from making any trades before or after these events.
Menjadi Anggota Sejak Jan 14, 2010
541 postingan
Jul 26, 2011 at 18:05
(diedit Jul 26, 2011 at 18:05 yang lalu)
Got it.
Did you automate the download process of the csv also? Or are you manually downloading the files each day/week?
Did you automate the download process of the csv also? Or are you manually downloading the files each day/week?
Menjadi Anggota Sejak Jul 20, 2011
31 postingan
Jul 26, 2011 at 18:56
It's semi-automatic. I wrote some VBA macros in excel to download the files from the site, format it appropriately, and export as a .csv copy in the file directory for each EA. Right now I'm running everything from a couple of ActiveX control buttons, one to fetch the data, and one to "publish" it once I vet it. At some point I may just make the whole process a scheduled task so it's full-auto.
*Penggunaan komersial dan spam tidak akan ditoleransi dan dapat mengakibatkan penutupan akun.
Tips: Memposting URL gambar/YouTube akan otomatis menyematkannya di postingan Anda!
Tips: Ketik tanda @ untuk melengkapi nama pengguna secara otomatis yang berpartisipasi dalam diskusi ini.
