Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
{quote} @dariuske I will check the calculation again. It should be a SELL, since the GAP for EU,GU,AU,NU are +1. it shows that you BUY the base and SELL the quote USD. and UC,UJ are -1. All the calculation are on the work sheet. It is just the timer and update that is protected. when you click on the Cell where you have 4, the calculation is there.
but. forex is fast moving and trend
how about this template
http://4.bp.blogspot.com/-QCmxF803lP...1600/trend.jpg
This trend simple forex
Any idea to perfect this sytem guys ?
- #63
- Oct 9, 2015 11:35am Oct 9, 2015 11:35am
- | Commercial User | Joined Aug 2013 | 2,935 Posts
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
- #64
- Oct 9, 2015 12:06pm Oct 9, 2015 12:06pm
- | Commercial User | Joined Aug 2013 | 2,935 Posts
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
- #65
- Oct 9, 2015 12:57pm Oct 9, 2015 12:57pm
- | Commercial User | Joined Aug 2013 | 2,935 Posts
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
{quote} Are you a chinese (see something, take picture and make copy it!)?I guess you are talking about the average market strength (2.59). What I know about its calculated from relative strength of the base currencies of all 28 pairs.
haha. i liked what i saw, thats why i copied it
thanks for the hint
Enter Signature
- #67
- Edited 3:48pm Oct 9, 2015 1:48pm | Edited 3:48pm
- | Commercial User | Joined Aug 2013 | 2,935 Posts
http://www.openoffice.org/download/?...mpaign=Upgrade
Apache OpenOffice 100 Mil downloads and its free and always upgrades.
Apache OpenOffice 100 Mil downloads and its free and always upgrades.
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
Hy
First of all congratulations to Jibala Pasan and Dtlase. Great work. I know how much time is needed for development VBA code. I have my own xls dashboard. Some of calculations is borrowed from: StrengthMeter.xls and Currency Stength (28).xlsx. And now Speedometer V2 has arrived on the FX scene. For me it is new and i like to investigate this spreadsheet, but it is password protected. I was download version for which Dtlase say: Here is the updated version with no password. But sorry password is still active.
I have question or suggestion for Jibala Pasan and Dtlase. I do not understand Lookup function for Strength meter.
I think that this is not necessary, in my system I use a different formula, because the values of the BID ratio varies between 0% and 100%, depending on where the current Bid price is located with respect to Day High and Day Low value. Maximum power of the currency pair is 10 or 100% and not 9 because of the Lookup Function. Due to the Lookup function results of Relative Strenght, is how should I say "frozen", only round numbers from 0 > 9 appears with no intermediate values.
How I was change the calculation and the difference in the result is shown at the attached image on the USD JPY currency pair.
Best regards
First of all congratulations to Jibala Pasan and Dtlase. Great work. I know how much time is needed for development VBA code. I have my own xls dashboard. Some of calculations is borrowed from: StrengthMeter.xls and Currency Stength (28).xlsx. And now Speedometer V2 has arrived on the FX scene. For me it is new and i like to investigate this spreadsheet, but it is password protected. I was download version for which Dtlase say: Here is the updated version with no password. But sorry password is still active.
I have question or suggestion for Jibala Pasan and Dtlase. I do not understand Lookup function for Strength meter.
I think that this is not necessary, in my system I use a different formula, because the values of the BID ratio varies between 0% and 100%, depending on where the current Bid price is located with respect to Day High and Day Low value. Maximum power of the currency pair is 10 or 100% and not 9 because of the Lookup Function. Due to the Lookup function results of Relative Strenght, is how should I say "frozen", only round numbers from 0 > 9 appears with no intermediate values.
How I was change the calculation and the difference in the result is shown at the attached image on the USD JPY currency pair.
Best regards
- #75
- Oct 9, 2015 9:07pm Oct 9, 2015 9:07pm
- Joined May 2015 | Status: Trader | 1,438 Posts
http://www.openoffice.org/download/?...mpaign=Upgrade Apache OpenOffice 100 Mil downloads and its free and always upgrades.
- #76
- Edited 9:21pm Oct 9, 2015 9:10pm | Edited 9:21pm
- Joined May 2015 | Status: Trader | 1,438 Posts
{quote} haha. i liked what i saw, thats why i copied it
- #78
- Oct 9, 2015 11:11pm Oct 9, 2015 11:11pm
- Joined May 2007 | Status: MT4/MT5 EAs/Indicators/Alerts coder | 6,542 Posts
"Tools Options... Translation Translation formula entry" menu option of MS Excel. {image} {image}
MT4/MT5 EAs/Indicators/Alerts coder
- #79
- Oct 10, 2015 1:09am Oct 10, 2015 1:09am
- Joined Jun 2014 | Status: Trader | 2,498 Posts
After conversion of all cells with a link to the MT4 DDE to the right format / syntax everything was present! Only the last sheet with the graphics has formatting problems (I mentioned already).
Just to illustrate that it works with OO!
Just to illustrate that it works with OO!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
- #80
- Edited 2:34am Oct 10, 2015 2:19am | Edited 2:34am
- Joined May 2015 | Status: Trader | 1,438 Posts