I am trying to import the following api json in excel table.
http://api.manilainvestor.com/v1/stocks/hdata/dnl
Can anyone help me develop the code for the macro.

Data must be separated in these coloumns.

Date | High | Low | Open | Close | Volume


Thank you.