News analysis tool - | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Analysis from history - looking for a tool 1 reply

Looking for a trading session analysis tool 0 replies

Looking for real time news tool 12 replies

ETF Analysis Tool 1 reply

Historic news chart tool 6 replies

Attachments: News analysis tool -
Exit Attachments

News analysis tool -

  • #1
  • First Post: May 24, 2007 9:20pm May 24, 2007 9:20pm
Here is a spreadsheet i made that shows how every news announcement we have had this year effected the price of the EUR/USD.... Good info for my fellow news traders that want to know where to set the stops and limits...


Price Prior to announcement = Price 1 min befor announcement (Start Price)

Highest price = highest price reached after announcement
High Time = time that highest price occoured
Lowest price = Lowest price reached after announcement
Low Time = Time that lowest price was reached

Pip Range = Highest price - Lowest price

Pips up = Highest price - start price
Min up = Mins from announcement to highest price

Pips Down = Lowest Price = Start price
Min down = Mins from announcement to Lowest price

Variation from forecast = % variation from forecast to accual (accual-forecast)/forecast
Variation from previous = % variation from prev to accual (accual-prev)/prev

---Way too big to post here is a pic. It has everything YTD. Soon I will make this sheet for all currency pairs for more in depth analysis. Shoot me an email if you wan ta copy
Attached Image (click to enlarge)
Click to Enlarge Name: 07News.jpg Size: 94 KB
Keep it simple stoopid....
  • #2
  • May 25, 2007 5:39am May 25, 2007 5:39am
I made some improvements to the spreadsheet Now ( it calculaes the values for all the majors ) But its just over 60 megs so i have a hard time sharing it.... anyone have a server i can post it on ?
Keep it simple stoopid....
  • #3
  • May 25, 2007 10:12am May 25, 2007 10:12am
I'm very interested in Your file. Maybe You can use some file sharing services ?
I don't use any so I can't recommend any, but recently I download some files from igorfx thread which where on file sharing server http://www.forexfactory.com/showpost...26&postcount=3.

or maybe Merlin could give You more space on FF forum ?

Andrew
  • #4
  • May 25, 2007 1:49pm May 25, 2007 1:49pm
I have made some mods to this file and now It shows the effect that each news event had on every currency pair. But I am having some problems collecting the data... Anyone have MT4 history data for the following pairs

AUDUSD
EURGBP
EURJPY
NZDUSD

thanks
Keep it simple stoopid....
  • #5
  • May 25, 2007 1:53pm May 25, 2007 1:53pm
  •  tesla
  • | Joined Oct 2006 | Status: Friendly Neighborhood Programmer | 533 Posts
Quoting Kurka Fund
I have made some mods to this file and now It shows the effect that each news event had on every currency pair. But I am having some problems collecting the data... Anyone have MT4 history data for the following pairs

AUDUSD
EURGBP
EURJPY
NZDUSD

thanks
Approx. two years data (1 minute bars) for these pairs and more available from Alpari:
http://www.alpari-idc.com/en/dc/databank.php

With MetaTrader brokers, I wouldn't be surprised to see a variance during highly volatile periods (such as news releases) so understand that the 'peaks' might differ from the data you've got.
  • #6
  • May 25, 2007 2:19pm May 25, 2007 2:19pm
Tesla, excuse my ignorace but what folder in MT4 do you download the chart history from Alpari in please?
  • #7
  • May 28, 2007 6:55am May 28, 2007 6:55am
Hi all,

Is anyone still interested in this great analysis done by Kurka Fund? I think it's gotta be a great tool. Really no one knows of a good webhosting that we can use for sharing of this tool?

If really not, I know of a good one. Only it's based in the Czech Republic (my home country) and therefore most of you are not going to be able to understand the environment which is written in Czech But I can upload it there for you, if you send me the sheet via e-mail. You can use WinRAR archiver (www.winrar.com) to compress it and reduce the file size, plus you can split the compressed file into any number of parts (say 5 MB each, for instance) and then you can send them, one by one.

I know it looks complicated, but it can really take like 30 minutes and I'll take care of the rest, so that the rest of the people can take advantage of the sheet as well.

Think about it

Thanks
  • #8
  • May 28, 2007 7:00am May 28, 2007 7:00am
  •  vrama
  • | Joined Dec 2006 | Status: BE at right place@right time = LUCK | 210 Posts
Quoting Malcik
Hi all,

Is anyone still interested in this great analysis done by Kurka Fund? I think it's gotta be a great tool. Really no one knows of a good webhosting that we can use for sharing of this tool?

If really not, I know of a good one. Only it's based in the Czech Republic (my home country) and therefore most of you are not going to be able to understand the environment which is written in Czech But I can upload it there for you, if you send me the sheet via e-mail. You can use WinRAR archiver (www.winrar.com) to compress it and reduce the file size, plus you can split the compressed file into any number of parts (say 5 MB each, for instance) and then you can send them, one by one.

I know it looks complicated, but it can really take like 30 minutes and I'll take care of the rest, so that the rest of the people can take advantage of the sheet as well.

Think about it

Thanks
I am interested. Let me know what to do? How to you want to provide this tool with sharing?

thanks
All things are difficult before they are easy.
  • #9
  • May 28, 2007 7:01am May 28, 2007 7:01am
Oh, and two more things:

If you want to do it the way I just described, PM me and I'll give you my e-mail address.

Secondly, I also know of a website where you can get 1-minute data all the way back to 2001 for like a dozen of pairs including the majors. I also typed a manual as to how to get them and use them properly. I posted it some time ago at another forum. I really don't feel like typing it again so I would prefer to give you a link, only I don't know if this forum's rules allow it. If yes, please tell me and I'll give you the link.

In order to respect the spirit of cooperation here, I hope you won't let me down and will cooperate on sharing the news sheet in return for my manual
  • #10
  • May 28, 2007 7:04am May 28, 2007 7:04am
Quoting vrama
I am interested. Let me know what to do? How to you want to provide this tool with sharing?

thanks
Well, there's nothing really to provide... The webhosting service is free. The only problem is that I feel I'm the only one who speaks Czech and therefore can perform the process of uploading the sheet. But I don't have the sheet so I need one of you guys who actually has it to send it to me via e-mail (or any other means, but it looks to me like this is the only option). So if you have the sheet, please PM me and I'll give you my e-mail address where you can send it. I urge you to use the WinRAR compression or both your and my e-mail providers will go nuts
  • #11
  • May 29, 2007 6:31pm May 29, 2007 6:31pm
Wow! very nice sheet !

Please use an rapidshare server to upload the Sheet ! also the Manual
Malcik is talking about

www.rapidshare.com

its very very easy to handle.only uploading could take some time

but then u can share to everybody!!

Thx alot in advance! cant wait for this stuff!

Aidan
  • #12
  • May 29, 2007 9:44pm May 29, 2007 9:44pm
Here is a link for download... this is the first one I did shows impact announcement had on EURUSD only.

I will post the next one soon With Impact on all currency pairs... Please post suggestions for improvements.

I would like to get this info into a DB so that we can search and analyize eaiser. but for now you have to sort by announcement string.


http://rapidshare.com/files/34168440/2007_news.html
Keep it simple stoopid....
  • #13
  • May 30, 2007 4:53am May 30, 2007 4:53am
If you want it in Excel then copy (ctrl a then ctrl c)and 'paste special' (right click/paste special/text).
  • #14
  • May 30, 2007 5:17am May 30, 2007 5:17am
Quoting Ragster
If you want it in Excel then copy (ctrl a then ctrl c)and 'paste special' (right click/paste special/text).
Excel can also open html doc correctly (File- open), you can later save it as xls file (File- save as)
  • #15
  • May 30, 2007 5:21am May 30, 2007 5:21am
Quoting Andrew_e
Excel can also open html doc correctly (File- open), you can later save it as xls file (File- save as)
Cool - even better!
  • #16
  • May 30, 2007 8:28pm May 30, 2007 8:28pm
Quoting Kurka Fund
Here is a link for download... this is the first one I did shows impact announcement had on EURUSD only.
Thx a lot Kurka Fund!
  • #17
  • May 31, 2007 12:31pm May 31, 2007 12:31pm
Hi Kurka Fund,

Thanks so much for your table, it's really a great piece of work. I'm looking forward to anything else that you release.

If you want, I could perhaps cooperate at converting it to a database. I'm a part-time web programmer so I think it should be no problem.

Let me know if you're interested.

Thanks and regards
  • #18
  • Jun 4, 2007 2:44am Jun 4, 2007 2:44am
Hello, I have a tool that does the news analysis. I have hosted it for public access here: skipcube.com
  • #19
  • Jun 4, 2007 11:32pm Jun 4, 2007 11:32pm
Wow your way ahead of me. is there anyway we can access the database tables on your site for updates ?
Keep it simple stoopid....
  • #20
  • Jun 5, 2007 12:35am Jun 5, 2007 12:35am
Quoting Kurka Fund
Wow your way ahead of me. is there anyway we can access the database tables on your site for updates ?
As an experiment, I can let some people access to the database tables. However, the tables are just as good as raw data. I'm not sure how going back to it is going to help. As for updates, I'll be updating it more regularly.
0 traders viewing now