Automatically update in EXCEL - Platforms and Indicators | futures trading

Go Back

> Futures Trading, News, Charts and Platforms > Platforms and Indicators

Automatically update in EXCEL
Started:August 15th, 2011 (01:19 PM) by gparkis Views / Replies:1,482 / 3
Last Reply:August 15th, 2011 (01:52 PM) Attachments:0

Welcome to

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread

Automatically update in EXCEL

Old August 15th, 2011, 01:19 PM   #1 (permalink)
Elite Member
New York City, NY/USA
Futures Experience: Intermediate
Platform: NT
Favorite Futures: 6E, ZN, CL
Posts: 121 since Dec 2010
Thanks: 3 given, 74 received

Automatically update in EXCEL

Hello All,

I am looking to use excel only to run some macros that will need to update automatically at EOD. I can get the macro portion done in excel but I need to find a way to tie a data source into excel so Im not updating OHLC for 70 markets by hand.

Any solutions?


Reply With Quote

Old August 15th, 2011, 01:19 PM   #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.


Old August 15th, 2011, 01:31 PM   #3 (permalink)
Elite Member
Paris, France
Futures Experience: Advanced
Platform: Amibroker
Favorite Futures: Futures, Stocks
Posts: 96 since Jun 2011
Thanks: 118 given, 101 received

If you have an account at IB you can use their DDE for Excel and even manage your trades from the spreadsheet:

Reply With Quote

Old August 15th, 2011, 01:52 PM   #4 (permalink)
Elite Member
Futures Experience: Advanced
Platform: MultiCharts
Broker/Data: IB & Iqfeed
Favorite Futures: ES , CL
sptrader's Avatar
Posts: 504 since Apr 2010
Thanks: 961 given, 615 received

With an IB account, NO dde is necessary with this FREE tool- "IB Excel adapter".

Reply With Quote
The following 2 users say Thank You to sptrader for this post:

Reply > Futures Trading, News, Charts and Platforms > Platforms and Indicators > Automatically update in EXCEL

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can NinjaTrader post a trade automatically upon execution to a website? richwaters NinjaTrader Programming 20 August 5th, 2014 11:17 AM
An update for your computer Big Mike Jokes 1 February 24th, 2011 06:54 PM
Automatically Trading EURIBOR @ ECB meetings Ryanb Elite Automated Trading 3 December 27th, 2010 08:27 AM
NT 7 Update TAJTrades NinjaTrader 21 October 22nd, 2009 06:12 PM
Indicator Update keepdchange The Elite Circle 4 October 14th, 2009 05:37 PM

All times are GMT -4. The time now is 04:12 PM.

Copyright © 2016 by 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.
no new posts

Page generated 2016-10-28 in 0.07 seconds with 19 queries on phoenix via your IP