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

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

Glad it was a help to you. SOM is short option minimum and risk is the highest risk in the risk array scenarios. The highest of the two is used for calculating initial margin. Price is the settlement price... Bid and ask prices do not show up in the risk arrays. I should have a newer spreadsheet available soon that should be even faster.

Sent from my Nexus 5 using Tapatalk

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
ZombieSqueeze
Platforms and Indicators
Are there any eval firms that allow you to sink to your …
Traders Hideout
Better Renko Gaps
The Elite Circle
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
 
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
  #152 (permalink)
Mo111
Detroit MI/USA
 
Posts: 21 since Jan 2014
Thanks Given: 12
Thanks Received: 10

thanks for the explanation. The excel sheet is extremely fast on my home computer. I am excited to see what the next update holds.

Btw, how is ROI calculated in the excel sheet?

I'm using ROI = (Option premium) / (Option total IM x 3), but its not the same number that it shows in the sheet.

Attached Thumbnails
Click image for larger version

Name:	screenshot.15.jpg
Views:	171
Size:	68.0 KB
ID:	134067  
Reply With Quote
  #153 (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


The spreadsheet uses (premium / (IM * variable)) / DTE * 30. The variable should be cell o2 on the risk tab. I think it was set to 2 when I uploaded it.

Sent from my Nexus 5 using Tapatalk

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

I would like to thank everybody who has contributed to that thread but especially @ron99 and @Dudetooth.
This thread is one of the most helpful and useful threads I've seen in years of watching forums like this.
Primarily because of this thread I have decided to upgrade to an elite membership (hoping there are other threads as valuable behind the elite gates.)
Thanks @ron99 and @Dudetooth again.

Reply With Quote
Thanked by:
  #155 (permalink)
CafeGrande
St Paul, MN, USA
 
Posts: 200 since Jan 2014
Thanks Given: 131
Thanks Received: 207

DudeTooth -

I downloaded v3 earlier today and so far, so good. I put in a couple of sample trades and a data date of Friday, January 17th and the results look right to me. So, a big thank you in advance because I think this tool can improve capital allocation and risk management and it's also a quick and easy way to compare which of my brokers is running at or close to SPAN. I know IB gets a bad rap from option sellers, and sometimes it's deserved; other times they are very close or lower than RJO, which seems to be fairly close to SPAN minimum).

Anyway, one question: I'm pretty sure I can change the cell formatting - fonts, text color, cell shading, column width, etc - without messing up any of your code behind the scenes, but what about conditional formatting? For example, if I enter a list of real positions, maybe I want all "Cs" (calls) to be in bold red text (cuz' that's where I usually get screwed) or maybe I want to color code (traffic light) the delta column for various ranges. Will conditional formatting screw anything up?

¡Muchas Gracias!

Reply With Quote
  #156 (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
Will conditional formatting screw anything up?

Conditional formatting / formatting in general should be fine. The code just messes with the values of the cells.

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

spanit utility

This is wierd. I consistently get errors using the spanit utility but as far as I can tell the error isn't actually causing any problems

My spanscript.txt file
Load C:\SPAN4\ice.20140120.pa5
Load C:\SPAN4\PORTFOLIO.pos
Calc
Save C:\SPAN4\Risk.xml
My SPAN-BATCH.bat file
c:\SPAN4\Bin\spanit.exe C:\SPAN4\SpanScript.txt
c:\SPAN4\RptModule\spanReport.hta C:\SPAN4\Risk.xml


and then


It's definitely not creating any log files anywhere.. but everything seems to be running correctly.
Any ideas??

riskreporter.exe utility

My RiskReporter-BATCH.bat file
C:\Span4\Bin\RiskReporter.exe C:\Span4\Risk.xml /PbReq_CSV /Pos_CSV /ScanRiskContr_CSV C:\Span4\Data\MySpanCalc.log
The only log file this seems to be creating is RiskReporter.txt in the SPAN4\ directory which says
RiskReporter® utility, version 4.37
Copyright© CME Group 2007-2011
Cannot open input file C:\Span4\Data\MySpanCalc.log
Input XML file: C:\Span4\Risk.xml
Loaded SPAN XML file C:\Span4\Risk.xml
List of generated Batch reports:
- /PbReq_CSV C:\Span4\PbReq.csv
- /Pos_CSV C:\Span4\NetPos.csv
- /ScanRiskContr_CSV C:\Span4\ScanRiskContr.csv
Return Value: 0
The program is creating NetPos.csv PbReq.csv & ScanRiskContr.csv correctly though so maybe I should worry.

Combining spanit & riskreporter.exe utilities

You can actually combine the spanit and riskreporter batch files and have a single file.

My spanscript.txt file
Load C:\SPAN4\ice.20140120.pa5
Load C:\SPAN4\PORTFOLIO.pos
Calc
Save C:\SPAN4\Risk.xml
My MEGA-BATCH.bat file
c:\SPAN4\Bin\spanit.exe C:\SPAN4\SpanScript.txt
c:\SPAN4\RptModule\spanReport.hta C:\SPAN4\Risk.xml
C:\Span4\Bin\RiskReporter.exe C:\Span4\Risk.xml /PbReq_CSV /Pos_CSV /ScanRiskContr_CSV C:\Span4\Data\MySpanCalc.log

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

SMCJB, on the first one I have no idea. What browser are you using and is it running something when you are running the script?

On the second one I'm not sure either. I see you have the different elements in different folders. I have everything in one folder. The Bin folder. I do output reports to a different folder.

I use SaveCalcSummary. You are just using Save. I don't know if that is a problem.

I probably wasn't much help. Sorry.

Started this thread Reply With Quote
  #159 (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 haven't used that utility in a few months, so I've forgotten quite a bit already. You batch and script look the same as the last versions I used. I set up a test and got the same error as your second (error saving the log). I still got the reports, but the rptBatch.log was not saved, nor the rptBatch.err. I'm pretty sure I had seen that error before, but I'm afraid I can't remember why it was happening or if I was able to fix it. CME's help file on it didn't really help other than to list the default locations where the reports and logs go.

If it were me, I'd just ignore the error ... your still getting the reports. Sorry, that probably wasn't much help either.

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



ron99 View Post
SMCJB, on the first one I have no idea. What browser are you using and is it running something when you are running the script?

I normally use Chrome but I get the error even with no browser open.


ron99 View Post
On the second one I'm not sure either. I see you have the different elements in different folders. I have everything in one folder. The Bin folder. I do output reports to a different folder.

I might try using different folders... everything keeps getting cluttered.

ron99 View Post
I use SaveCalcSummary. You are just using Save. I don't know if that is a problem.

Haven't tried that. Thanks for the tip.

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