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.

Search the Community

Showing results for tags 'excel'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome to Traders Laboratory
    • Beginners Forum
    • General Trading
    • Traders Log
    • General Discussion
    • Announcements and Support
  • The Markets
    • Market News & Analysis
    • E-mini Futures
    • Forex
    • Futures
    • Stocks
    • Options
    • Spread Betting & CFDs
  • Technical Topics
    • Technical Analysis
    • Automated Trading
    • Coding Forum
    • Swing Trading and Position Trading
    • Market Profile
    • The Wyckoff Forum
    • Volume Spread Analysis
    • The Candlestick Corner
    • Market Internals
    • Day Trading and Scalping
    • Risk & Money Management
    • Trading Psychology
  • Trading Resources
    • Trading Indicators
    • Brokers and Data Feeds
    • Trading Products and Services
    • Tools of the Trade
    • The Marketplace
    • Commercial Content
    • Listings and Reviews
    • Trading Dictionary
    • Trading Articles

Calendars

There are no results to display.


Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


First Name


Last Name


Phone


City


Country


Gender


Occupation


Biography


Interests


LinkedIn


How did you find out about TradersLaboratory?


Vendor


Favorite Markets


Trading Years


Trading Platform


Broker

Found 4 results

  1. DOM Wall -- Excel / InteractiveBrokers author: PointOne Instructions: 1. open file, do not allow macros or updates 2. select all worksheet tabs 3. Find-Replace myID -> your user id, replace All (there should be 27 replacements). Save, close, open, allow macros and updates. Resize the window and position however you want. The Excel charts remain responsive to modifications and there should no longer be any VB error messages. es-dom-et1.xls
  2. DOM -- Excel / IB Author: mikeytrader 1. This DOM uses IB feed through standard IB DDE connection. 2. Data is replaced instantly in each cell. -- The performance is good because there is no excessive calculations. 3. Left most section shows the DOM Ladder, 3 columns, price, size, accumulated size. I colored the ask side with green and the bid side with red, but only colored to the largest size in each level. This allows you to see the wall easily. The yellow color is used to show which side has the largest accumulated size. 4. Middle section, For each of the 5 levels of the DOM a Horizontal bar expands or contracts base on the corresponding size. 5. Right section, Similar to the DOM ladder on the left side, this only shows the biggest wall amongst the 5 levels of each side, plus the immediate inner pair. Instructions: 1. Save xls to hardrive 2. Launch IB 3. Make sure IB under configure>>api>>enable dde and enable active-x are turned on 4. Open xls; when prompted to "update" just say no 5. type in your IB user id in cell B47 and make sure B48 is the current contract and hit enter 6. save the xls 7. click on the setup button 8. ib data should start to update. The next time you open the xls you can chose "update". p.s. 1. you will need a basic knowledge of Microsoft Excel to use this. 2. this worksheet is a few years old, you will need to update the symbol to the current contract. (see #5 above) . domib.xls
  3. 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
  4. Can anyone explain with detail how to to do this? I want to load real time data into a spreadsheet, and then add some VBA coding. First, things first, though how do I get the code in Excel. I tried using the wizard data connection but it doesn't seem to take my user name and password that BarChart gave me. Thanks, James
×
×
  • Create New...

Important Information

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