Plot News / Downloader version 4.00 | Page 12 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

FFcal - Plot News indicator 692 replies

Plot News indicator (version 3.0) 402 replies

Good History Rate Downloader EA 14 replies

Plot News (version 2.0) 103 replies

Attachments: Plot News / Downloader version 4.00
Exit Attachments

Plot News / Downloader version 4.00

  • #221
  • Jun 12, 2017 9:35am Jun 12, 2017 9:35am
Hi Hanover,
I have managed to get the indicator up and running. however I realised that the time data is 1 hour in front when being ploted on the chart. How can i alter the data?
  • #222
  • Jun 24, 2017 3:39pm Jun 24, 2017 3:39pm
Quoting weihao82
Hi Hanover, I have managed to get the indicator up and running. however I realised that the time data is 1 hour in front when being ploted on the chart. How can i alter the data?
If the little numbered circles are being plotted under the wrong candles, you probably have an incorrect value in the TimeOffsets setting. Please read page 9 in the instruction manual PDF for more information.

If you want to manually change the data that's being plotted, you can edit the news.csv file using a text editor like Notepad. However, keep in mind that this file will get overwritten every time you run NewsDownloader.exe to download more news from the calendar. To get around this, you could copy news.csv to another file, and specify this new filename as the NewsInputFile when you attach the indicator.

An app named Convert News to GMT.exe is also provided in the ZIP file. Running this allows you to 'bulk edit' all of the date/timestamps in the news.csv file, shifting them forward/backward by the number of hours that you specify. For more info, see Appendix 2 on page 28 of the instruction manual PDF.
  • #223
  • Aug 16, 2017 7:03am Aug 16, 2017 7:03am
thx a lot.. this was really great indicator.
i can see what kind of effort u put in there
Okay... sorry about my messed up English Tenses
  • #224
  • Sep 13, 2017 1:02pm Sep 13, 2017 1:02pm
Quoting exidez
Thanks for that fxworldwide Version 1.4 has been released to include some bug fixes. - Fixed bug with wrong year in first week of a following year - fixed error when all arguments are not given - added option for high impact news only (use -I as an argument to output only high impact) Executable: https://drive.google.com/file/d/0B9K...ew?usp=sharing Python Script: https://drive.google.com/file/d/0B9K...ew?usp=sharing Edit: For those who havce already installed python, you may...


Exidez,

Python downloader stopped working. FF may have changed layout (date, time field). Did u notice ? Any fix ?
  • #225
  • Sep 13, 2017 10:59pm Sep 13, 2017 10:59pm
Quoting fxworldwide
Python downloader stopped working. FF may have changed layout (date, time field). Did u notice ? Any fix ?
FXWW,

I have uploaded the latest version of the News Downloader.exe in the ZIP file attached to post #1. It appears to be downloading news correctly on my desktop PC, my notebook PC and also my wife's PC (I have attached a sample output file, with this week's news events):
Attached File(s)
File Type: csv news.csv   7 KB | 296 downloads


I'm not aware of any recent changes to the format of FF calendar. Hence I haven't modified News Downloader.exe to accommodate any such changes.

Please feel welcome to try it as an interim solution, while you're waiting for Exidez to reply with a fix to his Python downloader.

Good luck,
David
  • #226
  • Sep 14, 2017 12:02am Sep 14, 2017 12:02am
[quote=hanover;10288520]{quote} FXWW, I have uploaded the latest version of the News Downloader.exe in the ZIP file attached to post #1.


Thks a million David. Will try it out after I finish my analysis and trading .........

Best tool I have used. VOpro would be next but neva used.

again thks

AM
  • #227
  • Sep 14, 2017 8:25am Sep 14, 2017 8:25am
The python script has stopped working - probably due to some changes to FF calendar.

Can someone please fix the error message when compiling the python code. It was working 1 week ago.

Exidez is away - post 200 has this python code.

Please help fix the error in compiling (was working last week).
Attached File(s)
File Type: zip PythonNewsDownloaderScript.zip   2 KB | 516 downloads
  • #228
  • Sep 14, 2017 2:40pm Sep 14, 2017 2:40pm
[quote=hanover;10288520]{quote} FXWW, I have uploaded the latest version of the News Downloader.exe in the ZIP file attached to post #1. It appears to be downloading news correctly on my desktop PC, ...................

David,

Downloaded and ran recent complied NewsDownloader.exe. See error message image attached. Updated curl.exe from home page, used MSDOS version as I am on Win 8.

Output file not created when I run NewsDownloaded.exe. I created output file "..._1" but was deleted when I executed script. Your thoughts ?
Attached Image
  • #229
  • Edited 4:19pm Sep 14, 2017 4:08pm | Edited 4:19pm
Quoting fxworldwide
Downloaded and ran recent complied NewsDownloader.exe. See error message image attached. Updated curl.exe from home page, used MSDOS version as I am on Win 8. Output file not created when I run NewsDownloaded.exe. I created output file "..._1" but was deleted when I executed script. Your thoughts ?
I'm running Windows 7 Home Premium Service Pack 1 (on all 3 computers), and use the curl files shown in the screenshot, i.e. these 3 files are downloaded from the ZIP file into my ..../MQL4/Files folder.
Attached Image (click to enlarge)
Click to Enlarge Name: PPI 539.png Size: 38 KB
I don't have a Win 8 computer, hence I can't test if these files run on Win 8.

The error message in your screenshot ("The system can not find the file specified") suggests that the correct curl files are missing from your ..../MQL4/Files folder.

If curl runs correctly, it downloads the news events from the FF calendar website, and creates the ffcalout(_1) file automatically.
  • #230
  • Sep 14, 2017 5:09pm Sep 14, 2017 5:09pm
First of all, Thank you very much for such a great indicator.

I was worry that starting this month that i was getting "Unable to process calendar" every day, so thank you for fixing that, works beautifully now.

I have a question regarding the news.csv format.

I am trying to edit the news.csv file to only show the news that want to see like for example only GBP CPI, on the original file format is as fallow:

"2017/09/12","04:30","GBP","L","Core CPI y/y","2.7%","2.5%","2.4%","","65503"

But when i go to excel and edit all the news that i don't want and save it, the format becomes like this:

9/12/2017,4:30,GBP,L,Core CPI y/y,2.70%,2.50%,2.40%,,65503

it took me a while to figure it out that the indicator can not read the edit format, so how can i edit and save the news.csv while maintaining the original format?

Best Regards.
  • #231
  • Sep 14, 2017 5:12pm Sep 14, 2017 5:12pm
Did forex factory calendar's time or date format was changed recently?
  • #232
  • Sep 14, 2017 5:53pm Sep 14, 2017 5:53pm
Quoting kishisaki
how can i edit and save the news.csv while maintaining the original format?
You could use a text editor like Notepad, to strip out the unwanted news events, instead of Excel.
  • #233
  • Sep 14, 2017 6:04pm Sep 14, 2017 6:04pm
Quoting hanover
{quote} You could use a text editor like Notepad, to strip out the unwanted news events, instead of Excel.
Thanks for the feedback, but it's so many, how would i do it efficiently on Notepad?
I was just using the "Sort & Filter" function of excel to do that, almost instantly.
I have all the news since 2007 to present so basically i want all the GBP CPI from 2007 to present.
  • #234
  • Edited Sep 15, 2017 8:47am Sep 14, 2017 11:29pm | Edited Sep 15, 2017 8:47am
Quoting kishisaki
Thanks for the feedback, but it's so many, how would i do it efficiently on Notepad? I was just using the "Sort & Filter" function of excel to do that, almost instantly. I have all the news since 2007 to present so basically i want all the GBP CPI from 2007 to present.
You have at least 3 choices:

1. Write a simple program to extract the desired data.
Example: install this MT4 script into your ..../MQL4/Scripts folder:
Attached File(s)
File Type: ex4 Extract GBP CPI from newsfile.ex4   17 KB | 308 downloads
It expects to find the input file with all of the news events in your ..../MQL4/Files folder.
NOTE: If you want the .mq4 source to compile without errors, you'll need to do this first. Otherwise, download only the .ex4 file.
Attached File(s)
File Type: mq4 Extract GBP CPI from newsfile.mq4   2 KB | 355 downloads

2. Create an additional column in Excel, with formulae that convert the date/time/number data into a suitable format, and insert any relevant delimiters (quotes), separators (commas), etc, in the correct places. Copy the formula down the column, then copy/paste the resulting data in the entire column into a text editor, and save it. An example of a (possibly) suitable formula exists in cell L2 in this XLS:
Attached File(s)
File Type: xls GBP CPI.xls   86 KB | 301 downloads

3. Download a product like CSVeasy (it has a free trial period, after which it costs less than $5 to buy).
Or you might be able to find something similar that's freeware (example: reCsvEditor).


Anyway, here are two files that I produced for you:
Attached File(s)
File Type: csv GBP CPI only.csv   9 KB | 265 downloads
Attached File(s)
File Type: csv GBP CPI.csv   19 KB | 263 downloads
The Plot News indicator seems to read them happily enough (see screenshot):
Attached Image (click to enlarge)
Click to Enlarge Name: PPI 541.png Size: 26 KB
  • #235
  • Sep 15, 2017 2:57pm Sep 15, 2017 2:57pm
Quoting hanover
You have at least 3 choices:...
Thank you very much for you help, truly magnificent effort hanover.
Thanks to choice 2 and 3 i was able to realize another option, using another spreadsheet application like OpenOffice, it handles formatting much better then excel at least from an easy to use perspective, i was able to maintain the original formatting of the csv while editing out the news as i needed for back-testing.
the Sort & Filter function is not as intuitive as excel but beats it having to deal with formatting.
  • #236
  • Edited 8:38pm Sep 16, 2017 6:57am | Edited 8:38pm
Quoting fxworldwide
{quote} Exidez, Python downloader stopped working. FF may have changed layout (date, time field). Did u notice ? Any fix ?
Quoting bm0899
Did forex factory calendar's time or date format was changed recently?
Updated. Now version 1.5
Executable: https://drive.google.com/file/d/0B9K...ew?usp=sharing
Python Script: https://drive.google.com/file/d/0B9K...ew?usp=sharing

The issue was that FF now puts blanks into their date table when a date is repeated for a news event. It used to just copy the date. I have now used the last known date in the code if it is a blank

I can also confirm that hanover's news downloader is working as per before (using windows 10). But i will continue updating mine just in case some people have modified the code to suit their needs and need small fixes to the fundamentals. Thanks Hanover for the fix as well!
  • #237
  • Sep 17, 2017 5:10pm Sep 17, 2017 5:10pm
Exidez- thanks for updating the python code. Really appreciate this and a quick turnaround on this. Wow, thanks again.

Hanover - thanks again for your help on this calendar.

Exidez and Hanover - You two have created something which is not available anywhere else! Congrats
  • #238
  • Sep 17, 2017 8:53pm Sep 17, 2017 8:53pm
Quoting exidez
{quote} {quote} Updated. Now version 1.5 Executable: https://drive.google.com/file/d/0B9K...ew?usp=sharing Python Script: https://drive.google.com/file/d/0B9K...ew?usp=sharing The issue was that FF now puts blanks into their date table ...........
BIG THK YOU !!!!!!

Still trying to get curl.exe to work on Win 8.

AM
  • #239
  • Sep 20, 2017 10:04am Sep 20, 2017 10:04am
Hello exidez,
thank you very much for updating your python-script. I test it and the functionality is the same.
But one thing is not correct. If I want to load more years, it stops in december 2015. The first week to load in this year.
You can see it in the screenshot I have uploaded.
Can you solve this issue please. Thanks
Attached Image (click to enlarge)
Click to Enlarge Name: error.png Size: 25 KB
  • #240
  • Sep 20, 2017 7:46pm Sep 20, 2017 7:46pm
Quoting fxdevelop
Hello exidez, thank you very much for updating your python-script. I test it and the functionality is the same. But one thing is not correct. If I want to load more years, it stops in december 2015. The first week to load in this year. You can see it in the screenshot I have uploaded. Can you solve this issue please. Thanks {image}
I was able to repeat the issue and I found the problem. Thanks for finding that for me.
It is now fixed with Version 1.5.1
Executable: https://drive.google.com/file/d/0B9K...ew?usp=sharing
Python Script: https://drive.google.com/file/d/0B9K...ew?usp=sharing
1 trader viewing now