Hi Ricardo, Thanks for watching the video. It seems that MS 365 provides the following data only: Equities, market indexes, mutual funds, currencies, crypto Details can refer here: support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6 For the calls/puts options shown in below link, I guess web-scrapping technique can be used to retrieve the data. finance.yahoo.com/quote/MSFT/options Hope it helps.
![[Python & Excel] #3: How to use Python to download Real-time Stocks/FX Data from Microsoft 365 Excel](http://i.ytimg.com/vi/h2bxrUtETJM/mqdefault.jpg)
![[Python & Excel] #3: How to use Python to download Real-time Stocks/FX Data from Microsoft 365 Excel](/img/tr.png)
Love it Darrel. Very cool. I really appreciate how easy you make this to go along with.
Fantastic.
Would it be done with live option prices? Thanks
Hi Ricardo,
Thanks for watching the video. It seems that MS 365 provides the following data only:
Equities, market indexes, mutual funds, currencies, crypto
Details can refer here:
support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6
For the calls/puts options shown in below link, I guess web-scrapping technique can be used to retrieve the data.
finance.yahoo.com/quote/MSFT/options
Hope it helps.