CICR system (Currency index cross referencing)

I have tried with other 2 broker MT4 different: Deltastock and FXDD

And now what I can see only is the JPY like sample this image

@ Kelsen, you are getting there, takes time for the data to populate the chart, but why not check out LiteForex in the meantime, they have all 28 pairs required...???

There is no way that he can make it the sheet of Excel following your installation step by step work.

I have tried with several brokers and the only ones that show something are: Deltastock and FXDD ( only I can see the JPY ). The other broker SIGTrader, impossible XTB to see no pair.

Equal I thank all for his kindness in responding.

Thanks in reality.

Greetings and that they have good trading

I found the solution at last.

For All the ones that cannot visualize all the pairs, the solution is very simple.
As I have the configuration in another language, it has to change the values of the coin of her , for .

Thank you very much to all specially to Erebus.

Hi

I'm having the same problems with the spreadsheet data. I have a live account with Alpari UK which has all of the 28 pairs as far as I am aware.

I have followed the instructions ie checking DDE in metatrader, opening the platform first before opening the excell spreadsheet. All i am seeing is the words REF# alongside the pairs and no LIVE data? Does the excell spreadsheet file need to be put somewhere specific ie within a file in the metatrader platform for it to be recognised?

Sorry to be a pain but this is driving me nuts!!!

Thanking you in advance for any advice you may be able to give.

Regards,
Kevin.

No, no need to go anywhere special.

Does Alpari use a special code for the symbols, eg. EURUSDm or some other letter on the end?

That may not be read properly by the spreadsheet, as I think this is what Kelsen was trying to explain in previous post.

Just get a demo with LiteForex, we know that works for sure, good luck.

Voy hacer un resumen de como solucione el problema, espero que se entienda, en la versión de ingles estoy usando un traductor, así que perdonen si suena disparate.


El único corredor que me trabaja la hoja Excel CSM es con el bróker Liteforex : SIGTrader MT4.


Pero como tengo el sistema operativo Windows 7 Ultimate en español, la configuración del formato de visualización de fechas, horas, monedas y medidas, es diferente al inglés.


Es decir, si queremos que la hoja de Excel CSM funcione correctamente, hay que cambiar la forma en que el equipo muestra los valores de números, si el sistema operativo es en otro idioma distinto al inglés. En mi caso es en español.


La ruta para cambiarlo es la siguiente:


Panel de control -> Configuración regional y de idioma -> Configuración adicional -> Números


Símbolo decimal: . (En la configuración en idioma español es , )
Símbolo de separación de miles: , (En la configuración en idioma español es . )


Corregidos estos parámetros se siguen todos los pasos de la instalación de la hoja Excel CSM no habría problemas.


Observación: solo me ha funcionado con el corredor Liteforex. Por el contrario no hay manera de que trabaje con estos corredores XTB, FXDD y Deltastock todos MT4 y todos ellos tienen los 28 pares requeridos. Por qué no me funciona lo desconozco.


_______________________________________________________
I go making a summary of as I solve the problem, I hope that he gets along well, in the version of Englishman I am using a translator, so they forgive if sounds piece of nonsense.

The only corridor that the sheet works Excel for me CSM is with the bróker Liteforex: SIGTrader MT4.

But as I have the Windows operating system 7 Ultimate in Spanish, the configuration of the format of visualization of dates, hours, coins and measures, is unlike the Englishman.

That is, if we want than the sheet of Excel CSM work correctly, have to change the way that the team shows the values of numbers, if the operating system is in another different language to the Englishman. In my case it is in Spanish.

The way to change it is the following:

Control panel -> Configuration regional and language -> Configuration additional -> Numbers



Symbol decimal: . ( in the configuration in Spanish language it is , )
Symbol of separation of thousand: , ( in the configuration in Spanish language it is . )



Once these parameters were corrected follow him all the steps of the installation of the sheet Excel CSM would not be problems.



Observation: Only it has run on the corridor Liteforex. On the contrary there is no way that he works with these corridors XTB, FXDD and Deltastock all MT4 and all of them have the 28 required pairs. Why it is out of service I am ignorant of it.

Thank you for the replies and advice. I already had Liteforex (Sigtrader) but it still would not work, HOWEVER I downloaded a copy of Open Office and it now works SORT OF! The data is populating but as of yet I do not have any of the graphic illustrations, not sure why that is still not working?

Regards and thank you again,
Kevin.

Hi wingate,


I had the same problem: If the image appears to you that way with numbers in sequence of ( , ) they do not charge your data. If the image with numbers in sequence appear to you with ( . ) they charge your data. What I mean gets along well.


Because you do not pay attention as you have once the symbol was configured decimal and the symbol of separation of thousand there being if that one is the problem.


The way to change it is the following:

Control panel -> Configuration regional and language -> Configuration additional -> Numbers


Symbol decimal: . ( in the configuration in Spanish language it is , )
Symbol of separation of thousand: , ( in the configuration in Spanish language it is . )

Thank you Kelsen but that is not the problem unfortunatly. The thing is I do not have any pictures showing at all? God this really is doing my head in!!!!!!!!!!!!!!!!

Thank you very much for trying though.
Regards
Kevin.

Try closing down all applications, and open the MT4 first, then the spreadsheet and let's hope this works as it draws a lot of CPU memory.

Hi 919gilead,

Restarted laptop and did exactly as you suggested but to no evail? I do not have any colored graphics showing anywhere, either bar charts or the coloured balls... weird and so annoying!

Regards,
Kevin.

If you are on skype, we could share screen, and I could take a look for you. Skype name is gilead919

Hi Gilead,

I have Skype on the lappy but never use it Lol. Would what you are proposing be easy enough to do? Thanks for the kind offer.

regards
kevin.

I don't know - just wanted to check with you what may be wrong as it should be working. Unfortunately I left this message for you over an hour ago, and have been checking for your response and just getting it now that I'm closing for the day. Read some of the troubleshooting others have done and see whether any will work for you. Check the cross referencing cells and confirm that the names of the pairs are the same with your broker. Mine does not work with some brokers while it works on others. It works well with FxPro & Sigtraders, and not on my Windsor MT4 as example.

Hope you resolve the problem, otherwise tomorrow is another day, we could try immediately after London close.

Cheers, and God bless

George

Thanks George,

Sorry it took a while for me to answer your post, was away from computer putting my daughter to bed. I will be working from home tomorrow so will try again and keep an eye on this thread to see if you are on here.

Hopefully I will resolve this through trial and error or speak with you again tomorrow.

Many thanks and regards,
Kevin.

No problem, I will shot you an email now so we don't clog the thread, and can take it from there tomorrow.

Take care

George

Hello All,
I see some are having an issue with the SS. At first thought, one should develop the skill required for trading, weather on techinical front or with fundamentals or the combination of the two ( called TECHNAMENTALIST, read the word somewhere long time back). Once you know the correct way to trade in the FX markets ( discipline, patience and practice ), one can take even the simplest of tools (like pure price action) and do well.
In any case, for those wanting to use the SS, couple things. First, Close all, restart machine, open MT4, go to Tools > Options > Server > Check "Enable DDE Server", > OK. Wait a while till the MT4 is fully loaded and giving current and correct data. Sometimes MT4 takes a minute or two to do this depending of the Machine configuration. If you have multiple MT4 applications, do this for all as I don't know from which MT4 the SS takes data. Then start SS (Excel Spreadsheet, please note that some features may not work with older versions of excel, thus be advised to have atleast 2007 version of it, it's what I have and has no issues), Below the Menu, you'll see a "security warning" message and to the right of it will be a button, "OPIONS...", click it and check the radio button for "Enable this content". > OK. That should do it I guess. This is also explained in the last tab of the SS > Installation.

Cheers. M.

Somebody can pass me the spreadsheet to [email protected]

Thank you.

I am very interested on using the CSM Excel spreadsheet, could somebody email it to me at [email protected]

Thanks.