Excel Power Query

In Progress Posted 6 years ago Paid on delivery
In Progress 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.

.NET Excel JSON SQL

Project ID: #16362847

About the project

1 proposal Remote project Active 6 years ago

Awarded to:

vaidyag

Hired by the Employer

R1000 ZAR in 3 days
(3 Reviews)
2.3