Forum Discussion
Need help with Power Query web/URL
I have the below Power Query which results in a table with financial data from Yahoo Finance for 3 specific securities (Microsoft, Apple, and Disney in this case). I want to build a solution which lo...
Thank very much lbendlin,
Can I use a named range in my Excel to hold the symbol list and then reference that named range in the Power Query code? I'm still fairly new with M-syntax/code.
How can I use the set the variable "Symbols" to equal the named range "Secs"?
Or maybe I should refer to the named range in the Text.Combine part??
I tried various syntax, but all resulted in errors.
Thank you very much in advance.
Roland
lbendlin
Super User
Super UserCan I use a named range in my Excel The preferred way is to use a table. Then use Text.Combine on the relevant column of that table source.