PowerQuery在URL中使用单元格值 [英] PowerQuery use a cell values in a URL

问题描述

我有以下PowerQuery代码.它将从雅虎财务中的MSFT收集一些数据.

I have the following PowerQuery code. Which collects some data from MSFT in yahoo finance.

例如，我有一个单元格A1，我想放置MSFT，GOOG或其他符号.如何更改它，以便在更改A1时将自动重新下载新符号?

I have a cell A1 for example which I would like to put MSFT, GOOG or another symbol. How can I change it so that when I change A1 it will automatically redownload for the new symbol?

let  Quelle = Web.Page(Web.Contents("https://finance.yahoo.com/q/bs?s=MSFT+Balance+Sheet&annual")),

    Data = Quelle{1}[Data],

    FirstRowHeader = Table.PromoteHeaders(Data)

in  FirstRowHeader

使用； $A$1无效.

https://finance.yahoo.com/q/bs?s=$A$1+Balance+Sheet&annual

推荐答案

如

As explained in the answer to this question, you can load in a cell value if you make it a named range.

第一步是为单元格A1命名.我们将其命名为Ticker.您可以通过在选择单元格时在左上角的框中键入名称来命名它

The first step is to name your cell A1. Let's name it Ticker. You can name it by typing in the name in the upper left box when the cell is selected

然后您的查询将如下所示:

Then your query will look like this:

let
    Ticker = Excel.CurrentWorkbook(){[Name="Ticker"]}[Content]{0}[Column1],
    Quelle = Web.Page(Web.Contents("https://finance.yahoo.com/q/bs?s="&Ticker&"+Balance+Sheet&annual")),
    Data = Quelle{1}[Data],
    FirstRowHeader = Table.PromoteHeaders(Data)
in  FirstRowHeader

这篇关于PowerQuery在URL中使用单元格值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！