NexusFi: Find Your Edge


Home Menu

 





How to get live Forex quote to my Excel sheet


Discussion in Platforms and Indicators

Updated
      Top Posters
    1. looks_one arjfca with 5 posts (1 thanks)
    2. looks_two sptrader with 2 posts (3 thanks)
    3. looks_3 Harrymon12 with 2 posts (0 thanks)
    4. looks_4 sam028 with 1 posts (2 thanks)
    1. trending_up 8,728 views
    2. thumb_up 6 thanks given
    3. group 4 followers
    1. forum 9 posts
    2. attach_file 1 attachments




 
Search this Thread

How to get live Forex quote to my Excel sheet

  #1 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91

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

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
Better Renko Gaps
The Elite Circle
Are there any eval firms that allow you to sink to your …
Traders Hideout
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Exit Strategy
NinjaTrader
 

  #2 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,765 since Jun 2009
Thanks Given: 3,824
Thanks Received: 4,629

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

Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
Thanked by:
  #3 (permalink)
 
sptrader's Avatar
 sptrader 
Colorado
 
Experience: Advanced
Platform: MultiCharts
Broker: IB & Iqfeed
Trading: ES , CL
Posts: 535 since Apr 2010
Thanks Given: 1,097
Thanks Received: 701


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

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

Reply With Quote
Thanked by:
  #4 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91


sptrader View Post
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 [AUTOLINK]Backtesting[/AUTOLINK] • View topic - MC Spread on IB . Is MC is getting paid 1 [AUTOLINK]pip[/AUTOLINK] 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

Attached Thumbnails
Click image for larger version

Name:	MC_Excel Spread.gif
Views:	190
Size:	29.6 KB
ID:	66864  
Started this thread Reply With Quote
  #5 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91


sam028 View Post
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

Started this thread Reply With Quote
  #6 (permalink)
 
sptrader's Avatar
 sptrader 
Colorado
 
Experience: Advanced
Platform: MultiCharts
Broker: IB & Iqfeed
Trading: ES , CL
Posts: 535 since Apr 2010
Thanks Given: 1,097
Thanks Received: 701

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...

Reply With Quote
Thanked by:
  #7 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91


sptrader View Post
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

Started this thread Reply With Quote
  #8 (permalink)
Harrymon12
Digos City
 
Posts: 3 since Jul 2016
Thanks Given: 1
Thanks Received: 0

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

Reply With Quote
  #9 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91


Harrymon12 View Post
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

Started this thread Reply With Quote
Thanked by:
  #10 (permalink)
Harrymon12
Digos City
 
Posts: 3 since Jul 2016
Thanks Given: 1
Thanks Received: 0



arjfca View Post
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.

Reply With Quote





Last Updated on May 14, 2017


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts