Hello

Anybody as a solution to receive live Forex quote from Interactive Broker on my Excel sheet?

I had try a solution from cyberxpert . com. It work, but the update is slow and i got a differential of 2 pip between Multicharts and Excel.

Martin

Did you try with the Excel API ?
Their demo Excel does it, it's quite easy, check here.

I use the FREE "IB Adapter" - very fast and easy to use.. (not DDE)

"http://www.cyberxpert.com/downloads.html"

sptrader 

I use the FREE "IB Adapter" - very fast and easy to use.. (not DDE) "http://www.cyberxpert.com/downloads.html"

Hello

I did tried IB Adapter two weeks ago. Problem is I was not getting the same price from MC and IB adapter.

I did wrote in Multichart forum about that.
MultiCharts: Trading Software for Automated Trading and Backtesting • View topic - MC Spread on IB . Is MC is getting paid 1 pip by IB?

My conclusion was that MC was getting paid one pip over me since the price that I was receiving from IB Adapter was always around 1 to 2 pip lower. From the attach pict. You could see that for Eur.Usd and Eur.Jpy price quote was lower than MultiCharts price when i took a screen capture

Maybe you could explain how you use it. Did you compare the result with TWS or your broker. At any given time, do you have the same price quote on both?

Martin

sam028 

Did you try with the Excel API ? Their demo Excel does it, it's quite easy, check here.

Bonjour, Hello Sam

Yes I had tried last year, but for whatever reason, I wan not successful with it. I will re look at it.

Martin

I use the IB adapter for stock and option quotes, a 1 tick difference or 1 second delay doesn't matter to me..I use it for positions over several days..
Perhaps you should plot the "Bid" or "ask" in Excel (instead of last) and it will match closer. I've watched it live and it seemed very close to IB's price for stocks, I've never tried it with Forex...

sptrader 

I use the IB adapter for stock and option quotes, a 1 tick difference or 1 second delay doesn't matter to me..I use it for positions over several days.. Perhaps you should plot the "Bid" or "ask" in Excel (instead of last) and it will match closer. I've watched it live and it seemed very close to IB's price for stocks, I've never tried it with Forex...

I think you resolve the problem

I was capturing the last in Excel and Multicharts was displaying the bid.

Thanks

Martin

I am using this. It works great for me.
I have been using MarketXLS for this, it's been working Great so far

Harrymon12 

I am using this. It works great for me. I have been using MarketXLS for this, it's been working Great so far

MarketXLS: Look interesting
Martin

arjfca 

Hello Anybody as a solution to receive live Forex quote from Interactive Broker on my Excel sheet? I had try a solution from cyberxpert . com. It work, but the update is slow and i got a differential of 2 pip between Multicharts and Excel. Martin

I had been using MarketXLS. It really works for me just fine.