Article contest
Random question
Q: What are these reputation points?
Tyraslin

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…
Translate to English
Show original
Since you are not logged in, we don't know your spoken language, but assume it is English.
Please, sign in or choose another language to translate from the list.
or
Translate to:
Comments : 2 | Likes : 2
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…
Translate to English
Show original
Since you are not logged in, we don't know your spoken language, but assume it is English.
Please, sign in or choose another language to translate from the list.
or
Translate to:
Comments : 3 | Likes : 1
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…
Translate to English
Show original
Since you are not logged in, we don't know your spoken language, but assume it is English.
Please, sign in or choose another language to translate from the list.
or
Translate to:
Comments : 11 | Likes : 6
Contacts   Hot Links   Search
Dukascopy Bank SA
Route de Pre-Bois 20, ICC, Entrance H,1215 Geneva 15, Switzerland
tel: +41 22 799 4888, fax: +41 22 799 4880
info@dukascopy.comtwitterfacebookweibo
Site Map
Report an issue
© 1998-2014 Dukascopy® Bank SA
On-line Currency forex trading with Swiss Forex Broker - ECN Forex Brokerage,
Managed Forex Accounts, introducing forex brokers, Currency Forex Data Feed and News
Currency Forex Trading Platform provided on-line by Dukascopy.com