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.
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.