title: Excel query with dynamic cell value
body: <p>I need some help organizing what needs to be done.
  I have a list of stock ticker symbols and need to download data for each one of them to be displayed in a query table. Here's what it would look like even though it is a shorten version :</p>
  <p><a href="https://i.stack.imgur.com/RsCOw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RsCOw.png" alt="enter image description here" /></a></p>
  <p>I have built a url for a web query, but since my ticker changes for each request, I don't know how to have the query look into the ticker cell (C2, G2, etc...) I can do it if I name these cells, but do I have to name each one of them ? Is there a way to look at the cell value based on cell reference ?
  In the example below, it would have to be at
  Source = Json.Document(Web.Contents(meurl1 )),    where I would ad meurl1&amp;C2 or something like that.
  Any idea ?</p>
  <pre><code>let
  meurl1 = Excel.CurrentWorkbook(){[Name=&quot;meurl1&quot;]}[Content]{0}[Column1],
  Source = Json.Document(Web.Contents(meurl1 )),
  #&quot;Converted to Table&quot; = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
  #&quot;Expanded Column1&quot; = Table.ExpandRecordColumn(#&quot;Converted to Table&quot;, &quot;Column1&quot;, {&quot;date&quot;, &quot;close&quot;, &quot;high&quot;, &quot;low&quot;, &quot;open&quot;}, {&quot;Column1.date&quot;, &quot;Column1.close&quot;, &quot;Column1.high&quot;, &quot;Column1.low&quot;, &quot;Column1.open&quot;}),
  #&quot;Changed Type&quot; = Table.TransformColumnTypes(#&quot;Expanded Column1&quot;,{{&quot;Column1.date&quot;, type datetime}}),
  #&quot;Renamed Columns&quot; = Table.RenameColumns(#&quot;Changed Type&quot;,{{&quot;Column1.date&quot;, &quot;Date&quot;}, {&quot;Column1.close&quot;, &quot;Close&quot;}, {&quot;Column1.high&quot;, &quot;High&quot;}, {&quot;Column1.low&quot;, &quot;Low&quot;}, {&quot;Column1.open&quot;, &quot;Open&quot;}}),
  #&quot;Reordered Columns&quot; = Table.ReorderColumns(#&quot;Renamed Columns&quot;,{&quot;Date&quot;, &quot;Open&quot;, &quot;High&quot;, &quot;Low&quot;, &quot;Close&quot;}),
  #&quot;Sorted Rows&quot; = Table.Sort(#&quot;Reordered Columns&quot;,{{&quot;Date&quot;, Order.Descending}})
  </code></pre>
  <p>in</p>