Apps for Streaming Quotes in Excel

Discussion in 'Ask any question!' started by Allegiance, Apr 20, 2018.

  1. Allegiance

    Allegiance Member

    Joined:
    Apr 5, 2016
    Messages:
    46
    Likes Received:
    8
    Good afternoon Gents,

    Wondering if anyone knows a good app that I can add to excel which streams live ticker information. There are a couple that work for just US stocks (Stock Connector), however I am looking to stream TSX data as well.

    Thank you for your help!

    -Arthur
     
  2. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    485
    Likes Received:
    633
    Well, this won't directly answer your question, but in Google Sheets the "=Googlefinance()" function will return Toronto prices by appending ".TO" to the symbol. So, Algonquin Power & Utilities Corp, for example would be =Googlefinance("AQN") for the NYSE version and =Googlefinance("AQN.TO") for the TSE version. I think the ".TO" appendage is fairly standardized for a fair number of websites that use stock quote data.
     
    TomB16 and Allegiance like this.

Share This Page