Just noticed new "Stock Data" feature in Excel

Discussion in 'Data Sets and Feeds' started by Metamega, Aug 1, 2019.

  1. Metamega

    Metamega

    Got a new laptop awhile back and ended up getting office 365, desktop just had a licence for excel 2016.

    Was updating my trade journal and noticed "Stocks" at the top. Bit of googling and found this.

    https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

    Using the prefixes for exchanges found here

    https://support.office.com/en-us/article/about-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6

    Ex: XTSE:TD (Toronto Dominion on the TSX exchange)

    Googled about historical data but didn't turn up much besides a post from a microsoft representative saying their we're more features in development( who knows if he actually knows what he's talking about)

    https://excel.uservoice.com/forums/...current-stock-prices-and-historical-data-into

    Just sharing with the dumbies like me that never even noticed this newer feature. As it right now as mostly delayed data, with only OHLC for the day and a bit of fundamental data it's a limited tool.

    Figured someone could make an EOD market movers type scan, or perhaps use to update a position tracking/trade journal spreadsheet.

    The links are covered in "Not for Professional Use" so I doubt they'll get to far into market data ,plus the data comes from Refinitiv which just got picked up by London Stock Exchange so who knows I guess.
     
    Onra likes this.