NexusFi: Find Your Edge


Home Menu

 





PC-SPAN


Discussion in Options

Updated
      Top Posters
    1. looks_one Dudetooth with 218 posts (213 thanks)
    2. looks_two ron99 with 116 posts (55 thanks)
    3. looks_3 CafeGrande with 30 posts (4 thanks)
    4. looks_4 BlueRoo with 24 posts (5 thanks)
      Best Posters
    1. looks_one Dudetooth with 1 thanks per post
    2. looks_two SMCJB with 1 thanks per post
    3. looks_3 ron99 with 0.5 thanks per post
    4. looks_4 BlueRoo with 0.2 thanks per post
    1. trending_up 188,781 views
    2. thumb_up 317 thanks given
    3. group 75 followers
    1. forum 610 posts
    2. attach_file 159 attachments




 
Search this Thread

PC-SPAN

  #421 (permalink)
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785

FYI for some reason the delta that is on the XLS-SCAN Scan sheet, which comes from CME files, does not match the delta on CME's Daily Bulletin.

For example for Feb 16th the Daily Bulletin shows the delta for a June 1900 put as .044. But XLS-SPAN shows it as 4.61. I realize that .044 is the same as 4.40. But that is not the same as 4.61.

They both do have the same settlement price of 5.90.

Anybody know why?

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Deepmoney LLM
Elite Quantitative GenAI/LLM
Futures True Range Report
The Elite Circle
Exit Strategy
NinjaTrader
NexusFi Journal Challenge - April 2024
Feedback and Announcements
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
GFIs1 1 DAX trade per day journal
18 thanks
  #422 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ron99 View Post
FYI for some reason the delta that is on the XLS-SCAN Scan sheet, which comes from CME files, does not match the delta on CME's Daily Bulletin.

For example for Feb 16th the Daily Bulletin shows the delta for a June 1900 put as .044. But XLS-SPAN shows it as 4.61. I realize that .044 is the same as 4.40. But that is not the same as 4.61.

They both do have the same settlement price of 5.90.

Anybody know why?

From what I can gather, it is the difference between Current Delta and SPAN Composite Delta. SPAN Composite Delta is the base delta that is multiplied by a certain factor to get a "net delta" that CME uses in portfolio calculations. The risk arrays actually have both values, but for XLS-SPAN I decided to use the SPAN Composite Delta so that it would generate the same delta that you would see in PC-SPAN. The CME bulletins are posting the Current Delta.

Reply With Quote
Thanked by:
  #423 (permalink)
dkpmba
Toronto
 
Posts: 5 since Aug 2015
Thanks Given: 3
Thanks Received: 1


Dudetooth - Is there a way to add Theta to Track and Hist Data worksheets?

Reply With Quote
  #424 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


dkpmba View Post
Dudetooth - Is there a way to add Theta to Track and Hist Data worksheets?

It's already there, just select it from the drop-down of the header (cTheta). If that header is on the Track tab when you run the H-Track code it will be included on the Hist Data.



Cheers

Reply With Quote
  #425 (permalink)
dkpmba
Toronto
 
Posts: 5 since Aug 2015
Thanks Given: 3
Thanks Received: 1


Dudetooth View Post
It's already there, just select it from the drop-down of the header (cTheta). If that header is on the Track tab when you run the H-Track code it will be included on the Hist Data.



Cheers

Thanks, Dudetooth! I chime with others for this Great piece of work.

Reply With Quote
  #426 (permalink)
lawchan526
hong kong China
 
Posts: 1 since Apr 2017
Thanks Given: 0
Thanks Received: 0

I am trying to get margin requirement of commodity option. but i get the error message - attempted an unsupport operation when i tag to " New portfolio ". How can i solve it ?

Reply With Quote
  #427 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


lawchan526 View Post
I am trying to get margin requirement of commodity option. but i get the error message - attempted an unsupport operation when i tag to " New portfolio ". How can i solve it ?

Sorry, I've never seen that error before ... then again I don't use PC-SPAN too much. If you step me through the specifics of what you are doing in PC-SPAN I'll try to help.

Reply With Quote
  #428 (permalink)
 ItalianBmT 
Java/IN
 
Experience: Beginner
Platform: TOS
Trading: gold
Posts: 13 since Nov 2013
Thanks Given: 2
Thanks Received: 0

Pardon me as I am unfamiliar with programming. I am using the v05 file but I am unable to get the download macro from working correctly. I got the error that the download from the server failed. I tried out multiple dates.

Reply With Quote
  #429 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ItalianBmT View Post
Pardon me as I am unfamiliar with programming. I am using the v05 file but I am unable to get the download macro from working correctly. I got the error that the download from the server failed. I tried out multiple dates.

@ItalianBmT

Please try using XLS-SPAN v.05a ... it's easier for me to troubleshoot if we are on the same page.

Also, what dates did you try downloading? The only time I have seen the message that the download from the server failed was because a risk file for that date did not exist on CME or ICE.

Thanks

Reply With Quote
  #430 (permalink)
 ItalianBmT 
Java/IN
 
Experience: Beginner
Platform: TOS
Trading: gold
Posts: 13 since Nov 2013
Thanks Given: 2
Thanks Received: 0


I am using the version 5a and i had tested it across mutliple dates.

thanks in advance

Reply With Quote




Last Updated on September 23, 2021


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts