Traderji.com


Margin in excel

Discuss Margin in excel at the Risk & Money Management within the Traderji.com; Hi I am a composite edge client there is no margin calculator like Zerodha https://zerodha.com/margin-calculator/Futures/ ...


Go Back   Traderji.com > METHODS & STRATEGIES > Risk & Money Management


Risk & Money Management Discuss risk and money management techniques and methods to protect your trading capital.


Reply
 
Thread Tools
  #1  
Old 16th February 2015, 01:46 PM
Member
 
Join Date: Aug 2014
Posts: 77
Thanks: 40
Thanked 25 Times in 17 Posts
SIGNAL is on a distinguished road
Default Margin in excel

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


Advertisements

Reply With Quote
Advertisements
  #2  
Old 18th February 2015, 06:46 PM
Member
 
Join Date: Aug 2014
Posts: 77
Thanks: 40
Thanked 25 Times in 17 Posts
SIGNAL is on a distinguished road
Default Re: Margin in excel

.....
Reply With Quote
  #3  
Old 18th February 2015, 08:19 PM
Member
 
Join Date: Feb 2015
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
abyssis is on a distinguished road
Default Re: Margin in excel

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
Reply With Quote
  #4  
Old 19th February 2015, 01:15 AM
Member
 
Join Date: Jan 2012
Location: Navi Mumbai
Posts: 79
Thanks: 651
Thanked 50 Times in 27 Posts
pankajpari will become famous soon enough
Default Re: Margin in excel

Quote:
Originally Posted by SIGNAL View Post
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
Reply With Quote
The Following 5 Users Say Thank You to pankajpari For This Useful Post:
ameyanaik82 (19th February 2015), mastermind007 (19th February 2015), Relish (13th April 2015), SIGNAL (19th February 2015), swot9 (22nd February 2015)
  #5  
Old 3rd April 2015, 02:13 AM
Member
 
Join Date: Jan 2012
Location: Navi Mumbai
Posts: 79
Thanks: 651
Thanked 50 Times in 27 Posts
pankajpari will become famous soon enough
Default Re: Margin in excel

Quote:
Originally Posted by brightlikeme View Post
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,
Reply With Quote
  #6  
Old 13th April 2015, 08:17 PM
Member
 
Join Date: Oct 2011
Posts: 6
Thanks: 1
Thanked 3 Times in 1 Post
mprithu is on a distinguished road
Default 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
Reply With Quote
  #7  
Old 20th December 2015, 04:08 PM
Member
 
Join Date: Jan 2012
Location: Navi Mumbai
Posts: 79
Thanks: 651
Thanked 50 Times in 27 Posts
pankajpari will become famous soon enough
Default Re: Margin in excel

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
Reply With Quote
  #8  
Old 10th May 2016, 03:20 PM
Member
 
Join Date: Apr 2016
Posts: 145
Thanks: 0
Thanked 18 Times in 14 Posts
Hulu Girl is on a distinguished road
Default Re: Margin in excel

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

Advertisements

Reply With Quote
Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads for: Margin in excel
Thread Thread Starter Forum Replies Last Post
Can my Odin execute orders which i place in excel ?? can excel sync ths data ? abhisin111 Software 4 2nd February 2013 12:06 PM
Convert Excel RTDTo DDE or Import Live data from Excel barnzee AmiBroker 9 25th September 2009 04:35 PM
Margin plus and Margin method in ICICI Direct bcdeepak Brokers & Trading Platforms 1 8th April 2009 11:33 PM
Margin plus and Margin method in ICICI Direct bcdeepak Brokers & Trading Platforms 3 1st April 2009 05:43 PM
Daily margin and span margin and lot size ? jayamsuccess Derivatives 1 21st January 2008 04:33 PM


All times are GMT +5.5. The time now is 01:07 PM.

Indemnity, Disclaimer & Disclosure Notice:
By visiting Traderji.com you automatically indicate that you agree to our Forum Rules, Indemnity, Disclaimer & Disclosure Notice and General Content Disclaimer Notice and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum/site.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. You are recommended to make appropriate enquiries and seek appropriate advise before sending money, incurring any expenses, acting on recommendations or entering into any commitment in relation to any advertisement published here. Traderji.com does not vouch for any claims made by the advertisers of products and services. Traderji.com will not be held liable for any consequences in the event such claims are not honoured by the advertisers. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of any information by anybody mentioned anywhere on this site.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy or legality of any information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. Although we constantly delete all irrelevant content and/or SPAM, if you should find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © www.Traderji.com 2001 - , All rights reserved.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267