Oanda's quotes into excel and creating syntetic cross

[m1000]

Hello,

I am looking for software which shows synthetic cross rates.
For example, oanda does not have EUR/CNY, but when i multiply USD/CNY by EUR/USD then I have EUR/CNY quote and I can buy USD/CNY and EUR/USD.

I thing, when I will import USD/CNY by EUR/USD quote into excel and multiply 1 column by 2 then I will receive EUR/CNY quote. But how to import oanda's recent data into excel? I don`t have API access.

I found some soft oanda Software - Free Download oanda which cooperate with FxTrade platform, so it shows the API isn't needed. Maybe someone could write small software which can present syntetic cross rates?

 

[pippero]

i have done it, but it's a high end statistiscal analysius software i am using. try using yahoo quotes, they have realtime data for all crosses

 

[m1000]

I see excel supports only 1-minute automated refreshing. I am high-frequency trader and I need 1s refreshing, so I thing excel isn't enough good for me.

Are you import into what? Excel or java soft or somethink else...?


Maybe exist some "syntetic cross rate builder" in metalanguage? Then I could watch quotes on MT4 and make transactions on oanda manually. I saw this site Index of /mt_yahoo but i can't find this indicator