PC-SPAN - Options on Futures | futures io social day trading
futures io futures trading


PC-SPAN
Updated: Views / Replies:53,958 / 478
Created: by ron99 Attachments:113

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • 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.

-- Big Mike, Site Administrator

Reply
 113  
 
Thread Tools Search this Thread
 

PC-SPAN

  #251 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 214 since Sep 2012
Thanks: 26 given, 240 received


MGBRoadster View Post
My Avast antivirus has an alert:

Object: C:\...\XLS-SPAN.xls
Infection: MO97: Downloader-DF
Process: C:Program Files (x86)Microsoft Office\Office14\EXCEL.EXE

I've been using XLS-SPAN for several months without any problems, so I guess this is a false positive. Does anybody know what's happening here?


Thanks,

Chris

I came across this over the weekend as well. I tracked it down to the SaveWebFile function ... I think that the process it uses ("MSXML2.XMLHTTP") is causing the hit for the anti-virus software. I submitted a copy to a couple of sites to have it checked just to be sure.

In the mean time, you can get the spreadsheet operational again by doing the following:
-Delete the SaveWebFile function, should be in the Functions module
-Add the following code to the top of the Funtion module:

Private Declare Function URLDownloadToFileA Lib "urlmon" (ByVal pCaller As Long, _
ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long

Private Function SaveWebFile (URL As String, LocalFilename As String) As Boolean
Dim lngRetVal As Long
lngRetVal = URLDownloadToFileA(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then DownloadFile = True
End Function


This method of downloading the PA2 file does not seem to cause any grief with the anti-virus software and should be all the editing that is needed (not sure which version of the spreadsheet you have). If it doesn't work, just let me know which version you are using and I should be able to get it fixed up for you.

Hope this helps.

Note: If Avast keeps auto-deleting your file (placing it in the virus chest) you can turn Avast off temporarily, restore the spreadsheet, edit the code, and then turn Avast back on.

Update...

Sorry, small mistake ... code should look like this:

Private Declare Function URLDownloadToFileA Lib "urlmon" (ByVal pCaller As Long, _
ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long

Private Function SaveWebFile (URL As String, LocalFilename As String) As Boolean
Dim lngRetVal As Long
lngRetVal = URLDownloadToFileA(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then SaveWebFile = True
End Function


Last edited by Dudetooth; August 11th, 2014 at 08:25 PM. Reason: Fixed mistake in code
Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
  #252 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 46,165 since Jun 2009
Thanks: 29,276 given, 82,773 received

Use the site:

https://www.virustotal.com

And it will test the file against a bunch of engines, and you can make an informed decision about false positives.

Mike

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
 
  #253 (permalink)
Trading for Fun
Lancashire UK
 
Futures Experience: Intermediate
Platform: Tradestation, Interactive Brokers, OX
Favorite Futures: ES Z CL EURJPY
 
Posts: 52 since Jan 2013
Thanks: 42 given, 30 received



Dudetooth View Post
In the mean time, you can get the spreadsheet operational again by doing the following:
-Delete the SaveWebFile function, should be in the Functions module
-Add the following code to the top of the Funtion module:

... code should look like this:

Private Declare Function URLDownloadToFileA Lib "urlmon" (ByVal pCaller As Long, _
ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long

Private Function SaveWebFile (URL As String, LocalFilename As String) As Boolean
Dim lngRetVal As Long
lngRetVal = URLDownloadToFileA(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then SaveWebFile = True
End Function

Sorry Dudetooth - old guy here, I've never used Visual basic before

I've gone to the Functions page and deleted the section of text that contains SaveWebfile, and added your new code at the top of the page. I get a
"Compile error: Only comments may appear after the End Sub, End Function or End Property"

and the following text is highlighted:
" Private Declare Function GetWindowLong _
Lib "user32.dll" _
Alias "GetWindowLongA" _
(ByVal hwnd As Long, _
ByVal nIndex As Long) As Long "

I'm not sure how to find out which version of the spreadsheet I have, so I tried downloading the latest version from the first page of this thread. I had the same issue again, but when I try to download it now I get a "The file is corrupt and cannot be opened" error.

I'm probably making an obvious mistake.

Reply With Quote
 
  #254 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 214 since Sep 2012
Thanks: 26 given, 240 received


MGBRoadster View Post
Sorry Dudetooth - old guy here, I've never used Visual basic before.

I'll get a patched version of the spreadsheet out for you.

Reply With Quote
 
  #255 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 214 since Sep 2012
Thanks: 26 given, 240 received

Patched XLS-SPAN

Here is a patched version of the last XLS-SPAN that uses a different download method that is not throwing false positives with the anti-virus.

I did check the code with the VirusTotal that Big Mike suggested. Off 53 anti-virus programs, the code caused hits on four, including Avast. After the code used to save web files was switched out with the code used in the attached spreadsheet only one anti-virus still showed a hit ... TheHacker. From a quick search online it seems as though TheHacker has a bit of a history with false positives.

I also submitted the file to Avast. They recommended that I try updating my version of Avast and virus definitions to alleviate the false positive.

Just wanted to share what I found.

Attached Files
Register to download File Type: xls XLS-SPAN (04b) - Update.xls (673.0 KB, 41 views)
Reply With Quote
The following 4 users say Thank You to Dudetooth for this post:
 
  #256 (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
Here is a patched version of the last XLS-SPAN that uses a different download method that is not throwing false positives with the anti-virus.

I did check the code with the VirusTotal that Big Mike suggested. Off 53 anti-virus programs, the code caused hits on four, including Avast. After the code used to save web files was switched out with the code used in the attached spreadsheet only one anti-virus still showed a hit ... TheHacker. From a quick search online it seems as though TheHacker has a bit of a history with false positives.

I also submitted the file to Avast. They recommended that I try updating my version of Avast and virus definitions to alleviate the false positive.

Just wanted to share what I found.

Hi Dudetooth,

I've been using your excel sheet here - and decided to move over to the 04b excel sheet as the "track all" feature would save me a lot of time with each of my spreads/strangles.

I'm getting different calculations for margin though between the two excel files - heres an example of my CL strangle:

version 3 sheet - $86 margin:

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


version 4b - $53 margin:

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


All of the settings on the first sheet are the same: path, Total IM, commissions, save dates. Also, the scan date is the same 8/29/2014.

Reply With Quote
 
  #257 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 214 since Sep 2012
Thanks: 26 given, 240 received


Mo111 View Post
I'm getting different calculations for margin though between the two excel files

Mo111,

Thanks for finding this error ... the 4b version was not adding the short option minimum for both legs ... $86 is correct. You won't normally see this unless you are very far out of the money (which these are) and then the short option minimum is greater than the risk scenarios so that it becomes the basis of the initial margin. I've fixed this issue and have re-posted the spreadsheet.

Attached Files
Register to download File Type: xls XLS-SPAN (04b) - Update.xls (652.5 KB, 195 views)
Reply With Quote
The following 6 users say Thank You to Dudetooth for this post:
 
  #258 (permalink)
Trading Apprentice
Boston MA
 
Futures Experience: None
Platform: NinjaTrader
Favorite Futures: Forex
 
Posts: 5 since Apr 2014
Thanks: 1 given, 0 received

Can't install PC SPAN

Hello everyone,

I use win8 64 bit. I have downloaded pc-span 4.5 from CME yet can't install it. The message says unexpected error with the package?? error code 2502 and 2503.


Anyone could help? Thank you!!!

Attached Thumbnails
PC-SPAN-2502.jpg   PC-SPAN-2503.jpg  
Reply With Quote
 
  #259 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 214 since Sep 2012
Thanks: 26 given, 240 received


cubcub View Post
Hello everyone,

I use win8 64 bit. I have downloaded pc-span 4.5 from CME yet can't install it. The message says unexpected error with the package?? error code 2502 and 2503.


Anyone could help? Thank you!!!


There is no issues with Win7 64bit, but it could be Win8 security ... found this referring to error 2502 and 2503:

Windows 8 has increased security measures which prevent standard users from installing 3rd party applications. If you see error 2502 or 2503 while installing, that means your account does not have administrator permissions to install software.

Solution 1:

Make sure your Windows account has the highest level of security permissions. Refer to Windows documentation for your operating system on how to do this.

Solution 2:

Run the installation file "As Administrator":

1. Find the installation file on your computer. Normally you have the option to save or run an installation file when downloading from the Internet. If you do not know where the file was downloaded, check the Downloads folder in File Explorer.

2. Right-click the file and select Run As Administrator* from the pop-up menu.

Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
  #260 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 196 since Jan 2014
Thanks: 117 given, 191 received


DudeTooth -

I have a selfish request unrelated to the issue immediately above.

Would it take a lot of work to add the Kansas City (KE) wheat contract to your application? It doesn't have the liquidity of the Chicago contract, but now that they're both under the CME umbrella, that may change.

No rush ... I can keep tabs on my KE positions elsewhere, but if it fits into a future release, great!

Reply With Quote

Reply



futures io > > > > PC-SPAN

Thread Tools Search this Thread
Search this Thread:

Advanced Search



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

RandBots: AutoTrading Bots to diversify your trading

Oct 24
 

TopstepTrader: Profiting Without Risking Your Own Money

Oct 26

Building Open Source Indicators for NT8 w/Fat Tails @ Lizard Indicators

Elite only
     

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


All times are GMT -4. The time now is 11:19 PM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@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 2017-10-19 in 0.15 seconds with 20 queries on phoenix via your IP 54.166.232.243