Comment on Five features you probably didn't know on ZT

Hanan commented on 23 Jul 2014, 01:56 PM

Link to Excel works on all versions of ZT as long as your Excel is below 2013 version.

To get this operational, you need to right click on your Market Watch on Zerodha Trader and select ‘Link to Excel’. In that option, you have to select ‘All Items.’
Then you go to Excel and just do a paste or ‘Ctrl+V’. This will enable streaming quotes on Excel.

You need to make sure you have these settings within Excel:
1. Open Excel – Zerodha Trader supports Office 2007 and above.
2. Click the “Office Button” on the top left of your screen.
3. Click on “Excel Options” at the bottom of the new window.
4. In the new window, click on “Trust Center” on the side menu bar on the left.
5. On the right side, please click on an option called “Trust Center Settings”.
6. In the new window, click on “Trusted Locations”.
7. Click on “Add new Location” on the bottom of the window.
8. Browse and select the “NEST3” folder from your Program Files.
This will enable Excel to receive streaming quotes from Zerodha Trader.

Important: Make sure you have administrative rights on your computer. If you do not have administrative rights, please right click on the programs (both Excel and ZT) and choose “Run as Administrator.”

Do get in touch with us if you have any other questions or concerns.

View the full comment thread »