Excel Power Query
R1000 ZAR
Paid on delivery
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 [url removed, login to view] 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 [url removed, login to view] an example of the query that I want to be able to update:
let
Source = [url removed, login to view]([url removed, login to view]("[url removed, login to view]")),
Data = Source[Data],
#"Converted to Table" = [url removed, login to view](Data, [url removed, login to view](), null, null, [url removed, login to view]),
#"Expanded Column1" = [url removed, login to view](#"Converted to Table", "Column1", {"time", "close", "high", "low", "open", "volumefrom", "volumeto"}, {"[url removed, login to view]", "[url removed, login to view]", "[url removed, login to view]", "[url removed, login to view]", "[url removed, login to view]", "[url removed, login to view]", "[url removed, login to view]"})
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.
Project ID: #16362847