Zerodha Part 2

[Brill]

Yes, you can link ZT market watch to Excel to get live streaming quotes. To view quotes in Excel, 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' in the first cell on a blank sheet. This will enable streaming quotes on Excel. You can add your own macros to this.

Settings within Excel:
1. Open Excel - ZT supports Office 2007 and above - but it may work with Excel 2003, so you'll have to check it out yourself and give us feedback.
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 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.

Cheers!
Hari

excel 2003, on pressing ctrl+v in excel all the cells are giving #NA error.
Can you help me to solve this.

thanks/Brill.

 

[Zerodha]

Zerodha,

That I understand bro BUT what about cheque and PAN etc documents because while opening the Commodities Account with you around 4-6 months back, he has already given all the relevant documents and these days he is indulged in active trading with Zerodha, so please tell me whether he is required to provide the same documents ALONG WITH a cheque of Rs 200/= favouring Zerodha OR simply download a form and fill that and send to Zerodha.

Waiting to hear from you ........

shekharz

Yes Shekhar,

All the documents would be required once again, self attested.. The reason being regulators of equity/commodity are different and they are very strict about documenation.. ..

 

[Zerodha]

Hi, can i sell options intraday, without putting margin ?? If yes whats the process, Shall i choose the Mis or nrml order??

To sell options, you need to have the initial margin.. For intraday, if you are using MIS as the product type you will need only 40% of the overnight margins..

But the margin has to be there in the account

 

[Zerodha]

excel 2003, on pressing ctrl+v in excel all the cells are giving #NA error.
Can you help me to solve this.

thanks/Brill.

Guess it is an issue with your version of excel 2003.. If you can upgrade the excel, it should start working..

 

[timepass]

Yes Shekhar,

All the documents would be required once again, self attested.. The reason being regulators of equity/commodity are different and they are very strict about documenation.. ..

and In Person verification also ??

 

[shekharz]

Yes Shekhar,

All the documents would be required once again, self attested.. The reason being regulators of equity/commodity are different and they are very strict about documenation.. ..

and In Person verification also ??

And what about a cheque of Rs 200/= favouring Zerodha AS WELL AS the procedure for In Person Verification because it has already been done once at that time ???

Please clear ........

shekharz

 

[Zerodha]

And what about a cheque of Rs 200/= favouring Zerodha AS WELL AS the procedure for In Person Verification because it has already been done once at that time ???

Please clear ........

shekharz

IPV will not be required again, but the account opening cheque of Rs 200 would be required..

 

[Zerodha]

MCX-SX most likely to go live on Feb 11th..

Is competition good??
Yes it is , NSE will send brokers trade files almost 90 minutes earlier. So you should start receiving your contract notes much earlier from today.

 

[shekharz]

IPV will not be required again, but the account opening cheque of Rs 200 would be required..

OK, got it, will inform him and he will act accordingly, most probably this week or next .......

Thanks buddy

 

[Mihir Bijur]

You can use Microsoft Office 2013 Preview for Free. Sign up here. If you only want Excel, here.

Let me know how it goes...