Welcome to the Traders Laboratory Forums.
Advanced Search
Traders Laboratory Forums » Trading Styles and Methods » Automated Trading » OHLC in IB's API for EXCEL

Automated Trading Black box systems, strategy automation, algorithmic trading, etc...

Reply
Old 06-07-2010, 11:13 AM   #1

Join Date: Jun 2010
Location: Mumbai
Posts: 2
Ignore this user

Thanks: 0
Thanked 0 Times in 0 Posts



Exclamation OHLC in IB's API for EXCEL
Hey guys,

I am trying to implement a trading strategy that requires me to work on 1-min OHLC live data for a contract, say ES.
Can anybody help me get an idea how it can be done? I am new to the Intreactive broker's API for Excel.

Thanks in advance.
Amit
amit.options is offline  
Reply With Quote
Old 06-07-2010, 11:34 AM   #2

Tams's Avatar

Join Date: Sep 2008
Location: Geelong
Posts: 3,589
Ignore this user

Thanks: 2,026
Thanked 1,402 Times in 862 Posts



Re: OHLC in IB's API for EXCEL
look under the TWS folder in your computer,
IB provided a sample worksheet for extracting data from TWS.
__________________


..........This is a terribly difficult question to answer. The only satisfactory answer is: "It depends"...
Tams is offline  
Reply With Quote
Old 06-07-2010, 12:19 PM   #3

Join Date: Jun 2010
Location: Mumbai
Posts: 2
Ignore this user

Thanks: 0
Thanked 0 Times in 0 Posts



Re: OHLC in IB's API for EXCEL
ya but i can only get live quotes in there. any idea how can i get live ohlc format data?
amit.options is offline  
Reply With Quote
Old 02-06-2011, 12:53 PM   #4

Join Date: Apr 2007
Location: dublin
Posts: 9
Ignore this user

Thanks: 3
Thanked 1 Time in 1 Post



Re: OHLC in IB's API for EXCEL
google "quotelink" and "xlq"
sr100m is offline  
Reply With Quote

Reply

Tags
apinterface, excel, interactive broker, ohlc

« Tradestation Historical Data Feed | Can't Follow the Code, Please Help.... »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode


∧ Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Feed with API for Order Book Analysis AgeKay Automated Trading 33 10-28-2010 05:57 AM

All times are GMT -4. The time now is 07:30 PM.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
CS to VB integration by DeskLancer
©2006-2011 Traders Laboratory, All Rights Reserved.