I have a small project in Excel Power Query. I want to reference a spread sheet for parameters to build the URL for a web query in Data -> From Web, or the Advanced Query Editor. I'm almost getting it right myself, but need help. The URL I want to query is [login to view URL] and variables in this example are histominute, BTC, USDT, 10 and binance. I want to be able to refresh the data easily, using standard Excel [login to view URL] an example of the query that I want to be able to update:
let
Source = [login to view URL]([login to view URL]("[login to view URL]")),
Data = Source[Data],
#"Converted to Table" = [login to view URL](Data, [login to view URL](), null, null, [login to view URL]),
#"Expanded Column1" = [login to view URL](#"Converted to Table", "Column1", {"time", "close", "high", "low", "open", "volumefrom", "volumeto"}, {"[login to view URL]", "[login to view URL]", "[login to view URL]", "[login to view URL]", "[login to view URL]", "[login to view URL]", "[login to view URL]"})
in
#"Expanded Column1"
Lastly, I would like to have the date converted from Unix to Excel format using this formula (1516536000/86400)+25569+(2/24)
Please note: I do not want it as a macro enabled Excel file, it should just use tables and Power Query.