Excel Expert Required

[thefalleng2]

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=sharing

I need get done quickly.PM me with offers,will pay in BTC.

[1714792540]

1714792540

[1714792540]

1714792540

[1714792540]

1714792540

[1714792540]

1714792540

[1714792540]

1714792540

[1714792540]

1714792540

[micaman]

I have it done in php/jquery/mysql. Not that exact format, but it's an integration of 10 different exchanges with public APIs.
With a simple implementation of datatables I have a searchable/sortable table with all the info merged.
As you said not all APIs offer the same info, so I have blank spots. There's also a problem with some exchanges which only allow a certain number of updates per day or hour, so I do it manually. Anyway if it interests you send me a PM.

[statdude]

I can do this quickly and easily.
PM me your offer.

[expert4knowledge]

Hello, I am a freelancer excel developer, please send pm to me for more discussions.

[iluvpie60]

All you gotta do is open excel, click on Data tab, click on "From Web", type in the exchange address, and click and select/drag and drop what you want. then once you are in that screen you just click on the "->" arrow in the yellow box and it will import whatever it is next to. you might need to do a bit of googling if you want to get more advanced but this should be exactly what you are looking for.

you can litterally do this yourself, its just a bunch of cell A / cell B to figure out differences and stuff after you manually set it up and it will refresh.

all these other people who are saying they program and develop and whatever have no idea what they are talking about and are liars and trying to get paid, you are litterally asking for what i described above and i will save you the money by letting you know you can do it yourself for free in less than 20 minutes

enjoy!

[thefalleng2]

Hey guys this has been completed long time ago.I forgot to lock the thread.

[expert4knowledge]

Hey guys this has been completed long time ago.I forgot to lock the thread.

No  problem, I hope we can work in future.