PC-SPAN (Page 17) - 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,589 / 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 25th, 2014, 01:52 PM   #161 (permalink)
Market Wizard
Houston TX
 
Futures Experience: Advanced
Platform: XTrader
Broker/Data: Advantage Futures
Favorite Futures: Energy
 
Posts: 1,587 since Dec 2013
Thanks: 1,395 given, 2,362 received
Forum Reputation: Legendary


Dudetooth View Post
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.

I've been having the error consistently for several weeks, doesn't seem to effect anything. I wouldn't worry except that I'm finally about to start automating the dozens of portfolio's I'm running and their reports and am worried that the error message will cause the code execution to break. I might try contacting CME but in my past experience their customer service is not good.

Reply With Quote
     

Old January 25th, 2014, 03:27 PM   #162 (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

SMCJB,

I think I may have a solution for you.

Try running your "c:\SPAN4\RptModule\spanReport.hta C:\SPAN4\Risk.xml" as a separate batch file and have it placed in the "C:\Span4\RptModule" or any other subfolder within "C:\Span4". It appears as though the spanReport.hta is looking to find the Reports folder in a particular location.

One the error it states: "..//reports/rptBatch.log" which looks sort of like the old DOS command when you would type in "CD.." backing you out one folder level. When I did this it ran the reports and did not generate an error. Even tried placing it in the "C:\Span4\Data" and it worked as well.

Reply With Quote
     

Old February 4th, 2014, 11:00 PM   #163 (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


Hi @Dudetooth,

I'm using your spreadsheet to do some backtesting - I'm looking up prior option premiums for a certain strike in the past at different dates. It works well by typing in the prior date in the past in A1, and then downloading the data, and then copying down the premium and IM. Then I'd repeat with another date.

I was wondering if there is anyway to put in multiple dates, and have it download and calculate the margin and premium at a certain strike for different dates?

Thanks!

Reply With Quote
     

Old February 5th, 2014, 06:46 AM   #164 (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


Mo111 View Post
I was wondering if there is anyway to put in multiple dates, and have it download and calculate the margin and premium at a certain strike for different dates?

If you can hang on a few more days, I'm ironing out the last few kinks in a new spreadsheet that includes the ability to track an option history. I'm hoping to post it by this weekend at the latest.

Thanks.

Reply With Quote
     
The following user says Thank You to Dudetooth for this post:
     

Old February 8th, 2014, 08:07 PM   #165 (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

XLS-SPAN

Futures Edge on FIO

Are you a NinjaTrader user?

 
Here's the latest and greatest.

Here's a few of the features:
-Added Scanner and Historic tools
-Internalized calculations to eliminate the need of a Temp tab
-Extracted more data from pa2 files, reducing need for data to present in the code and making it easier to add new commodities
-Increased the speed of the code by utilizing arrays to minimize the number of times the pa2 files need to be scanned
-Added the ability to select SPAN or Total IM
-Added futures price, historic volatility and implied volatility to option data extracted

Special thanks to Ron, Kevin and Jay for ideas and troubleshooting to help me make this better.

Beta updates:
-Fixed ROI sort on scanner to include column G
-Fixed contract sort on scanner to include column G
-Fixed contract sort on scanner to sort by futures then option then strike
-Fixed issue with SOM compounding on tracker that was calculating incorrect margin
-Added sort ROI / contract on tracker
-Added erase all results on tracker
-Cell A3 is now selected on historic after changing dates / before running calculations
-Fixed blank rows causing error in calculation
-Changed ROI to 365/DTE/12*net premium/(IM*IM Multiplier)
-Changed instructions on hist tracker added a helpful hints form
-pa2 files are now saved with date in name unless Setup A18 is changed, then back to old way
-Added clear tracker results if no option data in columns A-D
-Cabinet settlement price displayed as 0.5
-Fixed grain price adjustment
-Added more date tools for historic
-Fixed error with option at expiration causing error in calculations

Enjoy.

Attached Files
Register to download File Type: xls XLS-SPAN.xls (679.0 KB, 187 views)
Reply With Quote
     
The following 20 users say Thank You to Dudetooth for this post:
     

Old February 8th, 2014, 09:36 PM   #166 (permalink)
Elite Member
London + Great Britain
 
Futures Experience: Master
Platform: Interactive Brokers, OptionsXpress, TradeMonster, RJO, AmiBroker, Wealthlab
Favorite Futures: Futures, Options, Equities
 
Physicsman's Avatar
 
Posts: 19 since May 2013
Thanks: 85 given, 23 received

Wow!

Just clicking the "Thanks" button wasn't adequate to express just how extraordinarily good your Excel SPAN margin calculator sheet is now!! I'm pretty much out of superlatives - I think "Wow" gets close though!

Thank you very much @Dudetooth!! It is appreciated more than you could know!

Reply With Quote
     

Old February 8th, 2014, 09:39 PM   #167 (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

Thank you @Dudetooth! This excel sheet will definitely open up new ways to analyze and backtest strategies.

I'm having trouble with the spreadsheet. I have Windows 8 64 bit and excel 2010. I got this error when I click on anything in the sheet:


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



Any thoughts? I had no trouble using the previous (v3) sheet.

Reply With Quote
     

Old February 8th, 2014, 10:07 PM   #168 (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


Mo111 View Post
Any thoughts? I had no trouble using the previous (v3) sheet.

A minor addition seems to be the source of the problem.


In the Functions Module delete:

'Written: October 07, 2007
'Author: Leith Ross
'Summary: Add Minimize, and Maximize/Restore buttons to a VBA UserForm

Private Const GWL_STYLE As Long = -16
Public Const MIN_BOX As Long = &H20000
Public Const MAX_BOX As Long = &H10000

Const SC_CLOSE As Long = &HF060
Const SC_MAXIMIZE As Long = &HF030
Const SC_MINIMIZE As Long = &HF020
Const SC_RESTORE As Long = &HF120

Private Declare Function GetWindowLong _
Lib "user32.dll" _
Alias "GetWindowLongA" _
(ByVal hwnd As Long, _
ByVal nIndex As Long) As Long

Private Declare Function SetWindowLong _
Lib "user32.dll" _
Alias "SetWindowLongA" _
(ByVal hwnd As Long, _
ByVal nIndex As Long, _
ByVal dwNewLong As Long) As Long

'Redraw the Icons on the Window's Title Bar
Private Declare Function DrawMenuBar _
Lib "user32.dll" _
(ByVal hwnd As Long) As Long

'Returns the Window Handle of the Window accepting input
Private Declare Function GetForegroundWindow _
Lib "user32.dll" () As Long

Public Sub AddToForm(ByVal Box_Type As Long)

Dim BitMask As Long
Dim Window_Handle As Long
Dim WindowStyle As Long
Dim Ret As Long

If Box_Type = MIN_BOX Or Box_Type = MAX_BOX Then
Window_Handle = GetForegroundWindow()

WindowStyle = GetWindowLong(Window_Handle, GWL_STYLE)
BitMask = WindowStyle Or Box_Type

Ret = SetWindowLong(Window_Handle, GWL_STYLE, BitMask)
Ret = DrawMenuBar(Window_Handle)
End If

End Sub


View the code of the Help form and delete:

Private Sub UserForm_Activate()
AddToForm MIN_BOX
End Sub

Reply With Quote
     

Old February 8th, 2014, 10:38 PM   #169 (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


Dudetooth View Post
A minor addition seems to be the source of the problem.


In the Functions Module delete:

It worked like charm! This excel sheet is truly amazing. I still cant believe it can do all this. My jaw literally just dropped.

WOW @Dudetooth

Thank you!


Reply With Quote
     

Old February 9th, 2014, 12:07 AM   #170 (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


Thanks again! Very impressive. I think adding the volatility measures can help everyone become a better risk manager, if not trader.

One question: Does the PC-SPAN documentation tell you how many trading days are used for the historical volatility (HV) calculation, and does the day count vary across exchanges?

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)
 

Trading Technologies: ADL hands-on

Dec 13

Normal webinar schedule resumes after the holidays

January

Ernie Chan: Risk Management

Elite only

Dedicated Trading Servers: Advantages/Disadvantages w/sam028

Elite only

An Afternoon with FIO member Massive I

Elite only

Leo Murphy: TBA

Elite only
     

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 02:58 AM.

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-10 in 0.15 seconds with 20 queries on phoenix via your IP 54.167.129.169