Get the first prize from binance to Google sheets: A step-by-step instructions

Are you a cryptocurrency Enthusiaste or A Dealer Who is Looking for Ways to automatic data Analysis Using Google sheets and Binance API? In this article we will guide you through the process of receiving the first prize from the p2p page of binance in google sheets.

Requirements:

• You have a binance account with activated P2P Trade.

• You have set up a Google Sheet to Receive Data From Binance.

• The « ImportXML » Function is not available in Google Sheets. Therefore, we will use a Problem bypass with the « Json » Function and Manuality Analyze the Answer.

Step 1: Analyze the Answer

The P2P Page from Binance Returns an XML Response That Contains the Price Information. To Analyze This Data In Google Sheets, We have to:

• Use the « json.stringy () ‘method to convert the xml string into a json object.

• Then use the function json.parse () 'to analyze the json object.

Here is the code snippet:

Python

Import json

Define the Binance -Api endpoint -Eurl

API_url = " + "UZS"

Analyze the xml response to a json object

json_data = json.loads (api_url)

Step 2: Extract the first prize

As soon as we have the json object, we have to extract the first prize. Since json.parse () Returns an empty string if the input is not valid, we will use a simple loop to enforce the data and find the first value that corresponds to our search criteria.

Here is the code snippet:

`Python

Define the search term (first prize in this case)

Search_term = "price"

Initialize the Price Variable

first_price = none

By the Json Object Iterieren to Find the Right Price

For the key, value in json_data.items ():

If Isstance (Value, Str) and search_term.lower () in Value.lower ()::

Update the First Price Variable with the Corresponding Price

If first_price none or float (value)

First_price = float (value)

If we have found a match, give the price to google sheets

If first_price is not:

Print (f "price: {first_price}")

Step 3: Edition to Google Sheets

In order to output the first price for Google Leaves, you have to create an array with the inexpensive and then use « importxml » or a similar method in Google sheets to upload this data.

Here is an Example of how you can do this:

`Python

Import json

Define the Binance -Api endpoint -Eurl

API_url = " + "UZS"

Analyze the xml response to a json object

json_data = json.loads (api_url)

Extract the first prize from the json object

Search_term = "price"

first_price = none

By the Json Object Iterieren to Find the Right Price

For the key, value in json_data.items ():

If Isstance (Value, Str) and search_term.lower () in Value.lower ()::

Update the First Price Variable with the Corresponding Price

If first_price none or float (value)

First_price = float (value)

Create a New Line Array with the Inexpensive

price_array = [first_price]

Download the Data Using ImportXML in Google Sheets

importxml_value = "your_binaryseafd_api_url_here"

ImportXML_OUTPUT = F "Your_binaryseAfd_Api_url_here? Action = Import Data & Json = {importxml_value}"

Print (ImportXML_OUTPUT)

Example Application:

Let us assume that you have a binance -api endpoint -url that returns an xml response like it:

`XML

You can change the above code -Snippet to extract the first price from the XML Answer and output it as follows at Google sheets as follows:

• Replace API_url with your binance -api endpoint -url.

• Update the Variable search_term, which corresponds to the value of the » price « element in the XML Answer.

DRIVEN DRIVEN TOKENOMICS PARADIGM PROJECTS