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

    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

    Daal

    I believe you can do this with IB DDE but I haven't used it in quite some time
     
  5. 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.

    Bob
     
  6. userque

    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.

    https://iextrading.com/developer/docs/
    https://www.alphavantage.co/
    https://intrinio.com/
    https://news.ycombinator.com/item?id=15616880
    https://www.tiingo.com/pricing/
    https://www.quandl.com/search?query=
     
  7. schweiz

    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.