Article Library

26/34
Ranking
This article is designed to be useful to developers with programming knowledge, and as well to End Users of the JForex platform. The section "JForex2Excel – End Users" is directed to all users. The section "JForex2Excel - Developers" is directed to developers. 1 - Motivation The idea for this project arose from the need to establish a bridge between the JForex platform and Excel. That is, send the data collected by the platform to a spreadsheet. The solution provided by Dukascopy in this document: http://www.dukascopy.com/wiki/#Write_in_Excel_(DDE) is a good solution, but has several drawbacks ranging from incompatibility with the latest versions of java to problems with the latest versions of Microsoft Excel. Many of these problems are because DDE (Dynamic Data Exchange) is an old technology, limited and unsafe. DDE has been superseded by newer technologies. Also, as stated, the latest versions of Microsoft Office have communication problems using the DDE technology. Microsoft recommends using more secure and newest technologies such as OLE (Object Linking and Embedding) instead of DDE. This was one of the most important motivations to realize this project as a contributio…
Read article
Translate to English Show original
sircris avatar
sircris 6 Sep.

The community member "us_copiosus" (Bob M) asked me about the possibility of having the date and time separately and then also about the possibility to choose the time zone. Of these concerns, was born the second and third version of JForex2Excel respectively. The entire topic can be seen here:

http://www.dukascopy.com/swiss/english/forex/jforex/forum/viewtopic.php?f=77&t=49764

And besides, I've uploaded both versions to the respective SourceForge download sites for both end users and developers.
Best regards.

jezz avatar
jezz 22 Oct.

Even if I'm not the intended user (or at least not at the moment) the article is great - short manual

HOANG_MAI_NHI avatar

very helpful for me

ivanMT avatar
ivanMT 28 Nov.

Hi sircirs and many compliments for your job. I would to know if it's only for windows. Do you know for mac. Thanks a lot

ahmedfathi23 avatar

I cant see the excel file with saved history until I stop saving, I need to see live data in excel . plz help

orto leave comments
15/30
Ranking
Mathematics is an essential tool in many fields, and it should be used extensively in trading as well. By using mathematics you will reduce emotion and uncertainty, two of the biggest hurdles a trader faces. I wrote a comment in another member's article on how he could test his trading system, so I thought that it was probably beneficial for more traders if I wrote a simple and easy to understand article, on how to backtest a system/strategy and evaluate its perfomance, using a few mathematical formulas.At the end of the article there's a link to an Excel file which contains a calculator, so you can easily and quickly compute these formulas without having to do any maths. ________________________________► How to do manual backtesting If you have developed a new system, or have a new idea but don't know if it is profitable in the long run or not, and don't know how to program an automatic backtest to check its profitability, you can do a manual backtest instead, also called paper trading. This is similar to using a demo account, because there is no financial risk. However, when you use a demo account to test your systems, it can sometimes take a long time for a statistically v…
Read article
Translate to English Show original
mohamed1 avatar
mohamed1 29 Nov.

Good luck.

DumbAsArock avatar

You're first and second this month. Impressive. +1

doctortyby avatar

Congratulations for the top place my friend and good luck into the expert evaluations

SpecialFX avatar

Hey Doc, thanks! :) There is still the Dukascopy evaluation though, I can finish first, last, or something inbetween. Good luck to you as well!

p0002 avatar
p0002 9 Sep.

Hello, can someone upload the formular again :-)?

orto leave comments
3/30
Ranking
One of the biggest misconceptions novice traders have, is to think that trade entries are the only element worth considering, and the only factor that will decide if the trade is profitable or not. They often pay little attention to exit strategies and even less to money management. Successful traders focus on money management and risk control first, while unsuccessful ones devote their full attention to trying to find the perfect entry. This article will provide you with a sound and proven money management system, which will allow you to trade consistently, always taking into consideration the underlying market conditions. Correctly calculating position size based on volatility is a key skill to have if you want to succeed in trading. At the end of the article there's a link to download this system. _________________________________________________________► The adaptability of cockroaches and why you should be like one Cockroaches are one of the most adaptable creatures on our planet, and they've been around for 250 million years. The reason why they were able to survive in different climates and environments is because they have simple behaviour patterns which can be adapte…
Read article
Translate to English Show original
fprophet avatar
fprophet 6 Dec.

hi - I really liked your Money Management Article & webinar.
Personally I like using Fibonacci ratios based on the size of the signal bar to calculate TP & SL but I'm going to try using ATR levels as you have suggested.

SpecialFX avatar

Thanks prophet :) Feel free to send me a private message if you need help using ATR and/or my calculator.

wh_ avatar
wh_ 27 Mar.

SpecialFX - great article. How would you adjust your formula if the traded currency pair did not include your account currency. i.e. from your example, say the traded pair was AUD/JPY? Would you first convert JPY/USD then multiply this result by USD/AUD?

weien avatar
weien 29 Oct.

Hi SpecialFx, I tried to download the XLS file but the download link already broke... appreciate if you can renew the file link... thank you very much.

TadCary avatar
TadCary 25 Feb.

This is great MM strategy. But using ATR will give you constantly changing SL/TP, it's not so easy to use. For example we had huge market swing, by ATR you put wide SL/TP, after swings goes calm period, and your SL/TP just don't work. To solve this problem I use MIN/MAX channel, and calculate SL/TP by its width. For example SL = 0.25, TP = 1,0 of channel width. This approach work better for ranging market that we have now. Maybe I've invented weel but it works ok in my vjForex algos.

orto leave comments
23/43
Ranking
Position Report“Those who cannot remember the past are condemned to repeat it” - George Santayana 1863-1952.NB: Go  here to read part I of this series of articles and here to read part II.This is the last section of the series of articles dedicated to money management with Microsoft Excel. We have dealt with statistics, then with risk management. Time is now for the history management of our previous trades.The Position Report is our trading log. All our previous trades will be here registered including different information concerning the trade itself like the instrument, the side – short or long –, the amount and so on. Moreover, it will also provide some calculations in order to have the accumulation of our profits and loses. It will also be used for the statistics seen in the first section. Last but not least, it will also be useful for the two graphs (Cumulation and Gross P/L).To select the sheet “Position Report”, click on its tab: The first time the tab is opened, the first line will automatically be filled-in. So DO NOT ERASE IT BUT MODIFY IT, otherwise all the formulas will be lost. Let’s see below more accurately.We have respectively the following columns:Position ID: Thi…
Read article
Translate to English Show original
litsat avatar
litsat 20 July

how much articles we will read about the same?

flbsharg avatar
flbsharg 20 July

What are you talking about ? Even if the 3 differents parts are based on the same excel's sheet, this 3 parts are talking about differents things. stats, position size and now, a log.

cooldog avatar
cooldog 21 June

thx for your share, Its really a good tool, i always find a tool like this ,just like the dashboard on metatrade.com until read your articles.  i will test it, any suggestion i will post here. thx again

cooldog avatar
cooldog 21 June

thx for your share, Its really a good tool, i always find a tool like this ,just like the dashboard on metatrade.com until read your articles.

orto leave comments
24/43
Ranking
Calculation of risk“We can only risk our life. And if we do not risk it, we cannot live." – Amélie Nothomb – 1967 While the previous part was essentially covering statistics, let’s now go through a more exciting section. NB: to read part I go to: Money Management and Risk Management with Ecel - Part IYou can download the files under the forum topic here. This part concerns the reasons WHY I wanted to do this Microsoft Excel file. This is the tool we will use to respect a good money management.  If the sheet “DDEJFOREX” is the brain of this Microsoft Excel utility, the Calculation of risk is its heart. Note that only the cells in yellow can be – and need to be – changed.1: Risk in %: This is the maximum percentage of our equity we are ready to risk on the trade we are about to do.  In the above case, we are ready to lose 2% of 9 994.07 euros (remember our equity was 9 994.07 &euro .2: Profit Factor (Risk X Ratio):  Ideally, in every persistent account, each time we gain a trade, it has to be greater than every trade lose even if sometimes, some persons seem not to be afraid to risk a lot of money for a minimum gain. That is not trading, that is casino. So this ratio is the number of…
Read article
Translate to English Show original
flbsharg avatar
flbsharg 10 July

Good tool ! Very useful for beginners to calculate the amount of trade ! +1

scramble avatar
scramble 14 July

Seems like you did a lot of work! well done

madihazulfiqar avatar

no doubt excel is one of the best sheet for money management very well written

orto leave comments
6/43
Ranking
First of all, I will not talk about the importance of a good money management in trading. Sure, we all know we can’t have a persistent trading account without it.The aim here is to provide a solid money management system with Microsoft Excel to enable us - not to know when to enter the market – but to know HOW to enter the market. The offered tool consists in a Microsoft Excel file and a JForex Strategy (the latter will be used to collect all the needed data). Of course, all you the requested links to download everything needed are also to be provided.Set-upTo set-up, a bridge between JForex platform and Microsoft Excel is first requested. I have used the article of the Dukascopy’s wiki. (http://www.dukascopy.com/wiki/#Write_to_Excel_(DDE) - All the needed files will be provided at the end of the article).First, the file “JavaDDE.dll” has to be placed in the “C:\Windows\System32” directory. (Sorry, I only use Windows; I don’t know if it’s possible under MAC or Linux). Windows has to be rebooted.Secondly, the file “pretty-tools-JDDE-1.0.2.jar” has to be placed in the directory “Strategy\files” (depending on where you place your strategies).The file “MoneyMangement.jfx” has to be pla…
Read article
Translate to English Show original
flbsharg avatar
flbsharg 4 July

Nice, very useful !

NagarajaAdiga avatar

Cool!!!!!!!!!! pretty interesting article and a different approach to RM and MM. I will try it

Likerty avatar
Likerty 13 July

Good article I just want to add that I really like sometimes to go with 30 perc
of my equity in one position

Likerty avatar
Likerty 13 July

and big fat plus for you too

OneGoodTrade avatar

Thanks for your article. Good luck.

orto leave comments