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




 
 

PC-SPAN

 
vp62
Moscow Russia
 
Posts: 7 since Oct 2012
Thanks Given: 113
Thanks Received: 0

I used the spreadsheet as it was: CCH4 CCH4 C 3500 -1 etc., just changed the dates in A1.


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
Build trailing stop for micro index(s)
Psychology and Money Management
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Futures True Range Report
The Elite Circle
ZombieSqueeze
Platforms and Indicators
 
 
 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


vp62 View Post
Dudetooth,

I tried both versions of your software. When I enter a date and click the 'Download Risk Arrays' button it downloads, unzips and saves the risk arrays. But when I enter position data and click the Portfolio or Single Position buttons, nothing happens, just blank gray field in the Main Tab and almost all Zeroes in the Temp Tab. Am I doing something wrong?

Thank you in advance.

Is your spreadsheet in the same Windows folder as the risk arrays?

Started this thread
 
vp62
Moscow Russia
 
Posts: 7 since Oct 2012
Thanks Given: 113
Thanks Received: 0


The spreadsheet was in another folder. I moved it to the same folder as the risk arrays but nothing changed.

 
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274

In the Setup tab, did you set the default path?

By default the spreadsheet is assuming that you have PC-SPAN installed. If you don't, you need to change your default path so it knows where to download and where to find the files.

If that is not the issue, try typing in CCH4 CCH4 C 3500 -1 in row 4 again, click Single position, select any cell in row 4 and click ok. If there is nothing returned in the gray area on the Main tab, let me know if you see any data at all in the first 5 rows of the Temp tab.

 
vp62
Moscow Russia
 
Posts: 7 since Oct 2012
Thanks Given: 113
Thanks Received: 0

I have PC-SPAN installed and I see downloaded and uzipped Risk Array files in C:\Span4\Data Folder.
I typed in CCH4 CCH4 C 3500 -1 in row 4 again. There were nothing returned in the gray area and the first 5 rows in the Temp tab are blank.

 
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274

There's nothing wrong with macros running if you can confirm that the spreadsheet is downloading the risk arrays properly. The fact that rows 1-5 are blank on the Temp tab makes me think that it isn't finding the correct lines because of an error.

I'll private message you a copy of the spreadsheet I use for troubleshooting ... maybe we can figure out why it is giving you grief.

 
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274

vp62,

It just dawned on me that I don't think you won't be able to get the attachment if I do it through a private message, so here it is.

Please bear with me on this one and don't take it personally if the instructions seem too basic ... I'm just trying to locate the error.

I attached a 97/2003 version so it didn't have to be zipped and I hid the code that forces and exit when there is an error.

Please go through these steps:
-Open the spreadsheet and click Enable Macros if a security warning appears.
-On the Setup tab, click Set Default Path and navigate to the folder where you want the data and then click OK.
-On the Main tab click Download Risk Arrays to download the files for Dec10.
-When that is done, click Portfolio.

Please let me know the results. If an error is generated please let me know what is highlighted in the VBA. If any of this doesn't make sense just let me know.

Thanks.

Attached Files
Elite Membership required to download: Margin_Without_PC-SPANv2.xls
 
vp62
Moscow Russia
 
Posts: 7 since Oct 2012
Thanks Given: 113
Thanks Received: 0

I went through all the steps but unfortunately everything remained as it was. Nothing is highlighted in the VBA. There were the following files downloaded to my C:\Span4\Data folder - cme.20131210.s.pa2 and nyb.20131210.s.pa2.

 
 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

You should also have cme.s.pa2 & nyb.s.pa2 in the C:\Span4\Data Folder too.

Started this thread
 
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274



vp62 View Post
There were the following files downloaded to my C:\Span4\Data folder - cme.20131210.s.pa2 and nyb.20131210.s.pa2.

It seems like something is interrupting the code execution on your machine. The spreadsheet I sent you had code in it that should have renamed the cme.20131210.s.pa2 to cme.s.pa2, rename the nyb.20131210.s.pa2 to nyb.s.pa2, and then delete the zip files.

I'm not sure I know where to go from here. How familiar are you with editing VBA?


 



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