=arrayformula((B2:B/1000)/86400+date(1970,1,1))ī2:B reflects the column in which the timestamp is located, so just modify it to match the column in which you want to convert timestamps. To convert these timestamps to a human readable date, set your data destination to cell B1, and add the following formula to cell A2: Part 3: Handle Binance Timestampsįor most endpoints, Binance returns dates as UNIX timestamps. This will print out your complete API URL, which you can then copy/paste into the request URL field. To easily convert from a preset request to a custom API URL, tick the Add request URL box before running your preset request (under Output options). To create a custom request, add the complete URL into the request URL field. A moment later you’ll see price change stats for all currency pairs in your sheet.Īlternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the parameters and endpoints shown in Binance’s API documentation.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |