Automatically update in EXCEL - futures io
futures io futures trading



Automatically update in EXCEL


Discussion in Platforms and Indicators

Updated by sptrader
      Top Posters
    1. looks_one Quick Summary with 1 posts (0 thanks)
    2. looks_two gparkis with 1 posts (0 thanks)
    3. looks_3 sptrader with 1 posts (2 thanks)
    4. looks_4 TheTrend with 1 posts (0 thanks)
    1. trending_up 2,062 views
    2. thumb_up 2 thanks given
    3. group 3 followers
    1. forum 3 replies
    2. attach_file 0 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 100,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
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.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Thread Tools Search this Thread
 

Automatically update in EXCEL

  #1 (permalink)
New York City, NY/USA
 
Experience: Intermediate
Platform: NT
Trading: 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?

thanks

Reply With Quote

Can you help answer these questions
from other members on futures io?
Convert NinjaTrader NT7 indicator to Tradestation EasyLanguage and RADARSCREEN
Platforms and Indicators
Issue meeting order entry conditions
Elite Automated NinjaTrader Trading
Last 5 minutes Label
ThinkOrSwim
Moving average with Lag reduction
NinjaTrader
Linux?
ThinkOrSwim
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Spoo-nalysis ES e-mini futures S&P 500
376 thanks
VWAP for stock index futures trading?
47 thanks
Want your NinjaTrader indicator created, free?
46 thanks
Is Amp at risk of going under?
26 thanks
What is your single biggest weakness?
25 thanks
 
  #3 (permalink)
Paris, France
 
Experience: Advanced
Platform: Amibroker
Trading: Futures, Stocks
 
Posts: 96 since Jun 2011
Thanks: 118 given, 102 received


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

https://individuals.interactivebrokers.com/php/apiUsersGuide/apiguide.htm

Reply With Quote
 
  #4 (permalink)
Colorado
 
Experience: Advanced
Platform: MultiCharts
Broker: IB & Iqfeed
Trading: ES , CL
 
sptrader's Avatar
 
Posts: 543 since Apr 2010
Thanks: 1,094 given, 695 received

With an IB account, NO dde is necessary with this FREE tool- "IB Excel adapter".
http://www.cyberxpert.com/downloads.html

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



futures io Trading Community Platforms and Indicators > Automatically update in EXCEL




Upcoming Webinars and Events
 

Bookmap

May 28
     



Copyright © 2020 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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