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

  #321 (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


djay View Post
Hi,

PC-SPAN I am talking abt is the CME application.

I actually trade in India on NSE. The Exchange does provide the span file, but there is no authentic source for margin amount. What broker says you pay.

So I am trying to decode the span file using PC-SPAN but it doesnt show me the margin amount

@djay,

I have not been able to get the latest version of PC-SPAN to work properly so I'm not positive, but from the picture you included it looks like you may not have loaded any positions into your portfolio.

Check out the CME's User Guide for PC-SPAN: https://www.cmegroup.com/confluence/display/pubspan/Use+PC-SPAN

They are not the most user-friendly, but they will walk you through the process.

Hope this helps.

Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Build trailing stop for micro index(s)
Psychology and Money Management
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
ZombieSqueeze
Platforms and Indicators
Are there any eval firms that allow you to sink to your …
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
22 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
20 thanks
  #322 (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


Dudetooth View Post
This should take care of those issues:
1. Go to the HistPivot Tab
2. Click cell A1 ... you should see the PivotTable Fields window open on the right side of the tab (if not click Analyze under the PivotTable Tools tab at the very top right of the Excel window ... click Field List on the far right)
3. In the bottom right of the PivotTable Fields under values, click on Average of Pos Net Value and select Value Field Settings
4. In the new window select Sum and click OK
5. Repeat for Pos IM and Current Pos P/L

The 0 you saw at AC3 is normal. When calculating a spread only one line should have Pos Net Value, Pos IM and Current Pos P/L values ... they are the combined values for the spread and are only populated on one line. For some reason the code adds 0 for some of those on the first day of the Historical Tracking, but then blank afterwards.

I hope this makes sense.

I just updated the attachment in the prior post if you don't want to bother with these instructions.

Reply With Quote
  #323 (permalink)
arno
Tallinn Estonia
 
Posts: 1 since Dec 2014
Thanks Given: 4
Thanks Received: 1


Hi @Dudetooth

There's a small bug in risk module line 198 that prevents scanning. "Scanner!G1" has a missing 'c' character.

Regards

Arno

Reply With Quote
Thanked by:
  #324 (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

The value for grain options is off on this new version.

Here is what I get with my old version (a couple of versions before the last one prior to yesterday) The value is correct at $25. Settlement price was 0.5. Or 4 ticks. 4/8.



Here is what I get with the new version. I also included PC-SPAN.



Any ideas what is happening?
Thanks
Ron

Started this thread Reply With Quote
  #325 (permalink)
djay
Hyderabad
 
Posts: 3 since Jan 2015
Thanks Given: 2
Thanks Received: 0

@Dudetooth, Thank you for responding back. I am trying to get the margin requirement of a particular futures contract without position. I am hoping I will find a way to get that in PC-SPAN.

Apart from that, I am also unable to create Portfolio in PC-SPAN. I get a error "Attempted an unsupported operation" when I tab into Positions tab in "New Portfolio"

Reply With Quote
  #326 (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
Any ideas what is happening?

Juggling versions and a small fix for the grain prices was missed ... I thought that I was modifying the latest XLS-SPAN.

I can get a fix to take care of that along with the error @arno found in a day or so.

Reply With Quote
Thanked by:
  #327 (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


djay View Post
@Dudetooth, Thank you for responding back. I am trying to get the margin requirement of a particular futures contract without position. I am hoping I will find a way to get that in PC-SPAN.

Apart from that, I am also unable to create Portfolio in PC-SPAN. I get a error "Attempted an unsupported operation" when I tab into Positions tab in "New Portfolio"

@djay,

That is the same error I've been getting. Either their latest version has a bug, or they changed something in the procedures that I'm missing.

You may want to try uninstalling and reverting back to the previous version.

Reply With Quote
Thanked by:
  #328 (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

I didn't want to keep making new posts for the fixes, but I can no longer edit my previous post and I can't manage attachments on the quick summary post. If there is a better way to manage the file please let me know.

Here is the fixed version of 04c:
-Risk module date reference for Scanner
-Grain price

Attached Files
Elite Membership required to download: XLS-SPAN (04c).xls
Reply With Quote
Thanked by:
  #329 (permalink)
CafeGrande
St Paul, MN, USA
 
Posts: 200 since Jan 2014
Thanks Given: 131
Thanks Received: 207


Dudetooth View Post
I didn't want to keep making new posts for the fixes, but I can no longer edit my previous post and I can't manage attachments on the quick summary post. If there is a better way to manage the file please let me know.

Here is the fixed version of 04c:
-Risk module date reference for Scanner
-Grain price


Hi - Are these files "independent" in that a person could download version 4c, get some data, play around with the new historical feature, and not interfere with downloads and analysis in their existing version which they've been using for a year or more?

Note: I realize the Excel files will need different names and maybe both shouldn't be open at the same time.

Reply With Quote
  #330 (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



CafeGrande View Post
Hi - Are these files "independent" in that a person could download version 4c, get some data, play around with the new historical feature, and not interfere with downloads and analysis in their existing version which they've been using for a year or more?

Note: I realize the Excel files will need different names and maybe both shouldn't be open at the same time.

Absolutely. All it needs is access to the unzipped pa2 files. As long as your other spreadsheet is not named the same you can have both open at the same time, but you'll only be able to run code in one of them at a time.

Reply With Quote
Thanked by:




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