Problem getting web query onto work sheet

I am having trouble getting this web page to load onto a work sheet the way i want it to,, what happens is all the data loads onto just one row when I want it to look like it does when windows opens the page which is all data on a separate row

is it possible for Excel to read this sort of query and place the data on different rows and then update

thanks

https://www.nicehash.com/api?method=...ent&location=0

Thank's for looking ,,,

Do you not get the printout shown below from my URL? you should because it is a public data feed no need to sign up ect


I have tried the method you said it used to work but the site changed and now the data contained in the tables on the site home page does not load into Excel any more even when you press the arrow for the whole page the rest of the page loads in but not the table of numbers

this below is now the only data I can get from the site, I can get Excel to load it in and update every few minutes but all that data loads onto just one row and I cannot extract the figures I want.

I need to extract 11 certain figures out of that data relative to algo's 1 to 11


{"result":{"stats":[{"profitability_above_ltc":"17.70","price":"0.1556","profitability_ltc":"0.1322","algo":0,"speed":"36.62957100"},{"price":"0.0079","profitability_btc":"0.0083","profitability_above_btc":"-4.00","algo":1,"speed":"2162055.60500000"},{"profitability_above_ltc":"80.03","price":"0.4761","profitability_ltc":"0.1322","algo":2,"speed":"0.00094800"},{"profitability_above_ltc":"1908.51","price":"0.3124","profitability_ltc":"0.1322","algo":3,"speed":"11.94475303"},{"profitability_above_ltc":"1497.60","price":"0.3250","profitability_ltc":"0.1322","algo":4,"speed":"0.30266700"},{"profitability_above_ltc":"509.97","price":"0.0016","profitability_ltc":"0.1322","algo":5,"speed":"0.21887500"},{"profitability_above_ltc":"-100.00","price":"0.0000","profitability_ltc":"0.1322","algo":6,"speed":"0.00000000"},{"profitability_above_ltc":"-100.00","price":"0.0000","profitability_ltc":"0.1322","algo":7,"speed":"0.00000000"},{"profitability_above_ltc":"1748.51","price":"6.1102","profitability_ltc":"0.1322","algo":8,"speed":"0.01694813"},{"profitability_above_ltc":"273.14","price":"0.2819","profitability_ltc":"0.1322","algo":9,"speed":"0.08433700"},{"profitability_above_ltc":"533.04","price":"0.0062","profitability_ltc":"0.1322","algo":10,"speed":"0.00000000"},{"profitability_above_ltc":"849.65","price":"0.1932","profitability_ltc":"0.1322","algo":11,"speed":"0.01822800"},{"profitability_above_ltc":"902.59","price":"0.2651","profitability_ltc":"0.1322","algo":12,"speed":"43.50111100"},{"profitability_above_ltc":"-100.00","price":"0.0004","profitability_ltc":"0.1322","algo":13,"speed":"0.00002056"},{"profitability_above_ltc":"2206.37","price":"0.4356","profitability_ltc":"0.1322","algo":14,"speed":"11.71580056"},{"profitability_above_ltc":"2206.37","price":"3.0495","profitability_ltc":"0.1322","algo":100,"speed":"1.26366376"}]},"method":"stats.global.current"}

Doverman thank you for your thoughts,, I can now see a little light ahead,,,,

However can I let you know that this web query has to update and reload with every 5 minutes so that my macro can then record the different values onto a data base.. I feel therefore that you method would not be automated,, if possible I need Excel to arrange the data in rows on its own,, my macro can then record the new data every 5 minutes

cheers

How about:

Please Login or Register  to view this content.

This works great on a new workbook thanks very much ,,, The only issue i am having is :- when I add your code to my existing macro I cannot get it to write to the sheet I want,,,, I have been changing the "Sheets(1).Cells" part of your code for "Sheets (whatever number sheet I want).Cells" but it does not seem to listen and puts the data on a different sheet

I will persevere

thanks again

Change the number to the name of the sheet you're after

Yeah got it thank's

That is just so totally solved

thanks

Glad it got you sorted

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.