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 sptrader with 1 posts (2 thanks)
    2. looks_two TheTrend with 1 posts (0 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 gparkis with 1 posts (0 thanks)
    1. trending_up 2,672 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?
Trade idea based off three indicators.
Traders Hideout
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
MC PL editor upgrade
MultiCharts
REcommedations for programming help
Sierra Chart
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
32 thanks
Just another trading journal: PA, Wyckoff & Trends
26 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
23 thanks
GFIs1 1 DAX trade per day journal
18 thanks
  #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