NexusFi: Find Your Edge


Home Menu

 


Quotes by TradingView
Go Back   >  Platforms and Indicators  > 



Automatically update in EXCEL


Discussion in Platforms and Indicators

Updated
      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,673 views
    2. thumb_up 2 thanks given
    3. group 3 followers
    1. forum 3 posts
    2. attach_file 0 attachments




 
Search this Thread

Automatically update in EXCEL

  #1 (permalink)
 gparkis 
New York City, NY/USA
Elite Member
 
Experience: Intermediate
Platform: NT
Trading: 6E, ZN, CL
Posts: 121 since Dec 2010
Thanks Given: 3
Thanks Received: 74

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

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Better Renko Gaps
The Elite Circle
About a successful futures trader who didn´t know anyth …
Psychology and Money Management
 
  #3 (permalink)
 TheTrend 
Paris, France
Elite Member
 
Experience: Advanced
Platform: Amibroker
Trading: Futures, Stocks
Posts: 95 since Jun 2011
Thanks Given: 118
Thanks Received: 105


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)
 
sptrader's Avatar
 sptrader 
Colorado
Elite Member
 
Experience: Advanced
Platform: MultiCharts
Broker: IB & Iqfeed
Trading: ES , CL
Posts: 535 since Apr 2010
Thanks Given: 1,097
Thanks Received: 701

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

Reply With Quote
Thanked by:




Last Updated on August 15, 2011


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts