Using Excel to load active stock prices

Discussion in 'Trading Software' started by DallasCowboysFan, Feb 27, 2018.

  1. A couple of years ago Yahoo was allowing Traders to link Excel to their Finance feed and you could get current stock prices in the chart you designed from Excel.

    Then they dropped the link a year or so ago, when they had money problems.

    I found a link from MSN but it won't work on the current version of Excel....2016.

    I would like to try to create something like this so I don't have to keep logging in to my personal account. It's not as time consuming and it won't time me out.

    Any suggestions?
  2. lindq


    Google sheets will link with Google finance. Do a search. Google, of course.
    DallasCowboysFan likes this.
  3. I'll check it out in the morning.......
  4. Daal


    I believe you can do this with IB DDE but I haven't used it in quite some time
  5. themickey


  6. Robert Morse

    Robert Morse Sponsor

    If you open an account with Lightspeed Trading and use Realtick, you can have access to RealTick for Microsoft Excelâ„¢. It requires the pro version with the API enabled.

  7. userque


    I found these a while ago via searching Google and these forums. They offer free access. I use one of them in Excel (I don't recall which at the moment). I'm sure you can find others with a little effort.
  8. schweiz


    Maybe you could post the excel on ET. As you have it build it saves a lot of work for other people. And at least they know it works. Is that possible?
    I don't trade stocks but why invent the warm water again?
    And for people who are not so good in Excel it might be very helpful.
    DallasCowboysFan likes this.
  9. provaton


    I am currently building an Excel Financial Price Feed Add-in which will make it very easy to get live stock, currency, fund, crypto etc prices into Excel.

    You will be able to use formulas such as: =EPF.YAHOO.GetLivePrice("AAPL","Price")

    I am integrating it with Yahoo Finance, IEX and IG Index...more providers will be added once I launch it. Will post back here with details when it's ready.
    DallasCowboysFan and themickey like this.
  10. themickey


    I didn't see your post as at that time had you on ignore.
    See here a link from another post...

    Is there anything else you or anyone wants clarification on?
    I still use google sheets, in actual fact it has become a major part of my way of trading.
    #10     Nov 5, 2018