Adding Epochtime variable in Excel query

[b0unce]

Hello,

I want to create a connection between Yahoo Finance certain report to my Excel spreadsheet and ran into one problem.
My source code in advance editor seems like this:

...
Source = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/^NDX?period1=1623306860&period2=1654848352&interval=1d&events=history&includeAdjustedClose=true"),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),
...

What I need to do is to change fixed value of period2 in this code so that it shows current Epoch time value. I have the formula for Epoch time: Duration.TotalSeconds(DateTime.LocalNow() - #datetime(1970,1,1,0,0,0)))
It works on separate table, but I cannot make it work in my initial source file. Could anyone please help?
Thank you in advance!

 

[John_w]

    p2 = Number.ToText(Number.Round(Duration.TotalSeconds(DateTimeZone.UtcNow() - DateTimeZone.FromText("1970-01-01T00:00:00Z")))),

    URL = Text.Combine({"https://query1.finance.yahoo.com/v7/finance/download/^NDX?period1=1623306860&period2=",p2,"&interval=1d&events=history&includeAdjustedClose=true"}),

And use URL as the Web.Contents argument.

 

[b0unce]

    p2 = Number.ToText(Number.Round(Duration.TotalSeconds(DateTimeZone.UtcNow() - DateTimeZone.FromText("1970-01-01T00:00:00Z")))),

    URL = Text.Combine({"https://query1.finance.yahoo.com/v7/finance/download/^NDX?period1=1623306860&period2=",p2,"&interval=1d&events=history&includeAdjustedClose=true"}),

And use URL as the Web.Contents argument.

Thank you very much!