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, 10: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, 10:34 AM   #2

Tams's Avatar

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

Thanks: 2,084
Thanked 1,474 Times in 912 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.
__________________



Only an idiot would reply to a stupid post
Tams is offline  
Reply With Quote
Old 06-07-2010, 11:19 AM   #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, 11:53 AM   #4

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

Thanks: 4
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
Display Modes Help Others By Rating This Thread
Linear Mode Linear Mode
Help Others By Rating This Thread:


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

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