Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
First of all, thanks @Dudetooth for a great spreadsheet. This is a work of art, it helps a lot.
I am trying to figure out how to estimate the initial margin for ES spread, but can't figure out how to do it in the spreadsheet . I am using a @ron99 version of the PC-Span spreadsheet.
My steps:
1. Choose two strikes from the "Scanner"
2. Click send to the tracker
3.Highlight two rows with both strikes
4. Attach the same number under S1 column, e.g 1 on both
5. Press track spread
I have had few attempts to estimate the initial margin for the following contracts in the spreadsheet:
I have got $210 as for initial margin per one spread as for August 2, 2016.
I have 20160802 in both cells designed to track historic data.
Secondly, i have downloaded a Ron's version of a PC-Span spreadsheet where ES-mini Weekly Options are included in "required format" list by defaultt, although what symbols should i type in the scanner paget so that it would scan a ES-mini weekly options?
I am typing
Futures month: EW3
Min DTE:20
Max DTE:140
Min value: $20
Max Delta: 10
Min ROI: 2%
I am looking for EW3V6 option ( expires on 31 October 2016 )
Eventually, the result would not come up?
Am i doing something wrong here?
Are you looking to scan for EW3V6 options are you looking to find a particular one? I don't have Ron's version handy, but I believe that there is a cell for a date on the Scan tab as well ... if you are scanning and you don't have that date correct you might not get what you are looking for.
Did you get any options? I did it using your parameters and I only got 5 options. EW3V6 1880-1900. That was because all lower strikes were lower than 2% ROI.
Lower your Min ROI and you will get more options.
Also make sure you have 20160802 in cell G1.
The Futures symbol (column A) would need to be EW3.
Futures are lower today. Zaner360 margin calculator showed me a $361 for this spread. I have heard that margin calculators ,and in particular on Zaner360, are not the most accurate to estimate the initial margin, however i'm really curios if margin increased from yesterday settlement more than 1.5 times...
Well, i am literally typing EW1 in scanner. I have added all of EW symbols ( e.g. EW1- EW4 )... and it worked. I am guessing i have typed something else out there.
Some brokerages charge SPAN IM + the value of the position, or Total IM. Yesterday's Total IM for that spread was $340 ($210 SPAN IM + $130 value of spread).
The margin i have got from Zaner360 is based on the contract that expires on 16 December. The margin i was referring to is not for EW3 options, but for ESZ6 contract.
Currently for the spread -1 OESZ6 P1660 and +2 OESZ6 P1410 the initial margin is $340. Net option value is $130 respectively. Therefore the spreadsheet shows a SPAN margin $210,less net option value.
You asked what options did i get from the spreadsheet.
The thing is, i am only getting EW1 and EW4 options. I have neither EW2 nor EW3 options. I don't know why is that.
I can not make a screenshot since i am using windows on a Mac and there is no PrtScreen button on the keyboard.
I think the version of XLS-SPAN of mine you are using was created before the EW3 contract started being used. You can either download Dudetooth's latest version or you can request me to post my current version which works for EW3.