Zerodha - Number One Discount Broker in India
- Thread starter Traderji
- Start date
If you're looking for RTD from terminal try Tracerbullet utility, no need of excel.
http://www.traderji.com/intraday/93428-nestrtd-nest-now-amibroker-feeder-free-open-source-gpl.html
http://www.traderji.com/intraday/93428-nestrtd-nest-now-amibroker-feeder-free-open-source-gpl.html
Brill, all of Zerodha's clients are enabled to send quotes to Excel by using the "Link to Excel" facility on ZT.
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."
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."
