using power bi to perform a web query based on an excel cell

[se2]

Hi,

Can I use a named range in excel or a table to define a stock symbol and then incoporate this into a webquery using power bi?

A good example would be https://finviz.com/quote.ashx?t=INTC&p=d

where INTC would be in a cell with a named range or in a table?  I can't quite figure out how to combine a web query with a named range.

Thank you SE

[Anonymous]

Hi @se2 ,

You can add a custom column to connect the base URL of a web query with a ticker symbol column

“https://finviz.com/quote.ashx?t=” & [YourColumnName] & “&p=d”

"[YourColumnName]" is replaced with the actual name of the column that contains the ticker symbol.

Then use the Web data source in Power BI to extract data for each URL.

Below is the official link:

Connect to a webpage from Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[se2]

Thank you for this.  But, I don't understand how to add in a particular ticker symbol?