In Progress

Excel Power Query

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:


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]"})


#"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.

Skills: .NET, Excel, JSON, SQL

See more: refresh web query tables excel, vba excel web query, excel vba query as400 connection string, power query tutorial pdf, power query mac, power query wiki, power query vs powerpivot, power query tutorial, power query excel 2016 tutorial, how to use power query in excel 2016, power query examples, excel web query secure site, excel web query captcha, using excel web query fill web form, excel Web query, excel refresh query data moves, excel web query logging, vba refresh excel web query, excel vba copy cell contents paste internet explorer, excel web query post

About the Employer:
( 4 reviews ) Bryanston, South Africa

Project ID: #16362847

Awarded to:


Hired by the Employer

R1000 ZAR in 3 days
(3 Reviews)