Excel linked trading

Hi,

I would want to link marketwatch to Excel with l;ive price updates. It used to happen with NEST trader earlier and worked quite well.

Is there a way to do this with Zerodha? I know they have APIs etc but not sure how to work with them and link live prices in Excel. If anyone has a working model, it would be of great help.

I have tried to do this in Pi, but the “Link to Excel” option just creates a blank Excel file in \LinkExcel\Default MW.xlsx