NexusFi: Find Your Edge


Home Menu

 





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




 
Search this Thread
  #1 (permalink)
 gparkis 
New York City, NY/USA
 
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?
$4.5M Floods Russia Nuclear Contract in 24 Hours -- Krem …
Prediction Markets & Event Contracts
Post-Summit Market Verdict: ES -1%, NQ -1.5%, 10-Year Yi …
Traders Hideout
UCL Final Kicks Off at Noon ET: PSG at 56.5% as Iran May …
Prediction Markets & Event Contracts
Warsh Opens Today, Hormuz June 19 -- WTI Below $80, Fran …
Prediction Markets & Event Contracts
Trump Truth Social Fires Hormuz From 10% to 59% -- Arsen …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
6 thanks
Darmok and Jalad at Tanagra
1 thanks
  #3 (permalink)
 TheTrend 
Paris, France
 
Experience: Advanced
Platform: Amibroker
Trading: Futures, Stocks
Posts: 95 since Jun 2011
Thanks Given: 118
Thanks Received: 106


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
Market Wizard
 
Experience: Advanced
Platform: MultiCharts
Broker: IB & Iqfeed
Trading: ES , CL
Posts: 535 since Apr 2010
Thanks Given: 1,097
Thanks Received: 702

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


© 2026 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 - Downloads - Top
no new posts