Comment on Code your Technical Analysis strategy

Hanan commented on 09 Oct 2013, 04:24 AM

Yes, you can. We have a “Link to Excel” feature available on Zerodha Trader which you can use to get intraday, real-time data onto Excel. What you do with it in Excel after that is up to you.
End of day data is available on Yahoo or Google for free and you can also get it from the exchange website.

To use the “Link to Excel” facility, please do this:
First you need to right click on your Market Watch on ZT 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.

Settings within Excel:
1. Open Excel – ZT supports Office 2007 and above. You can try other versions of Excel, but the methodology is as described below.
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 left-hand side menu bar.
5. On the right-hand 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 “Omnesys” folder from your Program Files.This will enable Excel to receive streaming quotes from ZT.
Handy Tip: If it does not work, right click on ZT and on the Excel and run both these programs as ‘Administrator.’

View the full comment thread »