I'm looking for someone who is an Excel expert and is familiar with importing data from the internet to update on a continuous basis. It would also be a bonus if you are familiar with Bitcoin and other crypto currencies.
What I am looking for is a constant feed from numerous crypto currency exchanges into a website so I can see the different prices across several exchanges at once. This would be for several different currencies. The format of the spreadsheet is already laid out, with the currencies I want and the exchanges already given. I would like the buy and sell prices for each currency on each exchange, as well as the volume listed. IMPORTANT: Not all currencies are listed on each exchange, so there will be some blank spaces, which is fine...just leave them blank.
Also, if you can, include a formula to highlight anytime there is a price difference of at least 15% for a given currency between 2 exchanges. You could have this highlight off to the right of the prices, or just have the price cells be highlighted. I'll give you freedom on how you can show this.
I would like this to be able to update current prices. Either to have it continuously update, or to press a button to update prices...whichever is easier for you and for the spreadsheet.
EXAMPLE:So basically if you go to
https://mcxnow.com/exchange/WDC for example, scroll down and on the left side there is a "BTC Price per WDC" for both the buy and sell options. I'm looking to have those prices update in the Excel spreadsheet whenever the price on the site changes.
This is the spread sheet:
https://docs.google.com/spreadsheets/d/1GziHW0CE8eAfbcRmU0SWzqL6zhUeInH9m9j5DWUteAs/edit?usp=sharingI need get done quickly.PM me with offers,will pay in BTC.