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

  #241 (permalink)
CafeGrande
St Paul, MN, USA
 
Posts: 200 since Jan 2014
Thanks Given: 131
Thanks Received: 207


BlueRoo View Post
CafeGrande,

Considering the Ib risk naviagator I am thinking that such groups could be at a product level or at a product contract. For example; Soyabeans or Soyabeans July and Soyabeans August.

It occurs to me that you may wish to manage the greeks for different months differently. So to lump a trade you have in july with a trade you have in August would be unhelpful.

Your work continues to impress!

And I agree with your comments above. I think the summary stats are most useful when presented by PRODUCT and then by month within that PRODUCT. The separation might not be that important in the financials or the metals, but as you know, futures prices and implied volatility can be very different across a three or four month range in the ags or energies.

In your working version, what happens if you have Sugar transactions across three brokerage accounts? Can you still summarize by Sugar, i.e. irrespective of brokerage account?

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Better Renko Gaps
The Elite Circle
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Build trailing stop for micro index(s)
Psychology and Money Management
 
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
36 thanks
NexusFi site changelog and issues/problem reporting
25 thanks
GFIs1 1 DAX trade per day journal
19 thanks
The Program
18 thanks
  #242 (permalink)
BlueRoo
Brisbane, Queensland, Australia
 
Posts: 121 since Aug 2013
Thanks Given: 75
Thanks Received: 97


CafeGrande View Post
In your working version, what happens if you have Sugar transactions across three brokerage accounts? Can you still summarize by Sugar, i.e. irrespective of brokerage account?

Cafe,


Well essential you can have as many sections or headers as you like and have the same position listed in more than one section. It would be just an issue of managing it which is why thework in the interace and user interactivity. Make it a easy as possible to do complex things quickly. So you could have 3 brokerage accounts with all your trades and then headers by product, and on you could go...so one of the each things to do is to copy a trade and then past it multiple times in different locations. (in my file this is not a copy paste as you would do normally in excel...it is storing values to variables, reapplying them and then running trackselect or trackspread on each past refreshed.)

Reply With Quote
  #243 (permalink)
 
eudamonia's Avatar
 eudamonia 
Sacramento, CA
 
Experience: None
Platform: None
Broker: ADM and Sierra Charts
Trading: ES, CL
Posts: 315 since Jul 2010
Thanks Given: 308
Thanks Received: 449


I'm just using the basic PC-SPAN program and for some reason I can no longer get it to calculate my margins. The data loads without an issue (files are the right size), but when I hit the calculate button nothing populates. Pretty sure it isn't the contract - I even tested front month regular ES futs to no avail. Tried rebooting the computer but no luck there.

Ever wonder why CME can't get out of 1991 and build some real software? Or perhaps just post their calcs on the website like ICE, LIFFE and everyone else

Visit my NexusFi Trade Journal Reply With Quote
  #244 (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


eudamonia View Post
I'm just using the basic PC-SPAN program and for some reason I can no longer get it to calculate my margins. The data loads without an issue (files are the right size), but when I hit the calculate button nothing populates. Pretty sure it isn't the contract - I even tested front month regular ES futs to no avail. Tried rebooting the computer but no luck there.

Ever wonder why CME can't get out of 1991 and build some real software? Or perhaps just post their calcs on the website like ICE, LIFFE and everyone else

Do you have any expired contracts you are trying to calculate?

I tried mine and it worked OK.

Sorry I wasn't much help.

Started this thread Reply With Quote
  #245 (permalink)
 
eudamonia's Avatar
 eudamonia 
Sacramento, CA
 
Experience: None
Platform: None
Broker: ADM and Sierra Charts
Trading: ES, CL
Posts: 315 since Jul 2010
Thanks Given: 308
Thanks Received: 449


eudamonia View Post
I'm just using the basic PC-SPAN program and for some reason I can no longer get it to calculate my margins. The data loads without an issue (files are the right size), but when I hit the calculate button nothing populates. Pretty sure it isn't the contract - I even tested front month regular ES futs to no avail. Tried rebooting the computer but no luck there.

Ever wonder why CME can't get out of 1991 and build some real software? Or perhaps just post their calcs on the website like ICE, LIFFE and everyone else

Ok so the lesson is don't try to calculate PC-Span after a long week and you are mentally exhausted. The problem was completely user error

Visit my NexusFi Trade Journal Reply With Quote
  #246 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,041 since Dec 2013
Thanks Given: 4,375
Thanks Received: 10,192


eudamonia View Post
Ever wonder why CME can't get out of 1991 and build some real software? Or perhaps just post their calcs on the website like ICE, LIFFE and everyone else

Interestingly ICE have rewritten SPAN and now have their own version with is far easier to use and much more intuitive. It's also a lot easier to set up portfolio's and what if scenario's and to automate batch process's. The result files are also a lot easier to read.

Unfortunately it only works for ICE contracts though as it requires a new type of SPAN file (SP5 or SP6).

ICE SPAN Overview
ICE SPAN Download
ICE SPAN User Guide (PDF)
ICE SPAN Files

Reply With Quote
Thanked by:
  #247 (permalink)
MGBRoadster
Lancashire UK
 
Posts: 52 since Jan 2013
Thanks Given: 42
Thanks Received: 32

My Avast antivirus has an alert:

Object: C:\...\XLS-SPAN.xls
Infection: MO97: Downloader-DF
Process: C:Program Files (x86)Microsoft Office\Office14\EXCEL.EXE

I've been using XLS-SPAN for several months without any problems, so I guess this is a false positive. Does anybody know what's happening here?


Thanks,

Chris

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

I use Avast and have never had that alert.

Started this thread Reply With Quote
  #249 (permalink)
 
Physicsman's Avatar
 Physicsman 
London + Great Britain
 
Experience: Master
Platform: Interactive Brokers, OptionsXpress, TradeMonster, RJO, AmiBroker, Wealthlab
Trading: Futures, Options, Equities
Posts: 19 since May 2013
Thanks Given: 85
Thanks Received: 25

@MGBRoadster

I had the same message over the weekend. The only way I got Avast to stop auto-deleting the Excel file was to put it in the exclusions list for the FileShield.

You can only put directory paths rather than a single file in the exclusions list. I reported it as a false positive to Avast, but so far their updates haven't taken that into account yet. Hopefully, it will resolve with some further definition updates from Avast.

Reply With Quote
Thanked by:
  #250 (permalink)
 kevinkdog   is a Vendor
 
Posts: 3,647 since Jul 2012
Thanks Given: 1,890
Thanks Received: 7,338



MGBRoadster View Post
My Avast antivirus has an alert:

Object: C:\...\XLS-SPAN.xls
Infection: MO97: Downloader-DF
Process: C:Program Files (x86)Microsoft Office\Office14\EXCEL.EXE

I've been using XLS-SPAN for several months without any problems, so I guess this is a false positive. Does anybody know what's happening here?


Thanks,

Chris

I've gotten it too. Must be an updated vrius database for Avast, and a new virus looks like the SPAN downloader code...

Follow me on Twitter 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