Margin in excel

[SIGNAL]

Hi I am a composite edge client
there is no margin calculator like Zerodha https://zerodha.com/margin-calculator/Futures/
can anybody help me prepare an excel sheet where i can calculate MIS and NRML margin ,the excel sheet should pull price data from webquery.
Here is margin requirements of composite edge http://www.compositedge.com/trading/margins.php

SIGNAL

 

[SIGNAL]

.....:sos:

 

[abyssis]

ya same here and why so less scrips are availabe for margin in nse .EQ series of nse has more than 1300 scrips .why so less scrips with margin for intraday

 

[pankajpari]

Hi I am a composite edge client
there is no margin calculator like Zerodha https://zerodha.com/margin-calculator/Futures/
can anybody help me prepare an excel sheet where i can calculate MIS and NRML margin ,the excel sheet should pull price data from webquery.
Here is margin requirements of composite edge http://www.compositedge.com/trading/margins.php

SIGNAL

Hi,
Pls find below the link for the process to pull the margin requirement from a web query to an excel.

With this there is no need to do any Span Margin calculation, just link the cells in this file to your working file.

This excel will give the Lot Size as well as the Span Margin requirement for the day. Though this margin requirement is for 5paise.com, the margin for other brokers should be more or less same.

The excel will refresh every time the file is opened and will pull the latest margin requirement for the day.

You can link the data in the cells for the respective scrips to your working file.

Hope this meets your requirement.


http://www. 4 shared . com/file/I011Ray6ce/Span_Margin_Requirement_in_Exc.html

(pls remove the spaces before pasting the link in the address bar.)

Regards,

Pankaj

 

[pankajpari]

i hope the Link Worked , Its a Broken Link,

The link is working...... as mentioned by me earlier, you will need to remove the spaces and then paste the same in the address bar.

Regards,

 

[mprithu]

Real Time Price Update in excel

Pankaj Ji Thanks for the detailed explanation. Is there any way that we can get real time price update (only) on Excel through Web Query? I have been trying to do this but I am unable to link the website from which I can import the data. Please help. Thanks

 

[pankajpari]

Hi mprithu,
For that you ned access to any Trading Terminal similar to NSE NOW, Zerodha Trader or Sharekhan's TradeTiger. Most of these terminals have a "Link to Excel" option. First you need to call their call centre and then get this facility activated. The call centre oficers will also help you with the step by step process.

Once you paste the Market Watch on your excel, you can link the same with your system or put any formulae / indicators. During the market hours you will get the Real Time updates of the prices as well as the indicators.

Regards,

Happy Trading

 

[Hulu Girl]

I'm still trying to wrap my head around the basics of margins, So i have to try your calculator. Thanks for sharing.