This will connect Zerodha Pi to excel and save the market watch data in an excel sheet to the location \Zerodha\Pi\LinkExcel\Nifty50 MW.xlsx. Now right click on the market watch and click LINK TO EXCEL (Ctrl E). So please click on the Trading Symbol column header to sort it alphabetically. Now the MarketWatch needs to be sorted by symbol name. My Nifty50 MW (my given name for this MarketWatch) is open. It will load all Nifty50 stocks in your MarketWatch. Once Pi is logged in open the Nifty50 all scrips market watch by clicking File –> Predefined WorkSpace –> NSE –> Nifty 50. Steps involved in connecting Zerodha Pi to Excelįirst login to your Zerodha Pi terminal. If you dont have Zerodha Pi, you can apply for a Zerodha account by clicking HERE. A few days back I have written How To Create Intraday Trading Excel Sheet From Sharekhan TradeTiger? That post has got very good response from my readers and I have got many requests from my Zerodha clients for posting to know how on creating simiter excel trading system connecting Zerodha Pi to excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |