You’re offline. This is a read only version of the page.
Announcements
3
I am trying to pull in stock ticker data from google.com/finance for different stocks and have gotten the error -
"Expression.Error: 7 arguments were passed to a function which expects between 1 and 2. Details: Pattern= Arguments=[List]"
My current query is the following -
let
Source = Web.BrowserContents("https://www.google.com/finance/quote/DAL:NYSE", "https://www.google.com/finance/quote/NI:NYSE", "https://www.google.com/finance/quote/DG:NYSE", "https://www.google.com/finance/quote/MSFT:NASDAQ", "https://www.google.com/finance/quote/BBY:NYSE", "https://www.google.com/finance/quote/GOOG:NASDAQ"),
#"Extracted Table From Html" = Html.Table(Source, {{"Ticker", ".PdOqHc"}, {"Price", "[jsname=""LXPcOd""]"}, {"Amount Change", ".ZYVHBb"}, {"Prev Close", ".gyFHrc:nth-last-child(9) > .P6K39c"}}, [RowSelector=".PdOqHc"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Ticker", type text}, {"Price", type text}, {"Amount Change", type text}, {"Prev Close", type text}})
in
#"Changed Type"
I believe the issue stems from having multiple web browser contents, but not sure how else to pull in multiple stocks. Thanks in advance
Hi @Syndicate_Admin ,
I am not sure I understand this. I am a new power apps user. By applying the query you provided, it results in the following:
Are there additional steps I should be taking after applying your query into the editor in order to get the ticker, price, amount change, and previous close data from the website? Thanks in advance
Share
Report
All responses (
Answers (
