Please, How can I get News Calendar in a Excel form? | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

Looking for Excel Spreadsheets (Please post here) 17 replies

economic calendar data in excel 3 replies

Economic calendar downloadable in excel 6 replies

Need simple excel sheet/program for risk calculation please 8 replies

Attachments: Please, How can I get News Calendar in a Excel form?
Exit Attachments

Please, How can I get News Calendar in a Excel form?

  • #1
  • First Post: Nov 6, 2011 8:10pm Nov 6, 2011 8:10pm
The news calendar, for backtest.
for example:
http://www.forexfactory.com/calendar...th=1&year=2007

or

http://www.fxstreet.com/fundamental/economic-calendar/
  • #2
  • Nov 6, 2011 10:02pm Nov 6, 2011 10:02pm
I don't know if somebody wrote something to this, but I don't recall seeing a posting recently.

Anyway the approach I would take if I wanted to do this is find a general purpose utility that captures web page table data and outputs it in CSV form. I believe such a program exists but I haven't looked for nearly two years.
  • #3
  • Nov 6, 2011 10:06pm Nov 6, 2011 10:06pm
Quoting CodeMeister
I don't know if somebody wrote something to this, but I don't recall seeing a posting recently.

Anyway the approach I would take if I wanted to do this is find a general purpose utility that captures web page table data and outputs it in CSV form. I believe such a program exists but I haven't looked for nearly two years.
it'll be in hanover's plot news indicator... but shit like daylight savings and whatnot really makes for irritation.
Congratulations ScalaFX for coming out of the closet!
  • #4
  • Nov 6, 2011 11:30pm Nov 6, 2011 11:30pm
Quoting zaodian
The news calendar, for backtest.
for example:
http://www.forexfactory.com/calendar...th=1&year=2007

or

http://www.fxstreet.com/fundamental/economic-calendar/
Unzip the attached file to get a CSV of news events between 1 Jan 2007 and 4 Nov 2011. These are all timestamped New York time (same as Forex Factory calendar time). This means they are GMT-4 when NY is on daylight saving time; otherwise they are GMT-5.

Install and run the Convert to GMT script to convert the timestamps to absolute GMT+X time (more info here). If your MT4 br0ker adjusts for daylight saving, then you'll need to either modify the code accordingly, or make the changes to the output data manually.
Attached File(s)
File Type: zip News 1 Jan 2007 thru 04 Nov 2011 --- New York time stamped.zip   367 KB | 742 downloads
File Type: mq4 Convert to GMT.mq4   71 KB | 533 downloads
  • #5
  • Nov 7, 2011 10:23am Nov 7, 2011 10:23am
Thank you Hanover. I can do backtest with the time and impact level of the news. There are too much 3rd impact levels in forexfactory's data.
the data from http://www.fxstreet.com/fundamental/economic-calendar/
have less 3rd impact levels.

Thank you for not only providing the data and also giving me the time convertor.
  • #6
  • Last Post: Jan 22, 2022 5:18am Jan 22, 2022 5:18am
Quoting hanover
{quote} Unzip the attached file to get a CSV of news events between 1 Jan 2007 and 4 Nov 2011. These are all timestamped New York time (same as Forex Factory calendar time). This means they are GMT-4 when NY is on daylight saving time; otherwise they are GMT-5. Install and run the Convert to GMT script to convert the timestamps to absolute GMT+X time (more info here). If your MT4 br0ker adjusts for daylight saving, then you'll need to either modify the code accordingly, or make the...
may u provide me csv file from 2004 to 2021?
0 traders viewing now