Scrape Bid price and volume, Ask price and volume from Binance pair (JSON) into Excel
€8-30 EUR
In Progress
Posted about 5 years ago
€8-30 EUR
Paid on delivery
Hi All,
This should be an easy one for someone who knows what they're doing
The below screenshot was taken from [login to view URL]
The information I'm trying to scrape is the Bid and Ask prices (0.00000027 and 0.00000028 respectively in this case) and the total volumes (253.29839454 and 255.61541656 respectively) preferably within excel's VBA environment so I can manipulate the information further quite easily ... I've tried creating an internet explorer object to simulate the and scrape that way but the site doesn't support Internet Explorer. I've tried HTTP requests to get the DOM and parse it that way also but after navigating to the text elements containing the information, I was getting null returns (I believe it's because these are AJAX pages, using JSON but my knowledge here is quite limited) and this is where my limited knowledge of coding comes to an end ideally, if I could get these values within VBA by referencing something within the reference library, and maybe creating a function/functions for these value, that would be great!
Kind regards,
Jeremy
Hi, I am a Full-Time developer who have specialized in Web Scraping using Python and can start your project immediately. I have scraped many sites and built web bots using python. My skills and experience meet your demand. I will provide you quality work and hope Long-Term with you. For more of your project, let's discuss over chat.