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

  #281 (permalink)
 daydayup8 
tennessee/USA
 
Experience: Intermediate
Platform: Quotetracker, TOS
Broker: OX TOS
Trading: ES
Posts: 83 since Aug 2014
Thanks Given: 267
Thanks Received: 8

First, i put '10232014' on cell G, then i went to 'Set up' tab to click 'Save Dates', then I went back to 'Scanner' tab to clink 'Download Risk', then something like this pop out 'Calculating, please wait', it takes a few seconds, then disappeared.
Next step: After enter for column A-F, I clicked 'Scan All' button, something flashed for a second on my screen but nothing happened then.


Dudetooth View Post
daydayup8,

Did you grab the XLS-SPAN from post #2? I lost track, but I know that I did get the latest patched file linked on post #2.

Did you go through the instructions on the Setup tab? Section 2 covers downloading the pa2 files. All you need to do is enter the date (YYYYMMDD format, like 20141024) in cell G1 on the Scanner tab and then click the Download Risk button. It goes out and finds the right web address and downloads the pa2 files to your C:\SPAN4\DATA folder.

Once that is done then you can scan for trades or enter positions on the Tracker tab to follow their progress from day to day. I think that the Setup tab instructions cover all of that and there should be some example positions on the Tracker tab to show you how to set them up.

I hope this helps ... if not, just let me know.


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Build trailing stop for micro index(s)
Psychology and Money Management
Online prop firm The Funded Trader (TFT) going under?
Traders Hideout
ZombieSqueeze
Platforms and Indicators
Are there any eval firms that allow you to sink to your …
Traders Hideout
Futures True Range Report
The Elite Circle
 
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
23 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #282 (permalink)
 daydayup8 
tennessee/USA
 
Experience: Intermediate
Platform: Quotetracker, TOS
Broker: OX TOS
Trading: ES
Posts: 83 since Aug 2014
Thanks Given: 267
Thanks Received: 8

I did the whole process again and I checked the path 'C:\SPAN4\Data', I did not see any folder or data in this path.


Dudetooth View Post
All you need to do is enter the date (YYYYMMDD format, like 20141024) in cell G1 on the Scanner tab and then click the Download Risk button. It goes out and finds the right web address and downloads the pa2 files to your C:\SPAN4\DATA folder.


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



daydayup8 View Post
Frustrated...

I can try to troubleshoot things with you if you want. Shoot me a private message and we can go from there.

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


daydayup8 View Post
First, i put '10232014' on cell G, <snip>

@daydayup8 I believe you have to put the date in the sheet exactly in the same format as the template - so it should be 20141023. @Dudetooth can correct me if I'm wrong. As far as I can see the date template is year, month, day in the format: YYYYMMDD.

Reply With Quote
  #285 (permalink)
 daydayup8 
tennessee/USA
 
Experience: Intermediate
Platform: Quotetracker, TOS
Broker: OX TOS
Trading: ES
Posts: 83 since Aug 2014
Thanks Given: 267
Thanks Received: 8

sorry, I posed it wrong, but I actually typed '20141023' since Dudetooth had '20140829' there, I just modified his date.


Physicsman View Post
@daydayup8 I believe you have to put the date in the sheet exactly in the same format as the template - so it should be 20141023. @Dudetooth can correct me if I'm wrong. As far as I can see the date template is year, month, day in the format: YYYYMMDD.


Reply With Quote
  #286 (permalink)
 daydayup8 
tennessee/USA
 
Experience: Intermediate
Platform: Quotetracker, TOS
Broker: OX TOS
Trading: ES
Posts: 83 since Aug 2014
Thanks Given: 267
Thanks Received: 8

There is no data in the 'C:\SPAN4\DATA' path after I put '20141023' and then click 'Download Risk'.

Attached Thumbnails
Click image for larger version

Name:	SPAN_empty data.png
Views:	140
Size:	182.0 KB
ID:	163335  
Reply With Quote
  #287 (permalink)
 daydayup8 
tennessee/USA
 
Experience: Intermediate
Platform: Quotetracker, TOS
Broker: OX TOS
Trading: ES
Posts: 83 since Aug 2014
Thanks Given: 267
Thanks Received: 8

Thank you Dudetooth for your time and help, your program is so useful and amazing! I am fascinated by it when it is just running in front of my eyes, beautiful!!

I am confident that I can make some good trades from now on:-)

Nothing can express my appreciation, wish you a blessed day!

Cheers!

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

Hi - this is a (minor) caution about using the ATM IV figures in the CME SPAN files for long term tables and charts.

Below I've attached an image that compares CME SPAN IV on nat gas with the IV from three other sources.

Good news: there is very little variation across sources once you go out three or four months.
Bad news: the SPAN model seems to understate ATM IV in the nearby months.

This is not exhaustive research by any means, but CME ATM IV is also understated in grains (I noticed the issue a couple of weeks ago) and silver and probably other products. I don't know what causes it to be off in the nearby months and spot-on in the deferredes (it's not the interest rate input).

If you want precise historical data, you will probably need to get it elsewhere. If you just want to know the general range then the SPAN data is good enough for government work.

Attached Thumbnails
Click image for larger version

Name:	option models.PNG
Views:	172
Size:	24.5 KB
ID:	165125  
Reply With Quote
  #289 (permalink)
Textrader
Atlanta
 
Posts: 3 since Sep 2014
Thanks Given: 0
Thanks Received: 3


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





Dudetooth: I have tried several times to modify the code as suggested above on my Windows 8.1 - 64 bit laptop and continue to get the same error message. I am not sure if the 8.1 update affected the code, any suggestions? Thanks, Chris.

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



Textrader View Post
Dudetooth: I have tried several times to modify the code as suggested above on my Windows 8.1 - 64 bit laptop and continue to get the same error message. I am not sure if the 8.1 update affected the code, any suggestions? Thanks, Chris.

Chris,

Try this version. If you still get errors just post the details and I'll see if I can work it out for you.

Attached Files
Elite Membership required to download: XLS-SPAN (04b3) - Update.xls
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