Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi , v-binbinyu shared this with us... https://towardsdatascience.com/best-5-free-stock-market-apis-in-2019-ad91dddec984 .
I was able to list stock ticker MSFT history from my pc's command line but i show nothing (not even a dataset) when i go thru the same steps in setting up a pbi python connector. Can someone help?
my script was entered in pbi as follows but even after reboot i couldnt get a dataset in pbi:
import yfinance as yf
msft = yf.Ticker("MSFT")
msft.history(period="max")
Solved! Go to Solution.
i'm not sure if the history method can ever act in this capacity and i did see pbi alternatives that use web sources instead of python for this same purpose but this seems to work...i dont think dataset is a key word. The last 2 statements apparently add columns to what the download method already offers. I'll be looking up/for ways to make the download method show more tickers and the symbol itself rather than the hardcoded stock name.
import yfinance as yf
dataset=yf.download('MSFT','2010-01-01','2023-06-30')
dataset["Date"]=dataset.index
dataset["Stock"]="Microsoft"
the history method can do it too. Had I coded my script like this, it would have worked too. Notice an object (dataset2) is assigned/points at the results of the history method.
import yfinance as yf
msft = yf.Ticker("MSFT")
dataset2=msft.history(period="max")
i'm not sure if the history method can ever act in this capacity and i did see pbi alternatives that use web sources instead of python for this same purpose but this seems to work...i dont think dataset is a key word. The last 2 statements apparently add columns to what the download method already offers. I'll be looking up/for ways to make the download method show more tickers and the symbol itself rather than the hardcoded stock name.
import yfinance as yf
dataset=yf.download('MSFT','2010-01-01','2023-06-30')
dataset["Date"]=dataset.index
dataset["Stock"]="Microsoft"
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
31 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
55 | |
38 | |
27 | |
24 | |
21 |