After I finished working on “what I’ve been working on for last few months” it looked something like this picture.
At first look, instantly it was love at first sight… oh yeah! A whole year of my hard work finally here, finished product ready for application.
There are six aspect of this MS Excel file
1. It will eliminate any kind of volatility aspect from my trading
How? Well… haha hahhaa I’m feeling like giving insane laugh! Whats maket volatility anyway? Price moving very fast right? But if you can calculate your position size according to market volatility then.. 100 pips movement is basically equal to 500 pips move because in percentage your exposure and profit will be same. Very basic idea but I’ve capitalized it, finally.
2. This Excel file impliments Kelly Criteria at 4.1% profit per trade, yes regardless of market volatility every trade will yield 4.1% profit (potential).
3. Expected value invented by Daniel Bernoulli gives us the right decision basics.
Expected Value = Odds of Gain x Value of Gain if its positive then the trade should be taken.
4. Once I input the swing low and swing high of a Fibonacci setup (AB) it will automatically calculate the retracement levels as well as expansion levels…
5. Not only that… it will calculate the Risk and Reward and give me Expected Value based on real time data. Which means I’ll have all possible senario at real time based on my entry price… yes!
6. Once input price or entry price is fixed I can see pecentage gain/loss of my live account from within Excel! Absolute genius (self bragging).
I’ve created a total four templates for JPY (100) and Normal (1000) pips pairs.
Time for a kill.
Filed under: Random Thoughts
