Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"