Question on Zerodha pi technical


1.In Zerodha pi, I can only get access to " export chart to excel for the latest previous day’s chart ". How can I get access to real time data transfer from trading software to excel. Any softwares to help on that?

  1. If I have a trading statergy, only on looking at excel I can make decisions on seeing the appropriate prices and technical data. "Along with realtime technical data in excel from software source. How can I automate excel to make automatic trading decisions?