PC-SPAN (Page 16) - Options on Futures | futures.io
futures.io futures trading
 

Go Back   futures.io

> Futures Trading, News, Charts and Platforms > Traders Hideout > Options on Futures


PC-SPAN
Started:October 23rd, 2013 (09:36 AM) by ron99 Views / Replies:41,373 / 403
Last Reply:November 19th, 2016 (08:49 AM) Attachments:100

Welcome to futures.io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.


You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike
     

Reply
 100  
 
Thread Tools Search this Thread

PC-SPAN

Old January 21st, 2014, 08:04 AM   #151 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 179 since Sep 2012
Thanks: 24 given, 198 received

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
     

Old January 21st, 2014, 09:00 AM   #152 (permalink)
Trading Apprentice
Detroit MI/USA
 
Futures Experience: Beginner
Platform: OEC
Favorite Futures: CL,6E,6B,ES
 
Posts: 21 since Jan 2014
Thanks: 12 given, 9 received

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
PC-SPAN-screenshot.15.jpg  
Reply With Quote
     

Old January 21st, 2014, 09:28 AM   #153 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 179 since Sep 2012
Thanks: 24 given, 198 received


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
     

Old January 21st, 2014, 02:17 PM   #154 (permalink)
Market Wizard
Houston TX
 
Futures Experience: Advanced
Platform: XTrader
Broker/Data: Advantage Futures
Favorite Futures: Energy
 
Posts: 1,580 since Dec 2013
Thanks: 1,392 given, 2,346 received
Forum Reputation: Legendary

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
     
The following user says Thank You to SMCJB for this post:
     

Old January 21st, 2014, 08:21 PM   #155 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 189 since Jan 2014
Thanks: 108 given, 171 received

Futures Edge on FIO
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
     

Old January 21st, 2014, 08:30 PM   #156 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 179 since Sep 2012
Thanks: 24 given, 198 received


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
     
The following user says Thank You to Dudetooth for this post:
     

Old January 24th, 2014, 12:04 AM   #157 (permalink)
Market Wizard
Houston TX
 
Futures Experience: Advanced
Platform: XTrader
Broker/Data: Advantage Futures
Favorite Futures: Energy
 
Posts: 1,580 since Dec 2013
Thanks: 1,392 given, 2,346 received
Forum Reputation: Legendary

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
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


and then
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


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
     

Old January 24th, 2014, 10:06 AM   #158 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,323 since Jul 2011
Thanks: 634 given, 3,899 received
Forum Reputation: Legendary

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.

Reply With Quote
     

Old January 25th, 2014, 08:48 AM   #159 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 179 since Sep 2012
Thanks: 24 given, 198 received

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
     

Old January 25th, 2014, 01:48 PM   #160 (permalink)
Market Wizard
Houston TX
 
Futures Experience: Advanced
Platform: XTrader
Broker/Data: Advantage Futures
Favorite Futures: Energy
 
Posts: 1,580 since Dec 2013
Thanks: 1,392 given, 2,346 received
Forum Reputation: Legendary



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
     

Reply



futures.io > Futures Trading, News, Charts and Platforms > Traders Hideout > Options on Futures > PC-SPAN

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)
 

NinjaTrader 8: Features and Enhancements, Tips and Tricks

Dec 6
 

Al Brooks: Stop Losing when a Good Trade goes Bad, Correcting Mistakes

Elite only
 

Trading Technologies: Algo Design Lab hands-on

Dec 13
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Current PC Specs tderrick Tech Support 45 October 28th, 2012 04:40 PM
Any PC Gamers in here? forrestang Off-Topic 61 October 10th, 2012 03:37 PM
Virtual PC setup how? boze man Tech Support 5 September 8th, 2012 04:59 PM
I need PC help Boomer34 Tech Support 5 January 22nd, 2012 03:28 PM
PC Question NMTrader Off-Topic 0 July 12th, 2009 11:56 PM


All times are GMT -4. The time now is 03:51 PM.

Copyright © 2016 by futures.io. 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.
 
no new posts

Page generated 2016-12-02 in 0.14 seconds with 20 queries on phoenix via your IP 54.146.141.60