Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

rabcnesbit

IB's Realtime Bars

Recommended Posts

(Hope I have posted this in the right category)

 

Interactive Broker's TwsActiveX API spreadsheet provides realtime bars as 5-second bars. I would like to have this as 3-minute bars and 5-minute bars. Has anybody found a a way around this, or got any suggestions? I have a reasonable knowledge of excel, very limited knowledge of VBA, and no clue at all about VB. Many thanks.

 

Dan

Share this post


Link to post
Share on other sites

If you know how to do things in Excel just take chunks of 36 (=3x12) realtime bars to produce 3 minute bars resp. 60 (=5x12) for 5 minute bars.

Compute for these chunks e.g. Mininum resulting in Low, Maximum resulting in High and so forth.

Same way as it would be done in a proper programming language.

 

 

Here comes the free additional hint that probably nobody wants to hear:

- IB's realtime data is much better than what people usually say. Bars not needed.

- Aggregating data (building chunks of longer timeframes) should be absolutely avoided. It results in loosing important information

Share this post


Link to post
Share on other sites
If you know how to do things in Excel just take chunks of 36 (=3x12) realtime bars to produce 3 minute bars resp. 60 (=5x12) for 5 minute bars.

Compute for these chunks e.g. Mininum resulting in Low, Maximum resulting in High and so forth.

Same way as it would be done in a proper programming language.

 

 

Here comes the free additional hint that probably nobody wants to hear:

- IB's realtime data is much better than what people usually say. Bars not needed.

- Aggregating data (building chunks of longer timeframes) should be absolutely avoided. It results in loosing important information

 

Thanks uexkuell for your reply. Could you explain further please? The real time bars data is displayed in excel in the following columns: Open, High, Low, Close, Vol, WAP, Count. So, are you saying that I create a variable for each and say store 60 x 5 second figure for each - Open, High, Low, Close etc. Now, how do I 'compute' say the Open for the 60 x 5-second bars (the 5-minute bar)? I don't think it is a case of adding them up and dividing by 60 or something, is it? Thanks

Share this post


Link to post
Share on other sites
Now, how do I 'compute' say the Open for the 60 x 5-second bars (the 5-minute bar)?

 

Now you got me on the one I didn't explain.

 

Fortunately this is the easiest:

Open is just the Open of the first bar.

Close is of cause the Close of the last bar.

(Low is minimum of all Lows, High is maximum of all Highs).

 

If it's still not clear you can post your worksheet and I can see if I can do something.

Share this post


Link to post
Share on other sites
Now you got me on the one I didn't explain.

 

Fortunately this is the easiest:

Open is just the Open of the first bar.

Close is of cause the Close of the last bar.

(Low is minimum of all Lows, High is maximum of all Highs).

 

If it's still not clear you can post your worksheet and I can see if I can do something.

 

 

Thanks uexkuell. I did manage to figure out the above as well. Just to check, will the volume be the total volume of all the bars, and count (the number of trades) be the total count of all the bars? The only one that I haven't got a clue about is the WAP (weighted average price) i.e. how would I compute the WAP for say the 5-minute bar from the 60 x 5-second bars?

 

Thanks

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.