Trading News - FF Calendar web scraper

Hey friends, after many years, I decided to come back to forex.

I'm trying to create an EA to trade news, so I made a web scraper to get all the news from the Forex Factory calendar.

If it's useful for anyone else, here's the CSV file with all the news from 2007 until February 2023, there are more than 70,000 records.

hi ,
I need a dataset like yours for academic research Your data is messed up, can you fix it, or can you help me tell me how to scrape it with Python?

Hi, as the previous user said it is messed up, it should look like this (see attached):

Can you correct it please and submit it again?

MANY THANKS SIR,
could you point me in the right direction on how to scrape the FF calendar,i'm interested on the dates from February 2023 to present,


reply to other users:
If the file is messed up:
1) open new excel file
2)go to data
3)select from text/CSV
5)import

you need to reformat the timestamp with this excel formula : example :=DATE(1970,1,1)+D29466/86400 you need to use this for every timestamp row (D -column 29466 -row) ,,,after that change the cell range format into date