Trade #10
EURJPY Long -> TS
EURJPY Long -> TS
Attached Image (click to enlarge)
As simple as possible: 00 level trading
{quote} hello thank you for kinds wordsI will try to answer your questions: 1. conditional formatting is used for one reason: read most of information in blink of eye so if you see in bottom row two digits (10.0+) (you recognize it fast) there is potential strength ( i tried to do it as simple as possible) 2. yes there are little differences but idea is : red= low strength and if strength is raising then is just added brightness etc. I think you will find your way how to work with... it is just question of time
first I would like to say thank you for the evolution of the spreadsheet.
Please correct me but after having a look at the calculations for the 3rd row it seems to me that there must be a mistake. From my point of view the maximum value could only be 9.0. Let me explain my understanding a little bit using the euro as an example:
- You have 7 pairs containing the euro.
- Let´s assume that the euro is extreme strong and is assigned the value 9.0.
- This implies that all the other currencies would be 0.0.
- Following the calculation in the spreadsheet it would look like [(9-0)+(9-0) ... +(9-0) ]/ 7 = 63 / 7 =9
In my humble opinion there are paratheses missing in the formula. Because of this issue only the last value is divided by the number of the pairs (7) which may lead to false conclusion (depending on the last value).
I could be wrong about that (and hopefully will be) but it does not make sense to me.
Feedback is highly appreciated. Maybe Cycle could contribute a little since I have seen some similar posts by him.
- #31,374
- May 27, 2015 3:38pm May 27, 2015 3:38pm
{quote} Hi Masofras, first I would like to say thank you for the evolution of the spreadsheet. Please correct me but after having a look at the calculations for the 3rd row it seems to me that there must be a mistake. From my point of view the maximum value could only be 9.0. Let me explain my understanding a little bit using the euro as an example: - You have 7 pairs containing the euro. - Lets assume that the euro is extreme strong and is assigned the value 9.0. - This implies that all the other currencies would be 0.0. - Following the calculation...
hello
yes you are right, thank you very much for your feedback. It shoudnt be divided by 7 . I was making this spreadsheet only by nasaps screenshots.
thank you again
Here is updated version
masofras
- #31,375
- May 27, 2015 3:39pm May 27, 2015 3:39pm
{quote} Unfortunely i cant use your meter {image}
Of course you can
check these steps:
-run MT4 ( MT4 must be always openned first, then you can open excel spreadsheet)
- allow/enable DDE server in your MT4 ( you will find it settings/options)
- check this : https://support.office.com/en-us/art...5-aebb9837bd1e and in Decimal separator type "."
NOTE: it works on MS Excel 2007/2010 Im not sure if it works on MS Excel 2003
I think I didnt forget anything
masofras
- #31,376
- May 27, 2015 4:06pm May 27, 2015 4:06pm
{quote} hello Of course you can
- #31,378
- May 27, 2015 4:20pm May 27, 2015 4:20pm
- Joined Aug 2010 | Status: EsikeTrader | 2,227 Posts
Time always comes before price
