Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
44
Views
Topic starter
Good morning,
I am trying to download one year of history (365 days ) from yahoo finance.
However, I only get to 100 lines. Do you perhaps know of a way to download 365 days?
let
Source = Web.Page(Web.Contents("https://finance.yahoo.com/quote/QQQ/history/")),
Data2 = Source{2}[Data],
Replace = Table.ReplaceValue(Data2,",","",Replacer.ReplaceText,{"Open", "High", "Low", "Close*", "Adj Close**", "Volume"})
in
Replace
Thanks in advance,
Vicky
Posted : 24/12/2020 2:22 am
Hi Vicky,
This is a limitation by Yahoo. If you have Microsoft 365/Office 365 you can use the STOCKHISTORY function for this.
Mynda
Posted : 24/12/2020 5:50 pm
