Quantcast Real-time data and Excel link up - Aussie Stock Forums

Results 1 to 19 of 19
  1. #1

    Smile Real-time data and Excel link up

    I'm new here, so hello to everyone. I'm experienced with charts and various software packages but I am interested in finding the best (and cheapest) way of getting live ASX data that will interface with MS Excel so I can use my own macros and displays. The key thing here is how I can link it to Excel. Any ideas?

    Cheers to all!
    Last edited by RichKid; 5th-July-2005 at 07:34 PM. Reason: formatting

  2. #2
    The Oracle brerwallabi's Avatar
    Join Date
    Jul 2004
    Location
    Nakhon Ratchasima
    Posts
    515

    Default Re: Real-time data and Excel link up

    Try this company they have a product called XCELSIUS, if you investigate and find useful please report back as I do not have the time.
    www.infommersion.com

  3. #3

    Default Re: Real-time data and Excel link up

    I don't know if this is the right post to put this in but what I would like to know is:
    Are there any programs out there or is there any way that "live market data" eg. share prices,volume,depth etc can be directly linked to Excel and therefore be manipulated in that program (I had used The Bourse software and was able to copy and paste data to excel but there was no way to get this information to auto update inself). Help would be appreciated.
    Last edited by RichKid; 5th-July-2005 at 07:33 PM. Reason: formatting

  4. #4
    rozella rozella's Avatar
    Join Date
    Nov 2004
    Location
    NSW Far South Coast
    Posts
    1,051

    Default Re: Real-time data and Excel link up

    I use a DDE link from sanford securities to update all my excel spreadsheets. When you open your file it asks if you want to update yes/no.

    The only problem is that you pay $77/month for sanford pro + $35/month for the DDE link, & you can't have the DDE link without the other, but if you do lots of spreadsheets with large amounts of updating to do, it only takes seconds instead of hours.....for me it is worth it.

    rozella

  5. #5

    Default Re: Real-time data and Excel link up

    I use webtrader software specifically for writing my own programs for intra day trading but find now that as i am approaching the completion of my objective, with the amount of programming involved ,updating is not 100%. I am considering sanfords excel link but need to subscibe just to try. can any one tell me who is using this if they have found any restrictive problems in the link data flow when using a large watchlist and many parameters to monitor? the system being used is active x.

    landon

  6. #6

    Default Re: Real-time data and Excel link up

    Maybe you can link Excel to the data from QuoteTracker.

  7. #7

    Default Re: Real-time data and Excel link up

    For your own purposes (putting something out there for people to use is likely illegal), its quite easy in perl, visual basic or c# to screen scrape what you need from a variety of websites into MSAccess

    Basically your program connects to the site, grabs the HTML and then parses it for what you want out of the HTML and save it into MSAccess

    From there, linking to excel is a snap..

    If your not a programmer, obviously you have a problem.. if you are interested in learning programming, its your first project.. :-)

  8. #8

    Default Re: Real-time data and Excel link up

    Thanks for your replies, i am not interested in setting up a link from free data , i currently subscribe to webtrader which has a complete package of asx live data streaming into excel. all you have to do is write in vb the code according to your indicator needs. i am looking for an already set up system for which i am prepared to pay for provided it is faster in the linking system. all you have to do is write code which is not all that difficult when you subscribe to 'experts exchange' . the sanford set up looks appealing and i was wondering if anyone has been down this path.

  9. #9

    Smile Re: Real-time data and Excel link up



    Hi folks,

    Webtrade has very reliable live data in a spreadsheet
    format, complete with BIG and simple, but very clear charts.

    Static data can be imported and exported so no doubt,
    there's a way to hook into their dynamic system, which
    also includes a handy "ticker tape", as well.

    ...... maybe be check their website and contact them
    yourself, at:


    http://www.webtrade.net.au/


    Your own filters can be punched into Webtrader for
    trading equities, options and warrants ... long or short.

    At $82.50/month for unlimited access, Webtrader would
    seem to be good value ..... yes ???

    happy days

    yogi


  10. #10

    Default Re: Real-time data and Excel link up

    thanks, webtrade is good value but i require a faster system. I have been using webtrade for several years but no forthcoming improvements.

  11. #11
    PlanYourTrade > TradeYourPlan RichKid's Avatar
    Join Date
    Jun 2004
    Posts
    2,981

    Default Re: Real-time data and Excel link up

    Quote Originally Posted by Damien
    I'm new here, so hello to everyone. I'm experienced with charts and various software packages but I am interested in finding the best (and cheapest) way of getting live ASX data that will interface with MS Excel so I can use my own macros and displays. The key thing here is how I can link it to Excel. Any ideas?

    Cheers to all!
    I may have no idea what I'm saying here but have you tried the Microsoft Money links/sites, that may help?? or maybe not...
    RichKid

    My posts are not recommendations (even when I rave about something). Always rely on your own research & judgement.

  12. #12

    Default Re: Real-time data and Excel link up

    Resurrecting this thread, because I'd like to have a look at getting live ASX data into excel. Any ideas (other than IB)?

  13. #13

    Default Re: Real-time data and Excel link up

    Quote Originally Posted by Gringotts Bank View Post
    Resurrecting this thread, because I'd like to have a look at getting live ASX data into excel. Any ideas (other than IB)?
    IRESS and bloomberg. both have good DDE feeds
    I believe effort to be a finite resource. Something to be used only when there are no other options available.

  14. #14

    Default Re: Real-time data and Excel link up

    thanks sky. Is it easy enough to set up and run?

  15. #15

    Angry Re: Real-time data and Excel link up

    Quote Originally Posted by skyQuake View Post
    IRESS and bloomberg. both have good DDE feeds
    have been using webiress dde thru mf global for 7 years and the iress platform has been very reliable. fp markets and commsec provide webiress but i am looking at IB now that mf global has folded.....ie low commissions on futures and limit orders / traded orders can be transported live into excel...something you cant do with webiress however netiress can do this for $800/mth but not willing to pay this...depends really what you are trying to achieve . as a robot trader you need to have confirmation of trades in spread sheet but i can only continue my work when i get some money back from mf debacle.

  16. #16

    Default Re: Real-time data and Excel link up

    landon, how do you set up your robot trading?

  17. #17

    Default Re: Real-time data and Excel link up

    im using desktop iress - very easy to use buy quite expensive. Check out ADVFN, they did good dde's for a few o/s stocks, haven't used them for AU though.
    I believe effort to be a finite resource. Something to be used only when there are no other options available.

  18. #18

    Default Re: Real-time data and Excel link up

    Does anyone know if Paritech still have the Pulse DDE?

    If so, does anyone use it?

  19. #19

    Default Re: Real-time data and Excel link up

    I have used the platform for a month and they do have a DDE set up. I am fairly sure there is no backfill with DDE as is the case of DDE from MetaTrader to Amibroker. Although I don't see the point of paying for the platform to get O,H,L,C,V. Very few real time only data vendors .

    http://www.paritech.com.au/paritech/...PULSE_DDE.html

    Did not use the DDE.
    First share purchase :- 300 CBA @ $11.40 ish in 1996.

Similar Threads

  1. Converting Data into Excel
    By Vito in forum Software and Data
    Replies: 5
    Last Post: 23rd-December-2007, 02:07 PM
  2. Free data that downloads into Excel
    By nizar in forum Software and Data
    Replies: 5
    Last Post: 5th-October-2007, 08:37 AM
  3. Converting Metastock Data to Excel
    By Vito in forum Software and Data
    Replies: 1
    Last Post: 26th-September-2007, 02:02 PM
  4. Accessing and exporting open/close data to Excel
    By smoothsatin in forum Software and Data
    Replies: 2
    Last Post: 6th-June-2007, 04:42 PM
  5. Real Time Portfolio Management Program?
    By oow in forum Software and Data
    Replies: 1
    Last Post: 1st-March-2005, 08:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Aussie Stock Forums