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:

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.

Skills: .NET, Excel, JSON, SQL

See more: refresh web query tables excel, vba excel web query, excel vba query as400 connection string, 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, cnet excel working pivot tables, word excel power

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

Project ID: #16362847

Awarded to:

vaidyag

Hired by the Employer

R1000 ZAR in 3 days
(3 Reviews)
2.3